eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRDYNDBI dependencies on FND_ID_FLEX_SEGMENTS

Line 7304: FROM fnd_id_flex_segments

7300: --
7301: cursor c1 is
7302: SELECT application_column_name c_def_text,
7303: replace (ltrim(rtrim(upper(segment_name))),' ','_') c_db_name
7304: FROM fnd_id_flex_segments
7305: WHERE application_id = p_applic_id
7306: AND id_flex_num = p_id_flex_num
7307: AND id_flex_code = p_id_flex_code;
7308: --

Line 7372: table 'fnd_id_flex_segments'. For a given key flexfield there

7368: GRADE for 'p_keyflex_name' pass in : 'GRD'
7369: GROUP for 'p_keyflex_name' pass in : 'GRP'
7370: --
7371: The database items use the segment name column from the foundation
7372: table 'fnd_id_flex_segments'. For a given key flexfield there
7373: could be several database items.
7374: The following database items are created:
7375: --
7376: GRADE_KF_

Line 7534: table 'fnd_id_flex_segments'. For a given key flexfield there

7530: routes in this table by using the route name, which is hard coded below.
7531: The parameter passed in is the id_flex_num of the keyflex.
7532: --
7533: The database items use the segment name column from the foundation
7534: table 'fnd_id_flex_segments'. For a given key flexfield there
7535: could be several database items.
7536: --
7537: The routine has been enhanced to loop around to create dbitems
7538: for each of the legislations which use the flex_num passed in.

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

7619: Legislation Keyflex database items. The parameter passed is is the
7620: id flex number.
7621: --
7622: The database items created use the name as defined in the column
7623: 'segment_name' from the foundation table 'fnd_id_flex_segments'.
7624: There are 3 levels of SCL keyflex:
7625: --
7626: ASSIGNMENT
7627: PAYROLL

Line 7683: from fnd_id_flex_segments SEG

7679: select SEG.application_column_name c_def_text,
7680: replace (ltrim(rtrim(upper(SEG.segment_name))),' ','_') c_db_name,
7681: SEG.created_by c_created_by,
7682: SEG.last_update_login c_last_login
7683: from fnd_id_flex_segments SEG
7684: , fnd_segment_attribute_values VALUE
7685: where SEG.application_id = 800
7686: and SEG.id_flex_code = 'SCL'
7687: and SEG.id_flex_num = p_id_flex_num