APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 505: FROM pay_assignment_actions

501:
502: CURSOR csr_tax_unit_id(p_assignment_action_id NUMBER)
503: IS
504: SELECT tax_unit_id
505: FROM pay_assignment_actions
506: WHERE assignment_action_id = p_assignment_action_id;
507:
508:
509: -- Cursor to get the bank name,percentage and currency code using the view

Line 654: pay_assignment_actions paa,

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

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

775: -- Major changes were made to the procedure as part of
776: -- fix for bug 3580587
777: --------------------------------------------------------------------+
778:
779: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
780: p_effective_date IN DATE) IS
781:
782:
783: -- Cursor to select all the locked prepayment and payrolls by the archive

Line 800: from pay_assignment_actions paa_arch_chd,

796: ptp.start_date period_start_date,
797: ptp.end_date period_end_date,
798: ptp.regular_payment_date,
799: ptp.time_period_id
800: from pay_assignment_actions paa_arch_chd,
801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,

Line 801: pay_assignment_actions paa_arch_mst,

797: ptp.end_date period_end_date,
798: ptp.regular_payment_date,
799: ptp.time_period_id
800: from pay_assignment_actions paa_arch_chd,
801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,

Line 802: pay_assignment_actions paa_pre,

798: ptp.regular_payment_date,
799: ptp.time_period_id
800: from pay_assignment_actions paa_arch_chd,
801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,

Line 804: pay_assignment_actions paa_run,

800: from pay_assignment_actions paa_arch_chd,
801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,
808: per_time_periods ptp

Line 826: from pay_assignment_actions paa_run2,

822: and ppa_run.date_earned between ptp.start_date
823: and ptp.end_date
824: -- Get the highest in sequence for this payslip
825: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
826: from pay_assignment_actions paa_run2,
827: pay_action_interlocks pai_run2
828: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
829: and pai_run2.locked_action_id = paa_run2.assignment_action_id
830: );

Line 839: pay_assignment_actions paa,

835: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
836: IS
837: SELECT pps.actual_termination_date
838: FROM pay_payroll_actions ppa,
839: pay_assignment_actions paa,
840: per_time_periods ptp,
841: per_all_assignments_f paf,
842: per_periods_of_service pps
843: WHERE paa.assignment_action_id = p_assignment_action_id