DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ELEMENT_TYPES_F

Line 272: pay_element_types_f pet,

268: from pay_accrual_plans pap,
269: pay_element_entry_values_f pev,
270: pay_element_entries_f pee,
271: pay_element_links_f pel,
272: pay_element_types_f pet,
273: pay_input_values_f piv
274: where ( pap.accrual_plan_id = p_plan_id OR
275: pap.accrual_category = P_plan_category )
276: and pap.business_group_id + 0 = P_business_group

Line 595: pay_element_types_f pet

591:
592: select min (pee.effective_start_date) into l_plan_enrl_date
593: from pay_element_entries_f pee,
594: pay_element_links_f pel,
595: pay_element_types_f pet
596: where pel.element_link_id = pee.element_link_id
597: and pel.element_type_id = pet.element_type_id
598: and pee.assignment_id = p_assignment_id
599: and pet.element_type_id = (select accrual_plan_element_type_id