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 835: ,pay_assignment_actions act

831: ,act.assignment_id assignment_id
832: ,act.assignment_action_id run_action_id
833: ,act.tax_unit_id legal_employer_id
834: FROM pay_payroll_actions appa
835: ,pay_assignment_actions act
836: ,per_all_assignments_f as1
837: ,pay_payroll_actions ppa
838: WHERE ppa.payroll_action_id = p_payroll_action_id
839: AND appa.effective_date BETWEEN l_canonical_start_date

Line 1176: SELECT pay_assignment_actions_s.NEXTVAL

1172: );
1173:
1174: IF l_a_tax_card_or_not > 0
1175: THEN
1176: SELECT pay_assignment_actions_s.NEXTVAL
1177: INTO l_actid
1178: FROM DUAL;
1179:
1180: -- Create the archive assignment action

Line 1230: SELECT pay_assignment_actions_s.NEXTVAL

1226: );
1227:
1228: IF l_a_tax_card_or_not > 0
1229: THEN
1230: SELECT pay_assignment_actions_s.NEXTVAL
1231: INTO l_actid
1232: FROM DUAL;
1233:
1234: -- Create the archive assignment action

Line 1288: SELECT pay_assignment_actions_s.NEXTVAL

1284: );
1285:
1286: IF l_a_tax_card_or_not > 0
1287: THEN
1288: SELECT pay_assignment_actions_s.NEXTVAL
1289: INTO l_actid
1290: FROM DUAL;
1291:
1292: -- Create the archive assignment action

Line 1343: SELECT pay_assignment_actions_s.NEXTVAL

1339: );
1340:
1341: IF l_a_tax_card_or_not > 0
1342: THEN
1343: SELECT pay_assignment_actions_s.NEXTVAL
1344: INTO l_actid
1345: FROM DUAL;
1346:
1347: -- Create the archive assignment action

Line 1913: ,pay_assignment_actions pac

1909: FROM (SELECT paa.effective_start_date,paa.effective_end_date
1910: ,paa.person_id
1911: ,paa.assignment_id
1912: FROM per_all_assignments_f paa
1913: ,pay_assignment_actions pac
1914: WHERE pac.assignment_action_id = p_asg_act_id
1915: AND paa.assignment_id = pac.assignment_id
1916: AND paa.effective_start_date <= g_income_end_date
1917: AND paa.effective_end_date > = g_income_start_date

Line 2056: ,pay_assignment_actions pasa

2052: SELECT scl.segment2
2053: ,scl.segment8
2054: FROM per_all_assignments_f paa
2055: ,hr_soft_coding_keyflex scl
2056: ,pay_assignment_actions pasa
2057: WHERE pasa.assignment_action_id = p_assignment_action_id
2058: AND pasa.assignment_id = paa.assignment_id
2059: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2060: AND csr_v_effective_date BETWEEN paa.effective_start_date