A program must be written which accepts date parameter. The
date parameter will accept data in the format DD/MM/YYYY.
This data has to be validated and post validation, the
following details have to be displayed for this date
parameter
1. Input date must be defaulted to sysdate, It can be
overridden by any other date.
2. Financial year should be displayed for this date
parameter.
Eg: If the input date is 30/11/2010, the financial year
must be displayed as
1. From Date : 01-Aprr-2010
To Date: 31-Mar-2011
3. Calendar year and Calendar month must also be
displayed.
4. The next payment cycle (say for EB), must be
displayed based on this date parameter.
5. The previous payment must also be displayed based
on this date.
No Answer is Posted For this Question
Be the First to Post Answer
how can u find the status in po?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Who information?s?
wht is the use of Xml reports over reports6i?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
what is tuning in oracle apps technical
The report output is 10 pages then how many times between pages report trigger will fire?
what are the receipt types in Po?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
what is trace file? what is the use of that?
How can u call a standard interface program from sql or pl/sql code?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.