APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 43: l_template_id pay_shadow_element_types.template_id%TYPE;

39: p_ele_eff_end_date (D) - Trunc(end date)
40: p_bg_id (N) - Business group id
41: ----------------------------------------------------------------------*/
42: --
43: l_template_id pay_shadow_element_types.template_id%TYPE;
44: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
45: l_source_template_id pay_element_templates.template_id%TYPE;
46: l_object_version_number NUMBER(9);
47: l_proc VARCHAR2(80) :=

Line 84: FROM pay_shadow_element_types

80:
81: CURSOR csr_get_ele_info (c_ele_name varchar2) is
82: SELECT element_type_id
83: ,object_version_number
84: FROM pay_shadow_element_types
85: WHERE template_id = l_template_id
86: AND element_name = c_ele_name;
87:
88: --

Line 93: FROM pay_shadow_element_types psbt,

89: -- cursor to fetch the core element id
90: --
91: CURSOR c5 (c_element_name in varchar2) is
92: SELECT ptco.core_object_id
93: FROM pay_shadow_element_types psbt,
94: pay_template_core_objects ptco
95: WHERE psbt.template_id = l_template_id
96: AND psbt.element_name = c_element_name
97: AND ptco.template_id = psbt.template_id

Line 667: ,pay_shadow_element_types pset

663:
664: CURSOR csr_get_orginfo (c_te_usrstr_id NUMBER) IS
665: SELECT TO_NUMBER(peei.eei_information1) pbd_org_id
666: FROM pay_element_templates pets
667: ,pay_shadow_element_types pset
668: ,pay_template_core_objects ptco
669: ,pay_element_type_extra_info peei
670: WHERE pets.template_id = c_te_usrstr_id -- For the given user structure
671: AND pset.template_id = pets.template_id -- find the base element