DBA Data[Home] [Help]

APPS.HR_DM_AOL_UP dependencies on FND_SECURITY_GROUPS

Line 88: fnd_security_groups sg,

84:
85: CURSOR csr_migration_info IS
86: SELECT sg.security_group_key
87: FROM hr_dm_migrations dm,
88: fnd_security_groups sg,
89: per_business_groups pbg
90: WHERE dm.migration_id = p_migration_id
91: AND dm.business_group_id = pbg.business_group_id
92: AND pbg.security_group_id = sg.security_group_id;

Line 409: FROM fnd_security_groups_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
409: FROM fnd_security_groups_vl
410: WHERE security_group_key = l_org_information14;
411:
412: UPDATE hr_organization_information
413: SET ORG_INFORMATION4 = l_org_information4_id,