APPS.PA_PAY_VALIDATE dependencies on PA_PAY_EXTERNAL_TIME_PERIODS

Line 380: select count(1) into l_value_exists from PA_PAY_EXTERNAL_TIME_PERIODS where

376:
377:
378: /* Inserting a record into time period table */
379:
380: select count(1) into l_value_exists from PA_PAY_EXTERNAL_TIME_PERIODS where
381: time_period_start_date = Hdr_rec.time_period_start_date
382: and time_period_end_date = Hdr_rec.time_period_end_date
383: and payroll_id = Hdr_rec.payroll_id;
384:

Line 388: Insert into PA_PAY_EXTERNAL_TIME_PERIODS(PAYROLL_ID,

384:
385: IF(l_value_exists = 0) THEN
386: --{
387:
388: Insert into PA_PAY_EXTERNAL_TIME_PERIODS(PAYROLL_ID,
389: TIME_PERIOD_ID,
390: TIME_PERIOD_START_DATE,
391: TIME_PERIOD_END_DATE,
392: LAST_UPDATE_DATE,

Line 395: PA_PAY_EXTERNAL_TIME_PERIODS_S.nextval,

391: TIME_PERIOD_END_DATE,
392: LAST_UPDATE_DATE,
393: LAST_UPDATED_BY,CREATION_DATE,
394: CREATED_BY,LAST_UPDATE_LOGIN) values (Hdr_rec.payroll_id,
395: PA_PAY_EXTERNAL_TIME_PERIODS_S.nextval,
396: Hdr_rec.time_period_start_date,
397: Hdr_rec.time_period_end_date,
398: sysdate,-1,sysdate,-1,null);
399: