DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 2890: pay_element_type_extra_info petei

2886: SELECT petei.eei_information12
2887: FROM pay_element_entries_f peef,
2888: pay_element_types_f petf,
2889: pay_element_types_f petf_calc,
2890: pay_element_type_extra_info petei
2891: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
2892: AND petf.element_type_id = peef.element_type_id
2893: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
2894: AND petf_calc.element_type_id = petf.element_information5

Line 3309: pay_element_type_extra_info petei

3305: SELECT count(petei.eei_information13)
3306: FROM pay_element_entries_f peef,
3307: pay_element_types_f petf,
3308: pay_element_types_f petf_calc,
3309: pay_element_type_extra_info petei
3310: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3311: AND petf.element_type_id = peef.element_type_id
3312: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
3313: AND petf_calc.element_type_id = petf.element_information5

Line 3327: pay_element_type_extra_info petei

3323: ,petei.eei_information14
3324: FROM pay_element_entries_f peef,
3325: pay_element_types_f petf,
3326: pay_element_types_f petf_calc,
3327: pay_element_type_extra_info petei
3328: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3329: AND petf.element_type_id = peef.element_type_id
3330: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
3331: AND petf_calc.element_type_id = petf.element_information5