APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 281: ,pay_payroll_actions ppa

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
285: AND paa.assignment_id = pee.assignment_id

Line 459: ,pay_payroll_actions ppa

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
463: ,pay_element_types_f pet

Line 621: FROM pay_payroll_actions ppa

617: ,pet.output_currency_code
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

Line 1716: ,pay_payroll_actions ppa

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
1720: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 2039: ,pay_payroll_actions ppa_pre

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
2042: ,per_business_groups pbg
2043: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id

Line 2040: ,pay_payroll_actions ppa_run

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
2042: ,per_business_groups pbg
2043: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
2044: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 2077: FROM pay_payroll_actions ppa,

2073:
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