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_YEAR_END_EXTRACT dependencies on PAY_PAYROLL_ACTIONS

Line 478: ,pay_payroll_actions PACT

474: ,pay_run_results RR
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP

Line 480: ,pay_payroll_actions BACT

476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP
483: ,pay_assignment_actions BAL_ASSACT
484: where BAL_ASSACT.assignment_action_id = cp_l_asg_id

Line 1066: from pay_payroll_actions pact,

1062: UPDATE PAY_GB_YEAR_END_ASSIGNMENTS ye_asg
1063: SET (LAST_ASG_ACTION_ID, LAST_EFFECTIVE_DATE) = (
1064: select assact.assignment_action_id,
1065: pact.effective_date
1066: from pay_payroll_actions pact,
1067: pay_assignment_actions assact
1068: where assact.payroll_action_id = pact.payroll_action_id
1069: and ye_asg.assignment_id = assact.assignment_id
1070: and ye_asg.request_id = p_request_id

Line 1075: pay_payroll_actions pact2,

1071: and assact.action_sequence =
1072: (
1073: select max(assact2.action_sequence)
1074: from pay_assignment_actions assact2,
1075: pay_payroll_actions pact2,
1076: pay_gb_year_end_payrolls ye_roll
1077: where assact2.assignment_id = ye_asg.assignment_id
1078: and assact2.payroll_action_id = pact2.payroll_action_id
1079: and pact2.payroll_id = ye_roll.payroll_id

Line 1090: pay_payroll_actions pact3

1086: and not exists(
1087: select '1'
1088: from pay_action_interlocks pai,
1089: pay_assignment_actions assact3,
1090: pay_payroll_actions pact3
1091: where pai.locked_action_id = assact2.assignment_action_id
1092: and pai.locking_action_id = assact3.assignment_action_id
1093: and pact3.payroll_action_id = assact3.payroll_action_id
1094: and pact3.action_type = 'V'

Line 1236: from pay_payroll_actions pact,

1232: UPDATE PAY_GB_YEAR_END_ASSIGNMENTS ye_asg
1233: SET (PREVIOUS_YEAR_ASG_ACTION_ID, PREVIOUS_YEAR_EFFECTIVE_DATE) = (
1234: select assact.assignment_action_id,
1235: pact.effective_date
1236: from pay_payroll_actions pact,
1237: pay_assignment_actions assact
1238: where assact.payroll_action_id = pact.payroll_action_id
1239: and ye_asg.assignment_id = assact.assignment_id
1240: and ye_asg.request_id = p_request_id

Line 1245: pay_payroll_actions pact2,

1241: and assact.action_sequence =
1242: (
1243: select max(assact2.action_sequence)
1244: from pay_assignment_actions assact2,
1245: pay_payroll_actions pact2,
1246: pay_gb_year_end_payrolls ye_roll
1247: where assact2.assignment_id = ye_asg.assignment_id
1248: and assact2.payroll_action_id = pact2.payroll_action_id
1249: and pact2.payroll_id = ye_roll.payroll_id

Line 1260: pay_payroll_actions pact3

1256: and not exists(
1257: select '1'
1258: from pay_action_interlocks pai,
1259: pay_assignment_actions assact3,
1260: pay_payroll_actions pact3
1261: where pai.locked_action_id = assact2.assignment_action_id
1262: and pai.locking_action_id = assact3.assignment_action_id
1263: and pact3.payroll_action_id = assact3.payroll_action_id
1264: and pact3.action_type = 'V'

Line 1678: pay_payroll_actions pact,

1674: and assact.assignment_id = ye_asg.assignment_id
1675: and assact.action_sequence = (
1676: select max(assact2.action_sequence)
1677: from pay_assignment_actions assact2,
1678: pay_payroll_actions pact,
1679: pay_gb_year_end_payrolls ye_roll
1680: where assact2.assignment_id = ye_asg.assignment_id
1681: and ye_roll.payroll_id = pact.payroll_id
1682: and pact.payroll_action_id = assact2.payroll_action_id