APPS.HR_USER_ACCT_INTERNAL dependencies on PER_BUSINESS_GROUPS

Line 1220: -- PER_BUSINESS_GROUP_ID per_business_groups

1216: -- 'YES_NO'
1217: --
1218: -- PER_ATTACHMENT_USAGE fnd_lookups where lookup_type ='YES_NO'
1219: --
1220: -- PER_BUSINESS_GROUP_ID per_business_groups
1221: --
1222: -- PER_DEFAULT_CORRESPONDENCE_LANGUAGE fnd_languages
1223: --
1224: -- PER_DEFAULT_NATIONALITY FND_COMMON_LOOKUPS where lookup_type =

Line 1254: -- HR_PAYROLL_CURRENCY_RATES pay_payrolls_f and per_business_groups

1250: -- OTA_WAITLIST_SORT_CRITERIA
1251: -- PAY_USER_FF_PTO
1252: --
1253: -- *** The following options are not found in Seed11.5 db as of May 2000 ***
1254: -- HR_PAYROLL_CURRENCY_RATES pay_payrolls_f and per_business_groups
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'

Line 1282: -- OTA_HR_GLOBAL_BUSINESS_GROUP_ID PER_BUSINESS_GROUPS

1278: -- BEN_NEW_USER_RESP_PROFILE FND_RESPONSIBILITY_TL,
1279: -- FND_RESPONSIBILITY
1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,
1281: -- HR_ALL_ORGANIZATION_UNITS_TL
1282: -- OTA_HR_GLOBAL_BUSINESS_GROUP_ID PER_BUSINESS_GROUPS
1283: -- HR_DISPLAY_ALL_OFFERS FND_LOOKUPS
1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS
1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS

Line 1304: -- PER_BUSINESS_GROUPS

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
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS

Line 1407: FROM per_business_groups;

1403: -- PER_BUSINESS_GROUP_ID
1404: CURSOR lc_get_bg_id IS
1405: SELECT name
1406: ,business_group_id
1407: FROM per_business_groups;
1408:
1409: -- PER_DEFAULT_CORRESPONDENCE_LANGUAGE
1410: CURSOR lc_get_def_lang IS
1411: SELECT initcap(NLS_LANGUAGE)

Line 1438: ,per_business_groups per

1434: SELECT pay.payroll_name
1435: ,pay.payroll_id
1436: ,per.name
1437: FROM pay_payrolls_f pay
1438: ,per_business_groups per
1439: WHERE pay.business_group_id = per.business_group_id
1440: AND sysdate between effective_start_date and effective_end_date
1441: ORDER BY pay.payroll_id;
1442:

Line 1484: FROM PER_BUSINESS_GROUPS;

1480:
1481: --OTA_HR_GLOBAL_BUSINESS_GROUP_ID
1482: CURSOR lc_get_glbl_bd_id IS
1483: SELECT NAME visible_option_value, BUSINESS_GROUP_ID profile_option_value
1484: FROM PER_BUSINESS_GROUPS;
1485:
1486:
1487: -- OTA_DEFAULT_EVENT_OWNER
1488: CURSOR lc_get_def_envt_ownr IS

Line 1529: PER_BUSINESS_GROUPS ORG

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:
1533: