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 292: per_all_assignments_f paf

288: SELECT paa_init.assignment_id,
289: paa_init.assignment_action_id
290: FROM pay_assignment_actions paa_init,
291: pay_payroll_actions ppa_init,
292: per_all_assignments_f paf
293: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
294: AND ppa_init.action_type='I'
295: AND ppa_init.business_group_id = l_bg_id
296: AND paf.business_group_id = l_bg_id

Line 2461: per_all_assignments_f ASSIGN

2457: IS
2458: SELECT SERVICE.date_start
2459: FROM
2460: /* Person current period of service date details */
2461: per_all_assignments_f ASSIGN
2462: , per_periods_of_service SERVICE
2463: WHERE p_payroll_date BETWEEN ASSIGN.effective_start_date
2464: AND ASSIGN.effective_end_date
2465: AND ASSIGN.assignment_id = p_assignment_id

Line 2610: per_all_assignments_f assign,

2606:
2607:
2608: CURSOR csr_emplr_class IS
2609: SELECT target.org_information3 FROM
2610: per_all_assignments_f assign,
2611: hr_soft_coding_keyflex scl,
2612: hr_organization_information target
2613: WHERE assign.assignment_id = p_assignment_id
2614: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date

Line 4172: per_all_assignments_f paf,

4168: SELECT pps.actual_termination_date
4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa,
4171: per_time_periods ptp,
4172: per_all_assignments_f paf,
4173: per_periods_of_service pps
4174: WHERE paa.assignment_action_id = p_assignment_action_id
4175: AND ppa.payroll_action_id = paa.payroll_action_id
4176: AND ptp.payroll_id = ppa.payroll_id