APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 511: FROM pay_assignment_actions

507:
508: CURSOR csr_tax_unit_id(p_assignment_action_id NUMBER)
509: IS
510: SELECT tax_unit_id
511: FROM pay_assignment_actions
512: WHERE assignment_action_id = p_assignment_action_id;
513:
514:
515: -- Cursor to get the bank name,percentage and currency code using the view

Line 660: pay_assignment_actions paa,

656: FROM pay_accrual_plans pap,
657: pay_element_types_f pet,
658: pay_element_links_f pel,
659: pay_element_entries_f pee,
660: pay_assignment_actions paa,
661: pay_payroll_actions ppa
662: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
663: AND pel.element_type_id = pet.element_type_id
664: AND pee.element_link_id = pel.element_link_id

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

781: -- Major changes were made to the procedure as part of
782: -- fix for bug 3580587
783: --------------------------------------------------------------------+
784:
785: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
786: p_effective_date IN DATE) IS
787:
788:
789: -- Cursor to select all the locked prepayment and payrolls by the archive

Line 806: from pay_assignment_actions paa_arch_chd,

802: ptp.start_date period_start_date,
803: ptp.end_date period_end_date,
804: ptp.regular_payment_date,
805: ptp.time_period_id
806: from pay_assignment_actions paa_arch_chd,
807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,

Line 807: pay_assignment_actions paa_arch_mst,

803: ptp.end_date period_end_date,
804: ptp.regular_payment_date,
805: ptp.time_period_id
806: from pay_assignment_actions paa_arch_chd,
807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,

Line 808: pay_assignment_actions paa_pre,

804: ptp.regular_payment_date,
805: ptp.time_period_id
806: from pay_assignment_actions paa_arch_chd,
807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,

Line 810: pay_assignment_actions paa_run,

806: from pay_assignment_actions paa_arch_chd,
807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,
814: per_time_periods ptp

Line 832: from pay_assignment_actions paa_run2,

828: and ppa_run.date_earned between ptp.start_date
829: and ptp.end_date
830: -- Get the highest in sequence for this payslip
831: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
832: from pay_assignment_actions paa_run2,
833: pay_action_interlocks pai_run2
834: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
835: and pai_run2.locked_action_id = paa_run2.assignment_action_id
836: );

Line 845: pay_assignment_actions paa,

841: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
842: IS
843: SELECT pps.actual_termination_date
844: FROM pay_payroll_actions ppa,
845: pay_assignment_actions paa,
846: per_time_periods ptp,
847: per_all_assignments_f paf,
848: per_periods_of_service pps
849: WHERE paa.assignment_action_id = p_assignment_action_id