APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 355: ,pay_assignment_actions paa

351: FROM pay_accrual_plans pap
352: ,pay_element_types_f pet
353: ,pay_element_links_f pel
354: ,pay_element_entries_f pee
355: ,pay_assignment_actions paa
356: ,pay_payroll_actions ppa
357: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
358: AND pel.element_type_id = pet.element_type_id
359: AND pee.element_link_id = pel.element_link_id

Line 550: FROM pay_assignment_actions paa

546: ,pet.reporting_name reporting_name
547: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
548: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
549: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
550: FROM pay_assignment_actions paa
551: ,pay_payroll_actions ppa
552: ,pay_run_results prr
553: ,pay_run_result_values prrv
554: ,per_time_periods ptp

Line 720: , pay_assignment_actions paa

716: ,ppa.effective_date
717: ,ppa.business_group_id
718: ) exchange_rate
719: FROM pay_payroll_actions ppa
720: , pay_assignment_actions paa
721: , pay_run_results prr
722: , pay_run_result_values prrv
723: , pay_input_values_f piv
724: , pay_element_types_f pet

Line 1799: FROM pay_assignment_actions

1795:
1796: CURSOR csr_tax_unit_id
1797: IS
1798: SELECT tax_unit_id
1799: FROM pay_assignment_actions
1800: WHERE assignment_action_id = p_curr_pymt_ass_act_id;
1801: --
1802:
1803:

Line 1843: ,pay_assignment_actions paa

1839: SELECT hsck.segment20 -- Tax Area
1840: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1841: FROM hr_soft_coding_keyflex hsck
1842: ,per_all_assignments_f paaf
1843: ,pay_assignment_actions paa
1844: ,pay_payroll_actions ppa
1845: WHERE paa.assignment_action_id = p_assactid
1846: AND paa.payroll_action_id = ppa.payroll_action_id
1847: AND paa.assignment_id = paaf.assignment_id

Line 2161: FROM pay_assignment_actions paa_arch_chd

2157: ,ptp.end_date period_end_date
2158: ,ptp.time_period_id
2159: ,ptp.start_date period_start_date
2160: ,ptp.regular_payment_date
2161: FROM pay_assignment_actions paa_arch_chd
2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run

Line 2162: ,pay_assignment_actions paa_arch_mst

2158: ,ptp.time_period_id
2159: ,ptp.start_date period_start_date
2160: ,ptp.regular_payment_date
2161: FROM pay_assignment_actions paa_arch_chd
2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run

Line 2163: ,pay_assignment_actions paa_pre

2159: ,ptp.start_date period_start_date
2160: ,ptp.regular_payment_date
2161: FROM pay_assignment_actions paa_arch_chd
2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre

Line 2165: ,pay_assignment_actions paa_run

2161: FROM pay_assignment_actions paa_arch_chd
2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre
2168: ,pay_payroll_actions ppa_run
2169: ,per_time_periods ptp

Line 2193: FROM pay_assignment_actions paa_run2

2189: -- Get the highest in sequence for this payslip
2190: AND paa_run.action_sequence =
2191: (
2192: SELECT MAX(paa_run2.action_sequence)
2193: FROM pay_assignment_actions paa_run2
2194: ,pay_action_interlocks pai_run2
2195: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
2196: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
2197: );

Line 2206: pay_assignment_actions paa,

2202: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
2203: IS
2204: SELECT pps.actual_termination_date
2205: FROM pay_payroll_actions ppa,
2206: pay_assignment_actions paa,
2207: per_time_periods ptp,
2208: per_all_assignments_f paf,
2209: per_periods_of_service pps
2210: WHERE paa.assignment_action_id = p_assignment_action_id