DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PAY_ACCRUAL_PLANS

Line 1493: ,pay_accrual_plans PAP

1489: ,cp_effective_date DATE) IS
1490: SELECT distinct PIV.name -- PIV.display_sequence
1491: FROM --pay_element_types_f PET
1492: pay_input_values_f PIV
1493: ,pay_accrual_plans PAP
1494: ,pay_net_calculation_rules PNCR
1495: WHERE--PET.element_type_id = cp_element_type_id
1496: --AND PET.element_type_id = PIV.element_type_id
1497: PIV.element_type_id = cp_element_type_id

Line 1506: FROM pay_accrual_plans PAPL

1502: AND PNCR.input_value_id <> PAP.co_input_value_id
1503: AND PNCR.accrual_plan_id = PAP.accrual_plan_id
1504: AND PAP.accrual_plan_id IN
1505: (SELECT PAPL.accrual_plan_id
1506: FROM pay_accrual_plans PAPL
1507: ,pay_element_links_f PEL
1508: ,pay_element_entries_f PEE
1509: WHERE PEL.element_type_id = PAPL.accrual_plan_element_type_id
1510: AND cp_effective_date between PEL.effective_start_date