APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 861: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg

857: where id_flex_name = l_definition_structure;
858:
859: Cursor C_key_44 is
860: SELECT fseg.application_column_name
861: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
862: WHERE fstr.application_id = l_application_id
863: AND fstr.id_flex_code = l_id_flex_code
864: AND fstr.id_flex_structure_name = l_definition_table
865: AND fstr.id_flex_code = fseg.id_flex_code

Line 1665: from fnd_id_flex_segments_vl

1661: where business_group_id = p_business_group_id;
1662:
1663: Cursor C_pos_segs is
1664: select application_column_name
1665: from fnd_id_flex_segments_vl
1666: where id_flex_code = 'POS'
1667: and id_flex_num = l_pos_id_flex_num
1668: and enabled_flag = 'Y'
1669: order by segment_num;

Line 1858: FROM fnd_id_flex_segments_vl

1854:
1855: FOR C_flex_rec in
1856: (
1857: Select application_column_name
1858: FROM fnd_id_flex_segments_vl
1859: WHERE id_flex_code = 'BPS'
1860: AND id_flex_num = l_position_id_flex_num
1861: AND enabled_flag = 'Y'
1862: ORDER BY segment_num

Line 2259: from fnd_id_flex_segments_vl

2255: where business_group_id = p_business_group_id;
2256:
2257: Cursor C_pos_segs is
2258: select application_column_name
2259: from fnd_id_flex_segments_vl
2260: where id_flex_code = 'POS'
2261: and id_flex_num = l_pos_id_flex_num
2262: and enabled_flag = 'Y'
2263: order by segment_num;

Line 2484: FROM fnd_id_flex_segments_vl

2480:
2481: FOR C_flex_rec in
2482: (
2483: Select application_column_name
2484: FROM fnd_id_flex_segments_vl
2485: WHERE id_flex_code = 'BPS'
2486: AND id_flex_num = l_position_id_flex_num
2487: AND enabled_flag = 'Y'
2488: ORDER BY segment_num

Line 2894: from fnd_id_flex_segments_vl

2890: where business_group_id = p_business_group_id;
2891:
2892: Cursor C_pos_segs is
2893: select application_column_name
2894: from fnd_id_flex_segments_vl
2895: where id_flex_code = 'POS'
2896: and id_flex_num = l_pos_id_flex_num
2897: and enabled_flag = 'Y'
2898: order by segment_num;

Line 3122: FROM fnd_id_flex_segments_vl

3118:
3119: FOR C_flex_rec in
3120: (
3121: Select application_column_name
3122: FROM fnd_id_flex_segments_vl
3123: WHERE id_flex_code = 'BPS'
3124: AND id_flex_num = l_position_id_flex_num
3125: AND enabled_flag = 'Y'
3126: ORDER BY segment_num

Line 3516: from fnd_id_flex_segments_vl

3512: where business_group_id = p_business_group_id_o;
3513:
3514: Cursor C_pos_segs is
3515: select application_column_name
3516: from fnd_id_flex_segments_vl
3517: where id_flex_code = 'POS'
3518: and id_flex_num = l_pos_id_flex_num
3519: and enabled_flag = 'Y'
3520: order by segment_num;

Line 3756: FROM fnd_id_flex_segments_vl

3752:
3753: FOR C_flex_rec in
3754: (
3755: Select application_column_name
3756: FROM fnd_id_flex_segments_vl
3757: WHERE id_flex_code = 'BPS'
3758: AND id_flex_num = l_position_id_flex_num
3759: AND enabled_flag = 'Y'
3760: ORDER BY segment_num

Line 6195: FROM fnd_id_flex_segments_vl

6191:
6192: FOR C_flex_rec in
6193: (
6194: Select application_column_name
6195: FROM fnd_id_flex_segments_vl
6196: WHERE id_flex_code = 'BPS'
6197: AND id_flex_num = l_id_flex_num
6198: AND enabled_flag = 'Y'
6199: ORDER BY segment_num