APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 280: ,pay_assignment_actions paa

276: FROM pay_accrual_plans pap
277: ,pay_element_types_f pet
278: ,pay_element_links_f pel
279: ,pay_element_entries_f pee
280: ,pay_assignment_actions paa
281: ,pay_payroll_actions ppa
282: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
283: AND pel.element_type_id = pet.element_type_id
284: AND pee.element_link_id = pel.element_link_id

Line 458: FROM pay_assignment_actions paa

454: ,pet.reporting_name reporting_name
455: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
456: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
457: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,pay_run_results prr
461: ,pay_run_result_values prrv
462: ,per_time_periods ptp

Line 622: , pay_assignment_actions paa

618: ,ppa.effective_date
619: ,ppa.business_group_id
620: ) exchange_rate
621: FROM pay_payroll_actions ppa
622: , pay_assignment_actions paa
623: , pay_run_results prr
624: , pay_run_result_values prrv
625: , pay_input_values_f piv
626: , pay_element_types_f pet

Line 1671: FROM pay_assignment_actions

1667:
1668: CURSOR csr_tax_unit_id
1669: IS
1670: SELECT tax_unit_id
1671: FROM pay_assignment_actions
1672: WHERE assignment_action_id = p_curr_pymt_ass_act_id;
1673: --
1674:
1675:

Line 1715: ,pay_assignment_actions paa

1711: SELECT hsck.segment20 -- Tax Area
1712: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1713: FROM hr_soft_coding_keyflex hsck
1714: ,per_all_assignments_f paaf
1715: ,pay_assignment_actions paa
1716: ,pay_payroll_actions ppa
1717: WHERE paa.assignment_action_id = p_assactid
1718: AND paa.payroll_action_id = ppa.payroll_action_id
1719: AND paa.assignment_id = paaf.assignment_id

Line 2033: FROM pay_assignment_actions paa_arch_chd

2029: ,ptp.end_date period_end_date
2030: ,ptp.time_period_id
2031: ,ptp.start_date period_start_date
2032: ,ptp.regular_payment_date
2033: FROM pay_assignment_actions paa_arch_chd
2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run

Line 2034: ,pay_assignment_actions paa_arch_mst

2030: ,ptp.time_period_id
2031: ,ptp.start_date period_start_date
2032: ,ptp.regular_payment_date
2033: FROM pay_assignment_actions paa_arch_chd
2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run

Line 2035: ,pay_assignment_actions paa_pre

2031: ,ptp.start_date period_start_date
2032: ,ptp.regular_payment_date
2033: FROM pay_assignment_actions paa_arch_chd
2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run
2039: ,pay_payroll_actions ppa_pre

Line 2037: ,pay_assignment_actions paa_run

2033: FROM pay_assignment_actions paa_arch_chd
2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run
2039: ,pay_payroll_actions ppa_pre
2040: ,pay_payroll_actions ppa_run
2041: ,per_time_periods ptp

Line 2065: FROM pay_assignment_actions paa_run2

2061: -- Get the highest in sequence for this payslip
2062: AND paa_run.action_sequence =
2063: (
2064: SELECT MAX(paa_run2.action_sequence)
2065: FROM pay_assignment_actions paa_run2
2066: ,pay_action_interlocks pai_run2
2067: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
2068: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
2069: );

Line 2078: pay_assignment_actions paa,

2074: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
2075: IS
2076: SELECT pps.actual_termination_date
2077: FROM pay_payroll_actions ppa,
2078: pay_assignment_actions paa,
2079: per_time_periods ptp,
2080: per_all_assignments_f paf,
2081: per_periods_of_service pps
2082: WHERE paa.assignment_action_id = p_assignment_action_id