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_IN_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 362: per_all_assignments_f paf

358: SELECT paa_init.assignment_id,
359: paa_init.assignment_action_id
360: FROM pay_assignment_actions paa_init,
361: pay_payroll_actions ppa_init,
362: per_all_assignments_f paf
363: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
364: AND ppa_init.action_type='I'
365: AND ppa_init.business_group_id = l_bg_id
366: AND paf.business_group_id = l_bg_id

Line 2673: per_all_assignments_f ASSIGN

2669: IS
2670: SELECT SERVICE.date_start
2671: FROM
2672: /* Person current period of service date details */
2673: per_all_assignments_f ASSIGN
2674: , per_periods_of_service SERVICE
2675: WHERE p_payroll_date BETWEEN ASSIGN.effective_start_date
2676: AND ASSIGN.effective_end_date
2677: AND ASSIGN.assignment_id = p_assignment_id

Line 2822: per_all_assignments_f assign,

2818:
2819:
2820: CURSOR csr_emplr_class IS
2821: SELECT target.org_information3 FROM
2822: per_all_assignments_f assign,
2823: hr_soft_coding_keyflex scl,
2824: hr_organization_information target
2825: WHERE assign.assignment_id = p_assignment_id
2826: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date

Line 4397: per_all_assignments_f paf,

4393: SELECT pps.actual_termination_date
4394: FROM pay_payroll_actions ppa,
4395: pay_assignment_actions paa,
4396: per_time_periods ptp,
4397: per_all_assignments_f paf,
4398: per_periods_of_service pps
4399: WHERE paa.assignment_action_id = p_assignment_action_id
4400: AND ppa.payroll_action_id = paa.payroll_action_id
4401: AND ptp.payroll_id = ppa.payroll_id