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_PAYMENT_SUMMARY dependencies on PER_TIME_PERIODS

Line 3062: per_time_periods ptp

3058: ,MAX(paa.action_sequence) action_sequence
3059: FROM pay_assignment_actions paa,
3060: pay_payroll_actions ppa,
3061: per_assignments_f paf,
3062: per_time_periods ptp
3063: WHERE paa.assignment_id = paf.assignment_id
3064: AND paf.assignment_id = c_assignment_id
3065: AND ppa.payroll_action_id = paa.payroll_action_id
3066: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 9527: per_time_periods ptp

9523: max(paa.assignment_action_id) -- Bug: 3095919, Bug 2610141
9524: from per_assignments_f paf,
9525: pay_payroll_Actions ppa,
9526: pay_assignment_Actions paa,
9527: per_time_periods ptp
9528: where ppa.payroll_Action_id = paa.payroll_Action_id
9529: and paa.assignment_id = c_assignment_id
9530: and paf.assignment_id = c_assignment_id
9531: and paf.assignment_id = paa.assignment_id

Line 9688: ,per_time_periods ptp

9684:
9685: cursor csr_get_fw_status_exist (c_date date) is
9686: select 'Y'
9687: from per_all_assignments_f paa
9688: ,per_time_periods ptp
9689: ,per_assignment_status_types past
9690: where paa.assignment_id = p_assignment_id
9691: and paa.payroll_id = ptp.payroll_id
9692: and c_date = ptp.end_date