DBA Data[Home] [Help]

APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 110: FROM pay_shadow_element_types

106: CURSOR csr_el_unnddn(p_te_unnddn_id NUMBER
107: ,p_el_unnddn_nm VARCHAR2) IS
108: SELECT element_type_id
109: ,object_version_number
110: FROM pay_shadow_element_types
111: WHERE template_id = p_te_unnddn_id
112: AND element_name = p_el_unnddn_nm;
113:
114: row_el_unnddn csr_el_unnddn%ROWTYPE;

Line 846: ,pay_shadow_element_types pset

842:
843: CURSOR csr_ee_unionm (p_te_usrstr_id NUMBER) IS
844: SELECT TO_NUMBER(peei.eei_information1) union_org_id
845: FROM pay_element_templates pets
846: ,pay_shadow_element_types pset
847: ,pay_template_core_objects ptco
848: ,pay_element_type_extra_info peei
849: -- ,hr_all_organization_units horg
850: WHERE pets.template_id = p_te_usrstr_id -- For the given user structure