APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 150: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

146: * Bug 3134158 - Added the following function to return the scheme name
147: *
148: */
149: FUNCTION get_scheme_name(p_run_result_id in pay_run_results.run_result_id%TYPE,
150: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
151: p_business_group_id in hr_organization_units.business_group_id%TYPE)
152: RETURN VARCHAR2
153: IS
154:

Line 175: FROM pay_assignment_actions paa,

171: CURSOR csr_result_value(c_run_result_id in NUMBER,
172: c_assignment_action_id IN NUMBER)
173: IS
174: SELECT fnd_number.canonical_to_number(prrv.result_value)
175: FROM pay_assignment_actions paa,
176: pay_run_results prr,
177: pay_run_result_values prrv,
178: pay_input_values_f pivf
179: WHERE prr.run_result_id = c_run_result_id

Line 445: FROM pay_assignment_actions

441:
442: CURSOR csr_tax_unit_id(p_assignment_action_id NUMBER)
443: IS
444: SELECT tax_unit_id
445: FROM pay_assignment_actions
446: WHERE assignment_action_id = p_assignment_action_id;
447:
448: BEGIN
449:

Line 843: pay_assignment_actions paa,

839: FROM pay_accrual_plans pap,
840: pay_element_types_f pet,
841: pay_element_links_f pel,
842: pay_element_entries_f pee,
843: pay_assignment_actions paa,
844: pay_payroll_actions ppa
845: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
846: AND pel.element_type_id = pet.element_type_id
847: AND pee.element_link_id = pel.element_link_id

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

973: -- archive_stat_elements
974: -- pay_apac_payslip_archive.archive_user_balances
975: --------------------------------------------------------------------+
976:
977: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
978: p_effective_date IN DATE) IS
979:
980:
981: -- Cursor to select all the locked prepayment and payrolls by the archive

Line 1000: from pay_assignment_actions paa_arch_chd,

996: ptp.start_date period_start_date,
997: ptp.end_date period_end_date,
998: ptp.regular_payment_date,
999: ptp.time_period_id
1000: from pay_assignment_actions paa_arch_chd,
1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,

Line 1001: pay_assignment_actions paa_arch_mst,

997: ptp.end_date period_end_date,
998: ptp.regular_payment_date,
999: ptp.time_period_id
1000: from pay_assignment_actions paa_arch_chd,
1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,

Line 1002: pay_assignment_actions paa_pre,

998: ptp.regular_payment_date,
999: ptp.time_period_id
1000: from pay_assignment_actions paa_arch_chd,
1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,
1006: pay_payroll_actions ppa_pre,

Line 1004: pay_assignment_actions paa_run,

1000: from pay_assignment_actions paa_arch_chd,
1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,
1006: pay_payroll_actions ppa_pre,
1007: pay_payroll_actions ppa_run,
1008: per_time_periods ptp

Line 1026: from pay_assignment_actions paa_run2,

1022: and ppa_run.date_earned between ptp.start_date
1023: and ptp.end_date
1024: -- Get the highest in sequence for this payslip
1025: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1026: from pay_assignment_actions paa_run2,
1027: pay_action_interlocks pai_run2
1028: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
1029: and pai_run2.locked_action_id = paa_run2.assignment_action_id
1030: );

Line 1039: pay_assignment_actions paa,

1035: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
1036: IS
1037: SELECT pps.actual_termination_date
1038: FROM pay_payroll_actions ppa,
1039: pay_assignment_actions paa,
1040: per_time_periods ptp,
1041: per_all_assignments_f paf,
1042: per_periods_of_service pps
1043: WHERE paa.assignment_action_id = p_assignment_action_id