APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 245: ,pay_assignment_actions act

241: )
242: IS
243: SELECT '1'
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: ,per_all_assignments_f as1
247: ,pay_payroll_actions ppa
248: WHERE ppa.payroll_action_id = p_payroll_action_id
249: AND appa.effective_date BETWEEN csr_v_canonical_start_date

Line 841: ,pay_assignment_actions act

837: ,act.assignment_id assignment_id
838: ,act.assignment_action_id run_action_id
839: ,act.tax_unit_id legal_employer_id
840: FROM pay_payroll_actions appa
841: ,pay_assignment_actions act
842: ,per_all_assignments_f as1
843: ,pay_payroll_actions ppa
844: WHERE ppa.payroll_action_id = p_payroll_action_id
845: AND appa.effective_date BETWEEN l_canonical_start_date

Line 1182: SELECT pay_assignment_actions_s.NEXTVAL

1178: );
1179:
1180: IF l_a_tax_card_or_not > 0
1181: THEN
1182: SELECT pay_assignment_actions_s.NEXTVAL
1183: INTO l_actid
1184: FROM DUAL;
1185:
1186: -- Create the archive assignment action

Line 1236: SELECT pay_assignment_actions_s.NEXTVAL

1232: );
1233:
1234: IF l_a_tax_card_or_not > 0
1235: THEN
1236: SELECT pay_assignment_actions_s.NEXTVAL
1237: INTO l_actid
1238: FROM DUAL;
1239:
1240: -- Create the archive assignment action

Line 1294: SELECT pay_assignment_actions_s.NEXTVAL

1290: );
1291:
1292: IF l_a_tax_card_or_not > 0
1293: THEN
1294: SELECT pay_assignment_actions_s.NEXTVAL
1295: INTO l_actid
1296: FROM DUAL;
1297:
1298: -- Create the archive assignment action

Line 1349: SELECT pay_assignment_actions_s.NEXTVAL

1345: );
1346:
1347: IF l_a_tax_card_or_not > 0
1348: THEN
1349: SELECT pay_assignment_actions_s.NEXTVAL
1350: INTO l_actid
1351: FROM DUAL;
1352:
1353: -- Create the archive assignment action

Line 1927: ,pay_assignment_actions pac

1923: FROM (SELECT paa.effective_start_date,paa.effective_end_date
1924: ,paa.person_id
1925: ,paa.assignment_id
1926: FROM per_all_assignments_f paa
1927: ,pay_assignment_actions pac
1928: WHERE pac.assignment_action_id = p_asg_act_id
1929: AND paa.assignment_id = pac.assignment_id
1930: AND paa.effective_start_date <= g_income_end_date
1931: AND paa.effective_end_date > = g_income_start_date

Line 2071: ,pay_assignment_actions pasa

2067: SELECT scl.segment2
2068: ,scl.segment8
2069: FROM per_all_assignments_f paa
2070: ,hr_soft_coding_keyflex scl
2071: ,pay_assignment_actions pasa
2072: WHERE pasa.assignment_action_id = p_assignment_action_id
2073: AND pasa.assignment_id = paa.assignment_id
2074: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2075: AND csr_v_effective_date BETWEEN paa.effective_start_date