APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 236: l_element_type_id pay_element_types_f.element_type_id%TYPE;

232:
233: -- Table to pass as param to the create_osp_template proc.
234: l_lookup_table pqp_gb_osp_template.t_abs_types;
235:
236: l_element_type_id pay_element_types_f.element_type_id%TYPE;
237: l_sec_grp_id per_business_groups.security_group_id%TYPE;
238: i number;
239: l_proc_name VARCHAR2 (80)
240: := g_proc_name

Line 442: l_element_type_id pay_element_types_f.element_type_id%TYPE;

438: --
439: TYPE ref_csr_type IS REF CURSOR;
440: c_cursor ref_csr_type;
441:
442: l_element_type_id pay_element_types_f.element_type_id%TYPE;
443: l_abs_type_lookup_type varchar2(100);
444: l_sch_cal_start_date VARCHAR2(11);
445: l_sch_cal_end_date VARCHAR2(11);
446: l_select VARCHAR2(100);

Line 709: l_element_type_id pay_element_types_f.element_type_id%TYPE;

705: --
706: TYPE ref_csr_type IS REF CURSOR;
707: c_cursor ref_csr_type;
708:
709: l_element_type_id pay_element_types_f.element_type_id%TYPE;
710: l_abs_type_lookup_type varchar2(100);
711: l_select VARCHAR2(100);
712: l_sec_grp_id per_business_groups.security_group_id%TYPE;
713: l_proc_name VARCHAR2(61) := g_proc_name ||