APPS.PSP_AUTO_DYN dependencies on FND_ID_FLEX_SEGMENTS

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

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

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

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

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

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

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

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

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

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

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

475: IF p_flex_code= 'POS' THEN
476:
477: SELECT fdfcu.application_column_name, fifs1.application_column_name, fifs1.flex_value_set_id
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')