APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 238: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 444: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 707: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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