APPS.HR_PUMP_GET dependencies on FND_ID_FLEX_STRUCTURES

Line 5392: from fnd_id_flex_structures

5388:
5389: ELSE
5390:
5391: select id_flex_num into l_cost_code
5392: from fnd_id_flex_structures
5393: where id_flex_structure_code = p_cost_flex_stru_code
5394: and id_flex_code ='COST';
5395: END IF;
5396:

Line 5425: from fnd_id_flex_structures

5421: return hr_api_g_number;
5422:
5423: ELSE
5424: select id_flex_num into l_grade_code
5425: from fnd_id_flex_structures
5426: where id_flex_structure_code = p_grade_flex_stru_code
5427: and id_flex_code ='GRD';
5428:
5429: END IF;

Line 5460: from fnd_id_flex_structures

5456:
5457: ELSE
5458:
5459: select id_flex_num into l_job_code
5460: from fnd_id_flex_structures
5461: where id_flex_structure_code = p_job_flex_stru_code
5462: and id_flex_code ='JOB';
5463: END IF;
5464:

Line 5494: from fnd_id_flex_structures

5490:
5491: ELSE
5492:
5493: select id_flex_num into l_position_code
5494: from fnd_id_flex_structures
5495: where id_flex_structure_code = p_position_flex_stru_code
5496: and id_flex_code ='POS';
5497: END IF;
5498:

Line 5528: from fnd_id_flex_structures

5524:
5525: ELSE
5526:
5527: select id_flex_num into l_group_code
5528: from fnd_id_flex_structures
5529: where id_flex_structure_code = p_group_flex_stru_code
5530: and id_flex_code ='GRP';
5531: END IF;
5532:

Line 5562: from fnd_id_flex_structures

5558:
5559: ELSE
5560:
5561: select id_flex_num into l_competence_code
5562: from fnd_id_flex_structures
5563: where id_flex_structure_code = p_competence_flex_stru_code
5564: and id_flex_code ='CMP';
5565: END IF;
5566: