APPS.PAY_PEL_BUS dependencies on PAY_PEOPLE_GROUPS

Line 1189: from pay_people_groups ppg

1185: l_dummy varchar2(1);
1186:
1187: cursor csr_people_group_id is
1188: select 'X'
1189: from pay_people_groups ppg
1190: where people_group_id = p_people_group_id
1191: and p_effective_date between nvl(ppg.start_date_active,p_effective_date)
1192: and nvl(ppg.end_date_active, g_eot);
1193: --

Line 1203: fnd_message.set_token('TABLE','pay_people_groups');

1199: if csr_people_group_id%notfound then
1200: close csr_people_group_id;
1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;
1206: end if;
1207: close csr_people_group_id;