DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on PER_ORGANIZATION_STRUCTURES_V

Line 1259: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V

1255: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'
1256: -- HR:COST_MAND_SEG_CHECK fnd_lookups where lookup_type ='YES_NO'
1257: -- HR_BG_LOCATIONS FND_COMMON_LOOKUPS where lookup_type =
1258: -- 'YES_NO'
1259: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V
1260: --
1261: -- --------------------------------------------------------------------------
1262: -- Update for Fix 2288014 Start.
1263: -- Following are new profile options (application_id between 800 and 899)

Line 1303: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V,

1299: -- HR_ORGANIZATION_INFORMATION,
1300: -- HR_ALL_ORGANIZATION_UNITS
1301: -- HR_NL_JOB_LEVEL_PROFILE FND_LOOKUP_VALUES
1302: -- BEN_USER_TO_PAYROLL_LINK PAY_ALL_PAYROLLS_F
1303: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V,
1304: -- PER_BUSINESS_GROUPS
1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS

Line 1528: FROM PER_ORGANIZATION_STRUCTURES_V OST,

1524: --HR_BIS_REPORTING_HIERARCHY
1525: CURSOR lc_get_bis_rep_hierarchy IS
1526: SELECT OST.NAME visible_option_value,
1527: OST.ORGANIZATION_STRUCTURE_ID profile_option_value
1528: FROM PER_ORGANIZATION_STRUCTURES_V OST,
1529: PER_BUSINESS_GROUPS ORG
1530: WHERE OST.BUSINESS_GROUP_ID = ORG.BUSINESS_GROUP_ID
1531: ORDER BY OST.NAME;
1532: