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 402: WHERE fifs.id_flex_code = 'GRD' and fifs.id_flex_num = (SELECT org_information4 FROM hr_organization_information

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

Line 418: WHERE fifs.id_flex_code = 'GRP' and fifs.id_flex_num = (SELECT org_information5 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 = 'GRP' and fifs.id_flex_num = (SELECT org_information5 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 = 'JOB' and fifs.id_flex_num = (SELECT org_information6 FROM hr_organization_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 = 'JOB' and fifs.id_flex_num = (SELECT org_information6 FROM hr_organization_information
436: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
437: and fifs.application_id = fifs1.application_id
438: and fifs.id_flex_code = fifs1.id_flex_code
439: and fifs.id_flex_num = fifs1.id_flex_num

Line 452: 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')

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 = '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')
453: AND fifs.application_id = fifs1.application_id
454: AND fifs.id_flex_code = fifs1.id_flex_code
455: AND fifs.id_flex_num = fifs1.id_flex_num
456: AND fifs1.flex_value_set_id = fifs2.flex_value_set_id

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

465:
466: SELECT fifs1.application_column_name
467: INTO p_appl_column_name
468: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2
469: WHERE fifs.id_flex_code = 'POS' and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
470: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
471: AND fifs.application_id = fifs1.application_id
472: AND fifs.id_flex_code = fifs1.id_flex_code
473: AND fifs.id_flex_num = fifs1.id_flex_num

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

495: INTO p_appl_column_name,p_dff_col_name, p_flex_val_set_id
496: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets ffvs,
497: fnd_descr_flex_column_usages fdfcu
498: WHERE fifs.id_flex_code = p_flex_code
499: and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
500: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
501: and fifs.application_id = fifs1.application_id and fifs.id_flex_code = fifs1.id_flex_code
502: and fifs.id_flex_num = fifs1.id_flex_num
503: and fifs1.enabled_flag = 'Y'