APPS.PSP_AUTO_DYN dependencies on FND_FLEX_VALUE_SETS

Line 401: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2

397:
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

Line 417: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2

413: ELSIF p_flex_code= 'GRP' THEN
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

Line 434: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2

430: ELSIF p_flex_code= 'JOB' THEN
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

Line 451: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2

447: ELSIF p_flex_code= 'COST' then
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

Line 468: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets fifs2

464: ELSIF p_flex_code= 'POS' then
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

Line 496: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets ffvs,

492: IF p_flex_code= 'POS' THEN
493:
494: SELECT fdfcu.application_column_name, fifs1.application_column_name, fifs1.flex_value_set_id
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')