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 444: FROM pay_assignment_actions

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

Line 842: pay_assignment_actions paa,

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

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

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

Line 999: from pay_assignment_actions paa_arch_chd,

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

Line 1000: pay_assignment_actions paa_arch_mst,

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

Line 1001: pay_assignment_actions paa_pre,

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

Line 1003: pay_assignment_actions paa_run,

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

Line 1025: from pay_assignment_actions paa_run2,

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

Line 1038: pay_assignment_actions paa,

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