APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_OTHER_PERIODS

Line 761: From AP_OTHER_PERIODS aop,

757: --Fix 5743166
758:
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')

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

872: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
873: raise e_validation_exception;
874: End if;
875:
876: -- get the start_date and end_date from ap_other_periods
877: select start_date,end_date
878: into l_period_start_date,l_period_end_date
879: from ap_other_periods
880: where period_type = fnd_profile.value('IGI_CIS2007_CALENDAR')

Line 879: from ap_other_periods

875:
876: -- get the start_date and end_date from ap_other_periods
877: select start_date,end_date
878: into l_period_start_date,l_period_end_date
879: from ap_other_periods
880: where period_type = fnd_profile.value('IGI_CIS2007_CALENDAR')
881: and period_name = p_period_name;
882:
883: log(C_STATE_LEVEL, l_procedure_name, 'l_period_start_date='||l_period_start_date);