DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on DUAL

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

539: Cursor C_period_validator is
540: select count(1) period_allowed
541: From AP_OTHER_PERIODS aop,
542: (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),
543: add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')),'DD-MM-YYYY'), 4)) end_date_criteria from dual) temp
544: where aop.period_type =
545: fnd_profile.value('IGI_CIS2007_CALENDAR')
546: and aop.period_year <= 2099
547: and aop.end_date between to_date('05-05-2007', 'DD-MM-YYYY')

Line 707: FROM dual;

703: -- get the next header id
704: --
705: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval
706: INTO l_header_id
707: FROM dual;
708: -- for debugging
709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id: ' || l_header_id);
710: --
711: -- populate the header_table