DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_ID_FLEX_STRUCTURES

Line 2278: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;

2274: l_no VARCHAR2(1) := 'N';
2275: /* Bug#4958997 End*/
2276:
2277: /* Start bug #4924031 */
2278: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
2279: l_application_id fnd_id_flex_structures.application_id%TYPE;
2280: l_yes_flag VARCHAR2(1);
2281: /* End bug #4924031 */
2282:

Line 2279: l_application_id fnd_id_flex_structures.application_id%TYPE;

2275: /* Bug#4958997 End*/
2276:
2277: /* Start bug #4924031 */
2278: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
2279: l_application_id fnd_id_flex_structures.application_id%TYPE;
2280: l_yes_flag VARCHAR2(1);
2281: /* End bug #4924031 */
2282:
2283:

Line 3600: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg

3596:
3597: Cursor C_key_22 is
3598: SELECT fstr.id_flex_num, fseg.application_column_name,
3599: fseg.flex_value_set_id
3600: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
3601: WHERE fstr.application_id = l_application_id
3602: AND fstr.id_flex_code = l_id_flex_code
3603: AND fstr.id_flex_structure_name = l_definition_table
3604: AND fstr.id_flex_code = fseg.id_flex_code

Line 4601: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg

4597:
4598: Cursor C_key_44 is
4599: SELECT fseg.application_column_name,
4600: fstr.id_flex_num
4601: FROM fnd_id_flex_structures_vl fstr,fnd_id_flex_segments_vl fseg
4602: WHERE fstr.application_id = l_application_id
4603: AND fstr.id_flex_code = l_id_flex_code
4604: AND fstr.id_flex_structure_name = l_definition_table
4605: AND fstr.id_flex_code = fseg.id_flex_code