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.PSP_AUTO_DYN dependencies on HR_ORGANIZATION_INFORMATION

Line 385: WHERE fifs.id_flex_code = 'GRD' and fifs.id_flex_num = (SELECT org_information4 FROM hr_organization_information

381:
382: SELECT fifs1.application_column_name
383: INTO p_appl_column_name
384: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
385: WHERE fifs.id_flex_code = 'GRD' and fifs.id_flex_num = (SELECT org_information4 FROM hr_organization_information
386: WHERE organization_id = p_business_group_id
387: AND org_information_context = 'Business Group Information')
388: AND fifs.application_id = fifs1.application_id and fifs.id_flex_code = fifs1.id_flex_code
389: and fifs.id_flex_num = fifs1.id_flex_num and fifs1.flex_value_set_id = fifs2.flex_value_set_id

Line 401: WHERE fifs.id_flex_code = 'GRP' and fifs.id_flex_num = (SELECT org_information5 FROM hr_organization_information

397:
398: SELECT fifs1.application_column_name
399: INTO p_appl_column_name
400: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
401: WHERE fifs.id_flex_code = 'GRP' and fifs.id_flex_num = (SELECT org_information5 FROM hr_organization_information
402: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
403: and fifs.application_id = fifs1.application_id
404: and fifs.id_flex_code = fifs1.id_flex_code
405: and fifs.id_flex_num = fifs1.id_flex_num

Line 418: WHERE fifs.id_flex_code = 'JOB' and fifs.id_flex_num = (SELECT org_information6 FROM hr_organization_information

414:
415: SELECT fifs1.application_column_name
416: INTO p_appl_column_name
417: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
418: WHERE fifs.id_flex_code = 'JOB' and fifs.id_flex_num = (SELECT org_information6 FROM hr_organization_information
419: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
420: and fifs.application_id = fifs1.application_id
421: and fifs.id_flex_code = fifs1.id_flex_code
422: and fifs.id_flex_num = fifs1.id_flex_num

Line 435: WHERE fifs.id_flex_code = 'COST' and fifs.id_flex_num = (SELECT org_information7 FROM hr_organization_information WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')

431:
432: SELECT fifs1.application_column_name
433: INTO p_appl_column_name
434: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
435: WHERE fifs.id_flex_code = 'COST' and fifs.id_flex_num = (SELECT org_information7 FROM hr_organization_information WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
436: AND fifs.application_id = fifs1.application_id
437: AND fifs.id_flex_code = fifs1.id_flex_code
438: AND fifs.id_flex_num = fifs1.id_flex_num
439: AND fifs1.flex_value_set_id = fifs2.flex_value_set_id

Line 452: WHERE fifs.id_flex_code = 'POS' and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information

448:
449: SELECT fifs1.application_column_name
450: INTO p_appl_column_name
451: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
452: WHERE fifs.id_flex_code = 'POS' and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
453: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
454: AND fifs.application_id = fifs1.application_id
455: AND fifs.id_flex_code = fifs1.id_flex_code
456: AND fifs.id_flex_num = fifs1.id_flex_num

Line 482: and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information

478: INTO p_appl_column_name,p_dff_col_name, p_flex_val_set_id
479: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets ffvs,
480: fnd_descr_flex_column_usages fdfcu
481: WHERE fifs.id_flex_code = p_flex_code
482: and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
483: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
484: and fifs.application_id = fifs1.application_id and fifs.id_flex_code = fifs1.id_flex_code
485: and fifs.id_flex_num = fifs1.id_flex_num
486: and fifs1.enabled_flag = 'Y'