DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on DUAL

Line 763: add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')),'DD-MM-YYYY'), 4)) end_date_criteria from dual) temp

759: Cursor C_period_validator is
760: select count(1) period_allowed
761: From AP_OTHER_PERIODS aop,
762: (SELECT decode(SIGN(to_number(to_char(sysdate, 'DD')) -6), -1, add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')), 'DD-MM-YYYY'), 3),
763: add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')),'DD-MM-YYYY'), 4)) end_date_criteria from dual) temp
764: where aop.period_type =
765: fnd_profile.value('IGI_CIS2007_CALENDAR')
766: and aop.period_year <= 2099
767: and aop.end_date between to_date('05-05-2007', 'DD-MM-YYYY')

Line 949: FROM dual;

945: -- get the next header id
946: --
947: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval
948: INTO l_header_id
949: FROM dual;
950: log(C_STATE_LEVEL, l_procedure_name, 'l_header_id='||l_header_id);
951: --
952: -- populate the header_table
953: --