APPS.HR_DM_AOL_UP dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 384: FROM fnd_id_flex_structures_vl

380: FROM hr_dm_exp_hr_org_inf_flx_v;
381:
382: SELECT ID_FLEX_NUM
383: INTO l_org_information4_id
384: FROM fnd_id_flex_structures_vl
385: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information4
386: AND ID_FLEX_CODE = 'GRD';
387: SELECT ID_FLEX_NUM
388: INTO l_org_information5_id

Line 389: FROM fnd_id_flex_structures_vl

385: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information4
386: AND ID_FLEX_CODE = 'GRD';
387: SELECT ID_FLEX_NUM
388: INTO l_org_information5_id
389: FROM fnd_id_flex_structures_vl
390: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information5
391: AND ID_FLEX_CODE = 'GRP';
392: SELECT ID_FLEX_NUM
393: INTO l_org_information6_id

Line 394: FROM fnd_id_flex_structures_vl

390: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information5
391: AND ID_FLEX_CODE = 'GRP';
392: SELECT ID_FLEX_NUM
393: INTO l_org_information6_id
394: FROM fnd_id_flex_structures_vl
395: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information6
396: AND ID_FLEX_CODE = 'JOB';
397: SELECT ID_FLEX_NUM
398: INTO l_org_information7_id

Line 399: FROM fnd_id_flex_structures_vl

395: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information6
396: AND ID_FLEX_CODE = 'JOB';
397: SELECT ID_FLEX_NUM
398: INTO l_org_information7_id
399: FROM fnd_id_flex_structures_vl
400: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information7
401: AND ID_FLEX_CODE = 'COST';
402: SELECT ID_FLEX_NUM
403: INTO l_org_information8_id

Line 404: FROM fnd_id_flex_structures_vl

400: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information7
401: AND ID_FLEX_CODE = 'COST';
402: SELECT ID_FLEX_NUM
403: INTO l_org_information8_id
404: FROM fnd_id_flex_structures_vl
405: WHERE ID_FLEX_STRUCTURE_NAME = l_org_information8
406: AND ID_FLEX_CODE = 'POS';
407: SELECT security_group_id
408: INTO l_org_information14_id