APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 44: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

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) :=
48: 'pqp_gb_professional_body_temp.create_user_template';

Line 58: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;

54: l_ele_name pay_element_types_f.element_name%TYPE;
55: l_name pay_input_values_f.name%TYPE;
56: i NUMBER;
57:
58: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
59: l_organization_id NUMBER;
60:
61: -- Generic Never to be passed IN
62: l_xx_rowid_id ROWID;

Line 67: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;

63:
64: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
65: l_bf_pbdbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
66: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;
67: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
69:
70: -- Extra Information variables
71: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;

Line 94: pay_template_core_objects ptco

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
98: AND ptco.shadow_object_id = psbt.element_type_id

Line 242: pay_template_core_objects ptco

238: --
239: CURSOR csr_core_bal_id (c_object_name in varchar2) is
240: SELECT ptco.core_object_id
241: FROM pay_shadow_balance_types psbt,
242: pay_template_core_objects ptco
243: WHERE psbt.template_id = l_template_id
244: AND psbt.balance_name = c_object_name
245: AND ptco.template_id = psbt.template_id
246: AND ptco.shadow_object_id = psbt.balance_type_id;

Line 251: FROM pay_template_core_objects ptco

247:
248: --
249: CURSOR csr_core_obj_id is
250: SELECT ptco.core_object_id
251: FROM pay_template_core_objects ptco
252: WHERE ptco.template_id = l_template_id
253: AND ptco.shadow_object_id = p_shadow_id
254: AND ptco.core_object_type = p_object_type;
255: --

Line 668: ,pay_template_core_objects ptco

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
672: AND pset.element_name = pets.base_name