APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PER_BUSINESS_GROUPS

Line 168: (P_BUSINESS_GROUP_ID IN per_business_groups.business_group_id%TYPE

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

Line 170: RETURN per_business_groups.security_group_id%TYPE

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

Line 180: from per_business_groups

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

Line 183: l_security_grp_id per_business_groups.security_group_id%TYPE;

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

Line 239: l_sec_grp_id per_business_groups.security_group_id%TYPE;

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

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

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