APPS.HR_USER_ACCT_INTERNAL dependencies on PAY_PAYROLLS_F

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 1437: FROM pay_payrolls_f pay

1433: CURSOR lc_get_pay_curr_rates IS
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;

Line 1517: FROM PAY_PAYROLLS_F PPF

1513:
1514: -- BEN_USER_TO_PAYROLL_LINK
1515: CURSOR lc_get_usr_payroll_lnk IS
1516: SELECT PPF.PAYROLL_NAME visible_option_value ,PPF.PAYROLL_ID profile_option_value
1517: FROM PAY_PAYROLLS_F PPF
1518: WHERE SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
1519: AND PPF.EFFECTIVE_END_DATE
1520: AND NVL( PPF.PAYROLL_TYPE, 'PAYROLL' ) <> 'BENEFIT'
1521: ORDER BY PPF.PAYROLL_NAME;