DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 116: FROM per_time_periods

112: ,c_start_date IN DATE
113: ,c_end_date IN DATE)IS
114: SELECT start_date
115: ,end_date
116: FROM per_time_periods
117: WHERE payroll_id = c_payroll_id
118: AND end_date BETWEEN c_start_date
119: AND c_end_date;
120: --=========================================================================

Line 125: FROM per_time_periods

121: CURSOR csr_get_period(c_payroll_id IN NUMBER
122: ,c_effective_date IN DATE)IS
123: SELECT start_date
124: ,end_date
125: FROM per_time_periods
126: WHERE payroll_id = c_payroll_id
127: AND c_effective_date BETWEEN start_date
128: AND end_date;
129: