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.PQH_LENGTH_OF_SERVICE_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 473: fnd_id_flex_structures fifs,

469:
470: cursor cur_corps is
471: select to_number(hsck.segment7) corps_id
472: from hr_soft_coding_keyflex hsck,
473: fnd_id_flex_structures fifs,
474: per_all_assignments_f paf,
475: per_all_people_f ppf
476: where hsck.id_flex_num = fifs.id_flex_num
477: and fifs.id_flex_structure_code = 'FR_STATUTORY_INFO.'

Line 2681: (select id_flex_num from fnd_id_flex_structures fifs

2677: RETURN VARCHAR2 IS
2678:
2679: cursor csr_corps is
2680: select segment7 from hr_soft_coding_keyflex where id_flex_num in
2681: (select id_flex_num from fnd_id_flex_structures fifs
2682: where id_flex_structure_code = 'FR_STATUTORY_INFO.'
2683: and fifs.application_id = 800 and fifs.id_flex_code = 'SCL')
2684: and soft_coding_keyflex_id in
2685: (select soft_coding_keyflex_id from per_all_assignments_f where