APPS.PAY_GBE_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 425: -- which exists on pay_element_entries_f. If source_type is 'ET', source_id

421: -- Description
422: -- This procedure is used to check that for the row being updated or inserted,
423: -- the source type is either 'EE' or 'ET', and source_id is not null.
424: -- Also, if source_type is 'EE', source_id will have to be an element_entry_id
425: -- which exists on pay_element_entries_f. If source_type is 'ET', source_id
426: -- will have to be an element_type id which exists on pay_element_types_f.
427: --
428: -- Pre Conditions
429: -- None.

Line 455: from pay_element_entries_f ee

451: l_proc varchar2(72) := g_package||'chk_source ';
452: --
453: cursor C_ee is
454: Select distinct ee.element_entry_id
455: from pay_element_entries_f ee
456: where ee.element_entry_id = p_source_id ;
457: --
458: cursor C_et is
459: Select distinct et.element_type_id