DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on PER_TIME_PERIODS

Line 1193: per_time_periods

1189: ,p_effective_date DATE ) IS
1190: select START_DATE
1191: ,END_DATE
1192: from
1193: per_time_periods
1194: where payroll_id=p_payroll_id
1195: and p_effective_date between START_DATE and END_DATE;
1196: BEGIN
1197:

Line 1358: per_time_periods

1354: ,p_effective_date DATE ) IS
1355: select START_DATE
1356: ,END_DATE
1357: from
1358: per_time_periods
1359: where payroll_id=p_payroll_id
1360: and p_effective_date between START_DATE and END_DATE;
1361: BEGIN
1362: OPEN get_payroll_period(p_payroll_id,p_effective_date);

Line 1434: per_time_periods

1430: ,p_effective_date DATE ) IS
1431: select START_DATE
1432: ,END_DATE
1433: from
1434: per_time_periods
1435: where payroll_id=p_payroll_id
1436: and p_effective_date between START_DATE and END_DATE;
1437:
1438: BEGIN