APPS.HR_PUMP_GET dependencies on FND_ID_FLEX_STRUCTURES

Line 5419: from fnd_id_flex_structures

5415:
5416: ELSE
5417:
5418: select id_flex_num into l_cost_code
5419: from fnd_id_flex_structures
5420: where id_flex_structure_code = p_cost_flex_stru_code
5421: and id_flex_code ='COST';
5422: END IF;
5423:

Line 5452: from fnd_id_flex_structures

5448: return hr_api_g_number;
5449:
5450: ELSE
5451: select id_flex_num into l_grade_code
5452: from fnd_id_flex_structures
5453: where id_flex_structure_code = p_grade_flex_stru_code
5454: and id_flex_code ='GRD';
5455:
5456: END IF;

Line 5487: from fnd_id_flex_structures

5483:
5484: ELSE
5485:
5486: select id_flex_num into l_job_code
5487: from fnd_id_flex_structures
5488: where id_flex_structure_code = p_job_flex_stru_code
5489: and id_flex_code ='JOB';
5490: END IF;
5491:

Line 5521: from fnd_id_flex_structures

5517:
5518: ELSE
5519:
5520: select id_flex_num into l_position_code
5521: from fnd_id_flex_structures
5522: where id_flex_structure_code = p_position_flex_stru_code
5523: and id_flex_code ='POS';
5524: END IF;
5525:

Line 5555: from fnd_id_flex_structures

5551:
5552: ELSE
5553:
5554: select id_flex_num into l_group_code
5555: from fnd_id_flex_structures
5556: where id_flex_structure_code = p_group_flex_stru_code
5557: and id_flex_code ='GRP';
5558: END IF;
5559:

Line 5589: from fnd_id_flex_structures

5585:
5586: ELSE
5587:
5588: select id_flex_num into l_competence_code
5589: from fnd_id_flex_structures
5590: where id_flex_structure_code = p_competence_flex_stru_code
5591: and id_flex_code ='CMP';
5592: END IF;
5593: