APPS.PAY_GBE_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 426: -- will have to be an element_type id which exists on pay_element_types_f.

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.
430: --

Line 460: from pay_element_types_f et

456: where ee.element_entry_id = p_source_id ;
457: --
458: cursor C_et is
459: Select distinct et.element_type_id
460: from pay_element_types_f et
461: where et.element_type_id = p_source_id ;
462: --
463: begin
464: --