APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 376: pay_assignment_actions act,

372: act.assignment_action_id run_action_id,
373: act1.assignment_action_id prepaid_action_id
374: FROM pay_payroll_actions appa,
375: pay_payroll_actions appa2,
376: pay_assignment_actions act,
377: pay_assignment_actions act1,
378: pay_action_interlocks pai,
379: per_all_assignments_f paaf
380: WHERE appa.payroll_action_id=p_run_payroll_action_id

Line 377: pay_assignment_actions act1,

373: act1.assignment_action_id prepaid_action_id
374: FROM pay_payroll_actions appa,
375: pay_payroll_actions appa2,
376: pay_assignment_actions act,
377: pay_assignment_actions act1,
378: pay_action_interlocks pai,
379: per_all_assignments_f paaf
380: WHERE appa.payroll_action_id=p_run_payroll_action_id
381: AND appa.action_type IN ('R', 'Q')

Line 498: SELECT pay_assignment_actions_s.NEXTVAL

494:
495: -- IF l_prepay_action_id <>
496: -- rec_prepaid_assignments.prepaid_action_id
497: THEN
498: SELECT pay_assignment_actions_s.NEXTVAL
499: INTO l_actid
500: FROM DUAL;
501:
502: --

Line 649: pay_assignment_actions pasa

645: -- pap.national_identifier national_identifier,
646: paa.assignment_id assignment_id
647: FROM per_all_people_f pap,
648: per_all_assignments_f paa,
649: pay_assignment_actions pasa
650: WHERE paa.person_id = pap.person_id
651: AND pasa.assignment_id = paa.assignment_id
652: AND pap.business_group_id = csr_v_business_group_id
653: -- AND g_pay_period_end_date BETWEEN pap.effective_start_date

Line 849: csr_v_ass_action_id pay_assignment_actions.assignment_action_id%TYPE

845: AND pbd.balance_dimension_id = pdb.balance_dimension_id
846: and pdb.legislation_code = 'FI';
847:
848: CURSOR csr_get_run_ass_action_id (
849: csr_v_ass_action_id pay_assignment_actions.assignment_action_id%TYPE
850: )
851: IS
852: SELECT paa_run.assignment_action_id
853: FROM pay_assignment_actions paa_archive, pay_assignment_actions paa_run

Line 853: FROM pay_assignment_actions paa_archive, pay_assignment_actions paa_run

849: csr_v_ass_action_id pay_assignment_actions.assignment_action_id%TYPE
850: )
851: IS
852: SELECT paa_run.assignment_action_id
853: FROM pay_assignment_actions paa_archive, pay_assignment_actions paa_run
854: WHERE paa_run.assignment_id = paa_archive.assignment_id
855: AND paa_run.payroll_action_id = g_run_payroll_action_id
856: AND paa_archive.assignment_action_id = p_assignment_action_id;
857: /* SELECT ue.creator_id