DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on FND_ID_FLEX_SEGMENTS

Line 776: 'segment_name' from the foundation table 'fnd_id_flex_segments'.

772: Legislation Keyflex database items. The parameter passed is is the
773: id flex number.
774: --
775: The database items created use the name as defined in the column
776: 'segment_name' from the foundation table 'fnd_id_flex_segments'.
777: There are 3 levels of SCL keyflex:
778: --
779: ASSIGNMENT
780: PAYROLL

Line 836: from fnd_id_flex_segments SEG

832: select SEG.application_column_name c_def_text,
833: replace (ltrim(rtrim(upper(SEG.segment_name))),' ','_') c_db_name,
834: SEG.created_by c_created_by,
835: SEG.last_update_login c_last_login
836: from fnd_id_flex_segments SEG
837: , fnd_segment_attribute_values VALUE
838: where SEG.application_id = 800
839: and SEG.id_flex_code = 'SCL'
840: and SEG.id_flex_num = p_id_flex_num