DBA Data[Home] [Help]

APPS.HR_QSA_BUS dependencies on PER_PARTICIPANTS

Line 258: l_part_in_tab PER_PARTICIPANTS.participation_in_table%TYPE;

254: is
255: --
256: l_proc varchar2(72):= g_package || 'chk_type_object_id';
257: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;
258: l_part_in_tab PER_PARTICIPANTS.participation_in_table%TYPE;
259: l_part_in_col PER_PARTICIPANTS.participation_in_column%TYPE;
260: l_exists varchar2(1);
261: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
262: --

Line 259: l_part_in_col PER_PARTICIPANTS.participation_in_column%TYPE;

255: --
256: l_proc varchar2(72):= g_package || 'chk_type_object_id';
257: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;
258: l_part_in_tab PER_PARTICIPANTS.participation_in_table%TYPE;
259: l_part_in_col PER_PARTICIPANTS.participation_in_column%TYPE;
260: l_exists varchar2(1);
261: lv_cross_business_group VARCHAR2(10); -- bug 1980440 fix
262: --
263: -- Cursor to determine if type_object_id is valid when

Line 276: from per_participants pp

272: -- type = 'PARTICIPANT'
273: --
274: cursor csr_type_participant is
275: select business_group_id, participation_in_table, participation_in_column
276: from per_participants pp
277: where p_type_object_id = pp.participant_id;
278: --
279: -- Cursor to check that type_object_id is unique
280: -- for the given type.