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_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_ALL_PAYROLLS_F

Line 282: ,pay_all_payrolls_f PAPF

278: ,per_assignments_f paf
279: ,per_periods_of_service pps
280: ,pay_ie_paye_details_f payef -- 10277535
281: ,pay_ie_prsi_details_f prsif
282: ,pay_all_payrolls_f PAPF
283: WHERE
284: NVl('N','N') = 'N'
285: and to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') between cp_start_date and cp_end_date
286: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/

Line 363: from pay_all_payrolls_f PAPF1

359: and PAPF.business_group_id + 0 = p_business_group_id /*4483028*/
360: and PAPF.payroll_id = nvl(p_payroll_id,papf.payroll_id)
361: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
362: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
363: from pay_all_payrolls_f PAPF1
364: where PAPF1.payroll_id = PAPF.payroll_id
365: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
366: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
367: )

Line 452: pay_all_payrolls_f papf,

448: CURSOR cur_paye_ref(c_assignment_id per_all_assignments.assignment_id%type
449: ,c_person_id per_all_people_f.person_id%type) IS
450: SELECT scl.segment4 paye_ref
451: FROM per_all_assignments_f paaf,
452: pay_all_payrolls_f papf,
453: hr_soft_coding_keyflex scl
454: WHERE paaf.person_id = c_person_id
455: AND paaf.assignment_id=c_assignment_id
456: AND paaf.payroll_id = papf.payroll_id

Line 459: from pay_all_payrolls_f PAPF1

455: AND paaf.assignment_id=c_assignment_id
456: AND paaf.payroll_id = papf.payroll_id
457: /* 9255733 */
458: AND papf.effective_end_date = (select max(PAPF1.effective_end_date)
459: from pay_all_payrolls_f PAPF1
460: where PAPF1.payroll_id = papf.payroll_id
461: and PAPF1.effective_start_date <= cp_end_date
462: and PAPF1.effective_end_date >= cp_start_date
463: )

Line 491: ,pay_all_payrolls_f pay

487:
488: SELECT max(pps.period_of_service_id)
489: FROM per_periods_of_service pps
490: ,per_assignments_f asg
491: ,pay_all_payrolls_f pay
492: ,hr_soft_coding_keyflex flex
493: WHERE pps.person_id = v_person_id
494: AND pps.person_id = asg.person_id
495: AND asg.period_of_service_id <> pps.period_of_service_id