APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_OTHER_PERIODS

Line 541: From AP_OTHER_PERIODS aop,

537: --Fix 5743166
538:
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')

Line 641: -- get the start_date and end_date from ap_other_periods

637: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
638: raise e_validation_exception;
639: End if;
640:
641: -- get the start_date and end_date from ap_other_periods
642: select start_date,end_date
643: into l_period_start_date,l_period_end_date
644: from ap_other_periods
645: where period_type = fnd_profile.value('IGI_CIS2007_CALENDAR')

Line 644: from ap_other_periods

640:
641: -- get the start_date and end_date from ap_other_periods
642: select start_date,end_date
643: into l_period_start_date,l_period_end_date
644: from ap_other_periods
645: where period_type = fnd_profile.value('IGI_CIS2007_CALENDAR')
646: and period_name = p_period_name;
647:
648: -- Throw error if there is a nil return already.