APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 216: pay_template_core_objects ptco

212: --
213: CURSOR c3 (c_object_name in varchar2) is
214: SELECT ptco.core_object_id
215: FROM pay_shadow_balance_types psbt,
216: pay_template_core_objects ptco
217: WHERE psbt.template_id = p_template_id
218: AND psbt.balance_name = c_object_name
219: AND ptco.template_id = psbt.template_id
220: AND ptco.shadow_object_id = psbt.balance_type_id;

Line 863: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

859: --
860:
861:
862: l_template_id pay_shadow_element_types.template_id%TYPE;
863: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
864: l_source_template_id pay_element_templates.template_id%TYPE;
865: l_object_version_number pay_element_types_f.object_version_number%TYPE;
866:
867: l_proc_step NUMBER(20,10);

Line 920: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=

916: l_udt_cols t_udt_cols;
917:
918: l_udt_rows t_udt_rows;
919:
920: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=
921: -1;
922:
923: -- Extra Information variables
924: l_eei_information9 pay_element_type_extra_info.eei_information9%

Line 1986: FROM pay_template_core_objects pet

1982:
1983: CURSOR csr_get_ele_type_id (c_template_id number)
1984: IS
1985: SELECT element_type_id
1986: FROM pay_template_core_objects pet
1987: ,pay_element_types_f petf
1988: WHERE pet.template_id = c_template_id
1989: AND petf.element_type_id = pet.core_object_id
1990: AND pet.core_object_type = 'ET';

Line 2035: ,pay_template_core_objects ptco

2031: ) IS
2032: SELECT 'X'
2033: FROM pay_element_templates pets
2034: ,pay_shadow_element_types pset
2035: ,pay_template_core_objects ptco
2036: ,pay_element_type_extra_info peei
2037: WHERE pets.template_id <> c_te_usrstr_id
2038: -- For the given user structure
2039: AND pets.template_name = p_template_name -- 'PQP OSP'