APPS.PAY_PGP_SHD dependencies on PAY_PEOPLE_GROUPS

Line 48: l_id_flex_num pay_people_groups.id_flex_num%type;

44: p_people_group_id out number,
45: p_group_name out varchar2,
46: p_id_flex_num out number) is
47: --
48: l_id_flex_num pay_people_groups.id_flex_num%type;
49: l_proc varchar2(72) := g_package||'segment_combination_check';
50: --
51: -- the cursor orgsel selects the valid id_flex_num (people group kf)
52: -- for the specified business group

Line 64: from pay_people_groups pgp

60: --
61: cursor pgsel is
62: select pgp.people_group_id,
63: pgp.group_name
64: from pay_people_groups pgp
65: where pgp.id_flex_num = l_id_flex_num
66: and pgp.enabled_flag = 'Y'
67: and (pgp.segment1 = p_segment1
68: or (pgp.segment1 is null

Line 264: If (p_constraint_name = 'PAY_PEOPLE_GROUPS_PK') Then

260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: If (p_constraint_name = 'PAY_PEOPLE_GROUPS_PK') Then
265: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
266: hr_utility.set_message_token('PROCEDURE', l_proc);
267: hr_utility.set_message_token('STEP','5');
268: hr_utility.raise_error;

Line 326: from pay_people_groups

322: segment27,
323: segment28,
324: segment29,
325: segment30
326: from pay_people_groups
327: where people_group_id = p_people_group_id;
328: --
329: l_proc varchar2(72) := g_package||'api_updating';
330: l_fct_ret boolean;