eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2827: c_fin_date per_assignment_extra_info.aei_information1%TYPE)

2823: AND pay.payroll_id = paaf.payroll_id
2824: AND paaf.effective_end_date BETWEEN pay.effective_start_date AND pay.effective_end_date;
2825:
2826: cursor c_payment_summary_details(c_assignment_id number,
2827: c_fin_date per_assignment_extra_info.aei_information1%TYPE)
2828: is
2829: select hr.meaning fin_year
2830: from per_assignment_extra_info pae,
2831: hr_lookups hr

Line 2830: from per_assignment_extra_info pae,

2826: cursor c_payment_summary_details(c_assignment_id number,
2827: c_fin_date per_assignment_extra_info.aei_information1%TYPE)
2828: is
2829: select hr.meaning fin_year
2830: from per_assignment_extra_info pae,
2831: hr_lookups hr
2832: where pae.aei_information_category = 'HR_PS_ISSUE_DATE_AU'
2833: and pae.information_type = 'HR_PS_ISSUE_DATE_AU'
2834: and pae.assignment_id = c_assignment_id

Line 3005: l_fin_year_code per_assignment_extra_info.aei_information1%TYPE;

3001: l_assignment_id number;
3002:
3003: l_fin_year varchar2(80);
3004: l_action_sequence number;
3005: l_fin_year_code per_assignment_extra_info.aei_information1%TYPE;
3006: l_balance_flag varchar2(1);
3007:
3008: l_max_asg_action_id number; /*Bug 4040688*/
3009: l_max_action_sequence number; /*Bug 4040688*/