DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on PER_TIME_PERIODS

Line 1176: per_time_periods

1172: ,p_effective_date DATE ) IS
1173: select START_DATE
1174: ,END_DATE
1175: from
1176: per_time_periods
1177: where payroll_id=p_payroll_id
1178: and p_effective_date between START_DATE and END_DATE;
1179: BEGIN
1180:

Line 1341: per_time_periods

1337: ,p_effective_date DATE ) IS
1338: select START_DATE
1339: ,END_DATE
1340: from
1341: per_time_periods
1342: where payroll_id=p_payroll_id
1343: and p_effective_date between START_DATE and END_DATE;
1344: BEGIN
1345: OPEN get_payroll_period(p_payroll_id,p_effective_date);

Line 1417: per_time_periods

1413: ,p_effective_date DATE ) IS
1414: select START_DATE
1415: ,END_DATE
1416: from
1417: per_time_periods
1418: where payroll_id=p_payroll_id
1419: and p_effective_date between START_DATE and END_DATE;
1420:
1421: BEGIN