DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on PER_TIME_PERIOD_TYPES

Line 809: FROM per_time_period_types TPT,

805: IF months_between(p_start_date,nvl(p_end_date,l_end_date)) =12
806: THEN
807: SELECT TPT.number_per_fiscal_year
808: INTO l_periods
809: FROM per_time_period_types TPT,
810: pay_payrolls_f PRL
811: WHERE TPT.period_type = PRL.period_type
812: AND PRL.business_group_id = p_business_group_id
813: AND PRL.payroll_id = p_payroll_id;

Line 1485: FROM per_time_period_types TPT,

1481: /* IF months_between(p_start_date,nvl(p_end_date,l_end_date)) =12
1482: THEN
1483: SELECT TPT.number_per_fiscal_year
1484: INTO l_periods
1485: FROM per_time_period_types TPT,
1486: pay_payrolls_f PRL
1487: WHERE TPT.period_type = PRL.period_type
1488: AND PRL.business_group_id = p_business_group_id
1489: AND PRL.payroll_id = p_payroll_id;