APPS.PAY_NZ_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 459: FROM pay_assignment_actions

455:
456: CURSOR csr_tax_unit_id(p_assignment_action_id NUMBER)
457: IS
458: SELECT tax_unit_id
459: FROM pay_assignment_actions
460: WHERE assignment_action_id = p_assignment_action_id;
461:
462:
463:

Line 655: pay_assignment_actions paa,

651: FROM pay_accrual_plans pap,
652: pay_element_types_f pet,
653: pay_element_links_f pel,
654: pay_element_entries_f pee,
655: pay_assignment_actions paa,
656: pay_payroll_actions ppa
657: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
658: AND pel.element_type_id = pet.element_type_id
659: AND pee.element_link_id = pel.element_link_id

Line 865: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

861: -- archive_stat_elements
862: -- pay_apac_payslip_archive.archive_user_balances
863: --------------------------------------------------------------------+
864:
865: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
866: p_effective_date IN DATE) IS
867:
868:
869: -- Cursor to select all the locked prepayment and payrolls by the archive

Line 892: FROM pay_assignment_actions paa_arch_chd

888: ,ptp.end_date period_end_date
889: ,ptp.time_period_id
890: ,ptp.start_date
891: ,ptp.regular_payment_date
892: FROM pay_assignment_actions paa_arch_chd
893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run

Line 893: ,pay_assignment_actions paa_arch_mst

889: ,ptp.time_period_id
890: ,ptp.start_date
891: ,ptp.regular_payment_date
892: FROM pay_assignment_actions paa_arch_chd
893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run

Line 894: ,pay_assignment_actions paa_pre

890: ,ptp.start_date
891: ,ptp.regular_payment_date
892: FROM pay_assignment_actions paa_arch_chd
893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre

Line 896: ,pay_assignment_actions paa_run

892: FROM pay_assignment_actions paa_arch_chd
893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run
900: ,per_time_periods ptp

Line 924: FROM pay_assignment_actions paa_run2

920: -- Get the highest in sequence for this payslip
921: AND paa_run.action_sequence =
922: (
923: SELECT MAX(paa_run2.action_sequence)
924: FROM pay_assignment_actions paa_run2
925: ,pay_action_interlocks pai_run2
926: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
927: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
928: );

Line 937: pay_assignment_actions paa,

933: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
934: IS
935: SELECT pps.actual_termination_date
936: FROM pay_payroll_actions ppa,
937: pay_assignment_actions paa,
938: per_time_periods ptp,
939: per_all_assignments_f paf,
940: per_periods_of_service pps
941: WHERE paa.assignment_action_id = p_assignment_action_id