DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PAY_ACCRUAL_PLANS

Line 240: pay_accrual_plans pap,

236: IS
237: SELECT DISTINCT piv.NAME -- PIV.display_sequence
238: FROM --pay_element_types_f PET
239: pay_input_values_f piv,
240: pay_accrual_plans pap,
241: pay_net_calculation_rules pncr
242: WHERE --PET.element_type_id = cp_element_type_id
243:
244: -- AND PET.element_type_id = PIV.element_type_id

Line 254: FROM pay_accrual_plans papl,

250: AND pncr.input_value_id <> pap.co_input_value_id
251: AND pncr.accrual_plan_id = pap.accrual_plan_id
252: AND pap.accrual_plan_id IN
253: (SELECT papl.accrual_plan_id
254: FROM pay_accrual_plans papl,
255: pay_element_links_f pel,
256: pay_element_entries_f pee
257: WHERE pel.element_type_id =
258: papl.accrual_plan_element_type_id