DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 3540: pay_element_type_extra_info petei

3536: SELECT petei.eei_information12
3537: FROM pay_element_entries_f peef,
3538: pay_element_types_f petf,
3539: pay_element_types_f petf_calc,
3540: pay_element_type_extra_info petei
3541: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3542: AND petf.element_type_id = peef.element_type_id
3543: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
3544: AND petf_calc.element_type_id = petf.element_information5

Line 3975: pay_element_type_extra_info petei

3971: SELECT count(petei.eei_information13)
3972: FROM pay_element_entries_f peef,
3973: pay_element_types_f petf,
3974: pay_element_types_f petf_calc,
3975: pay_element_type_extra_info petei
3976: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3977: AND petf.element_type_id = peef.element_type_id
3978: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
3979: AND petf_calc.element_type_id = petf.element_information5

Line 3993: pay_element_type_extra_info petei

3989: ,petei.eei_information14
3990: FROM pay_element_entries_f peef,
3991: pay_element_types_f petf,
3992: pay_element_types_f petf_calc,
3993: pay_element_type_extra_info petei
3994: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3995: AND petf.element_type_id = peef.element_type_id
3996: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID
3997: AND petf_calc.element_type_id = petf.element_information5