DBA Data[Home] [Help]

APPS.HR_DM_COPY dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 888: from fnd_id_flex_structures_vl

884: hr_dm_utility.message('INFO','copy across the ID_FLEX_STRUCTURE_NAMEs',15);
885:
886: select ID_FLEX_STRUCTURE_NAME
887: into l_org_information4
888: from fnd_id_flex_structures_vl
889: where id_flex_num = (select org_information4
890: from hr_organization_information
891: where org_information_context =
892: 'Business Group Information'

Line 897: from fnd_id_flex_structures_vl

893: and organization_id = l_business_group_id)
894: and ID_FLEX_CODE = 'GRD';
895: select ID_FLEX_STRUCTURE_NAME
896: into l_org_information5
897: from fnd_id_flex_structures_vl
898: where id_flex_num = (select org_information5
899: from hr_organization_information
900: where org_information_context =
901: 'Business Group Information'

Line 906: from fnd_id_flex_structures_vl

902: and organization_id = l_business_group_id)
903: and ID_FLEX_CODE = 'GRP';
904: select ID_FLEX_STRUCTURE_NAME
905: into l_org_information6
906: from fnd_id_flex_structures_vl
907: where id_flex_num = (select org_information6
908: from hr_organization_information
909: where org_information_context =
910: 'Business Group Information'

Line 915: from fnd_id_flex_structures_vl

911: and organization_id = l_business_group_id)
912: and ID_FLEX_CODE = 'JOB';
913: select ID_FLEX_STRUCTURE_NAME
914: into l_org_information7
915: from fnd_id_flex_structures_vl
916: where id_flex_num = (select org_information7
917: from hr_organization_information
918: where org_information_context =
919: 'Business Group Information'

Line 924: from fnd_id_flex_structures_vl

920: and organization_id = l_business_group_id)
921: and ID_FLEX_CODE = 'COST';
922: select ID_FLEX_STRUCTURE_NAME
923: into l_org_information8
924: from fnd_id_flex_structures_vl
925: where id_flex_num = (select org_information8
926: from hr_organization_information
927: where org_information_context =
928: 'Business Group Information'