DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PAY_ACCRUAL_PLANS

Line 995: ,pay_accrual_plans PAP

991: ,cp_effective_date DATE) IS
992: SELECT distinct PIV.name -- PIV.display_sequence
993: FROM --pay_element_types_f PET
994: pay_input_values_f PIV
995: ,pay_accrual_plans PAP
996: ,pay_net_calculation_rules PNCR
997: WHERE--PET.element_type_id = cp_element_type_id
998: --AND PET.element_type_id = PIV.element_type_id
999: PIV.element_type_id = cp_element_type_id

Line 1008: FROM pay_accrual_plans PAPL

1004: AND PNCR.input_value_id <> PAP.co_input_value_id
1005: AND PNCR.accrual_plan_id = PAP.accrual_plan_id
1006: AND PAP.accrual_plan_id IN
1007: (SELECT PAPL.accrual_plan_id
1008: FROM pay_accrual_plans PAPL
1009: ,pay_element_links_f PEL
1010: ,pay_element_entries_f PEE
1011: WHERE PEL.element_type_id = PAPL.accrual_plan_element_type_id
1012: AND cp_effective_date between PEL.effective_start_date