APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PER_BUSINESS_GROUPS

Line 166: (P_BUSINESS_GROUP_ID IN per_business_groups.business_group_id%TYPE

162: --
163: -- Function to get the Security Group Id
164: --
165: Function get_security_grp_id
166: (P_BUSINESS_GROUP_ID IN per_business_groups.business_group_id%TYPE
167: )
168: RETURN per_business_groups.security_group_id%TYPE
169: IS
170:

Line 168: RETURN per_business_groups.security_group_id%TYPE

164: --
165: Function get_security_grp_id
166: (P_BUSINESS_GROUP_ID IN per_business_groups.business_group_id%TYPE
167: )
168: RETURN per_business_groups.security_group_id%TYPE
169: IS
170:
171: --
172: -- Cursor to get the Security Group Id

Line 178: from per_business_groups

174: CURSOR c_get_security_grp_id
175: IS
176: select
177: security_group_id
178: from per_business_groups
179: where business_group_id = P_BUSINESS_GROUP_ID;
180:
181: l_security_grp_id per_business_groups.security_group_id%TYPE;
182: BEGIN

Line 181: l_security_grp_id per_business_groups.security_group_id%TYPE;

177: security_group_id
178: from per_business_groups
179: where business_group_id = P_BUSINESS_GROUP_ID;
180:
181: l_security_grp_id per_business_groups.security_group_id%TYPE;
182: BEGIN
183:
184: OPEN c_get_security_grp_id;
185: FETCH c_get_security_grp_id INTO l_security_grp_id;

Line 237: l_sec_grp_id per_business_groups.security_group_id%TYPE;

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
241: || 'create_omp_template';

Line 447: l_sec_grp_id per_business_groups.security_group_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);
447: l_sec_grp_id per_business_groups.security_group_id%TYPE;
448: l_proc_name VARCHAR2(61) := g_proc_name ||
449: 'Create_osp_template' ;
450: i number;
451: BEGIN

Line 712: l_sec_grp_id per_business_groups.security_group_id%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 ||
714: 'Create_unp_template' ;
715: i number;
716: BEGIN