APPS.PAY_ETP_BUS_ND dependencies on PAY_EVENT_GROUPS

Line 2160: p_event_group_type pay_event_groups.event_group_type%type;

2156: ) is
2157: --
2158: l_proc varchar2(72) := g_package||'chk_proration_values';
2159: l_exists varchar2(1);
2160: p_event_group_type pay_event_groups.event_group_type%type;
2161:
2162: Cursor c_chk_event_group_id(p_event_group_id number)
2163: is
2164: select '1', event_group_type

Line 2165: from pay_event_groups

2161:
2162: Cursor c_chk_event_group_id(p_event_group_id number)
2163: is
2164: select '1', event_group_type
2165: from pay_event_groups
2166: where event_group_id = p_event_group_id;
2167: --
2168: Begin
2169: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');

2210: --
2211: Close c_chk_event_group_id;
2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');
2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2215: fnd_message.raise_error;
2216: --
2217: Elsif p_event_group_type <> 'P' Then
2218: --

Line 2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');

2233: --
2234: Close c_chk_event_group_id;
2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');
2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2238: fnd_message.raise_error;
2239: --
2240: Elsif p_event_group_type <> 'R' Then
2241: --