APPS.PAY_GB_ENROLL_PENSION dependencies on FND_ID_FLEX_STRUCTURES

Line 2425: FROM fnd_id_flex_structures b ,

2421: AND G_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE;
2422: CURSOR c_group_name_check (p_group_name VARCHAR2)
2423: IS
2424: SELECT 1
2425: FROM fnd_id_flex_structures b ,
2426: fnd_id_flex_structures_tl t
2427: WHERE b.id_flex_num = t.id_flex_num
2428: AND b.id_flex_code = 'GRP'
2429: AND t.language = 'US'

Line 2426: fnd_id_flex_structures_tl t

2422: CURSOR c_group_name_check (p_group_name VARCHAR2)
2423: IS
2424: SELECT 1
2425: FROM fnd_id_flex_structures b ,
2426: fnd_id_flex_structures_tl t
2427: WHERE b.id_flex_num = t.id_flex_num
2428: AND b.id_flex_code = 'GRP'
2429: AND t.language = 'US'
2430: AND t.id_flex_structure_name = p_group_name;

Line 2435: FROM fnd_id_flex_structures b ,

2431: CURSOR c_col_name (p_group_name VARCHAR2,p_seg_name VARCHAR2)
2432: IS
2433: SELECT application_column_name,
2434: b.id_flex_num
2435: FROM fnd_id_flex_structures b ,
2436: fnd_id_flex_structures_tl t ,
2437: fnd_id_flex_segments c
2438: WHERE b.id_flex_code = 'GRP'
2439: AND t.language = 'US'

Line 2436: fnd_id_flex_structures_tl t ,

2432: IS
2433: SELECT application_column_name,
2434: b.id_flex_num
2435: FROM fnd_id_flex_structures b ,
2436: fnd_id_flex_structures_tl t ,
2437: fnd_id_flex_segments c
2438: WHERE b.id_flex_code = 'GRP'
2439: AND t.language = 'US'
2440: AND t.id_flex_num = b.id_flex_num