DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on PER_TIME_PERIOD_TYPES

Line 775: FROM per_time_period_types TPT,

771: IF months_between(p_start_date,nvl(p_end_date,l_end_date)) =12
772: THEN
773: SELECT TPT.number_per_fiscal_year
774: INTO l_periods
775: FROM per_time_period_types TPT,
776: pay_payrolls_f PRL
777: WHERE TPT.period_type = PRL.period_type
778: AND PRL.business_group_id = p_business_group_id
779: AND PRL.payroll_id = p_payroll_id;

Line 1411: FROM per_time_period_types TPT,

1407: /* IF months_between(p_start_date,nvl(p_end_date,l_end_date)) =12
1408: THEN
1409: SELECT TPT.number_per_fiscal_year
1410: INTO l_periods
1411: FROM per_time_period_types TPT,
1412: pay_payrolls_f PRL
1413: WHERE TPT.period_type = PRL.period_type
1414: AND PRL.business_group_id = p_business_group_id
1415: AND PRL.payroll_id = p_payroll_id;