APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 706: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

702: --
703:
704:
705: l_template_id pay_shadow_element_types.template_id%TYPE;
706: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
707: l_source_template_id pay_element_templates.template_id%TYPE;
708: l_object_version_number pay_element_types_f.object_version_number%TYPE;
709:
710: l_proc_step NUMBER(20,10);

Line 813: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=

809:
810: TYPE t_number IS TABLE OF NUMBER
811: INDEX BY BINARY_INTEGER;
812:
813: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=
814: -1;
815:
816: -- Extra Information variables
817: l_eei_information9 pay_element_type_extra_info.eei_information9%

Line 955: pay_template_core_objects ptco

951: --
952: CURSOR c3 (c_object_name in varchar2) is
953: SELECT ptco.core_object_id
954: FROM pay_shadow_balance_types psbt,
955: pay_template_core_objects ptco
956: WHERE psbt.template_id = l_template_id
957: AND psbt.balance_name = c_object_name
958: AND ptco.template_id = psbt.template_id
959: AND ptco.shadow_object_id = psbt.balance_type_id;

Line 3271: FROM pay_template_core_objects pet

3267:
3268: CURSOR csr_get_ele_type_id (c_template_id number)
3269: IS
3270: SELECT element_type_id
3271: FROM pay_template_core_objects pet
3272: ,pay_element_types_f petf
3273: WHERE pet.template_id = c_template_id
3274: AND petf.element_type_id = pet.core_object_id
3275: AND pet.core_object_type = 'ET';

Line 3322: ,pay_template_core_objects ptco

3318: ) IS
3319: SELECT 'X'
3320: FROM pay_element_templates pets
3321: ,pay_shadow_element_types pset
3322: ,pay_template_core_objects ptco
3323: ,pay_element_type_extra_info peei
3324: WHERE pets.template_id <> c_te_usrstr_id
3325: -- For the given user structure
3326: AND pets.template_name = p_template_name -- 'PQP OSP'