DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPPADR_PKG dependencies on AP_OTHER_PERIODS

Line 98: l_period_type AP_OTHER_PERIODS.Period_Type%TYPE;

94: return(l_org_name);
95: end get_ORG_NAME;
96: -------------------------------------------------------------------------------
97: function get_PERIOD_END_DATE return varchar2 is
98: l_period_type AP_OTHER_PERIODS.Period_Type%TYPE;
99: l_end_date AP_OTHER_PERIODS.Start_Date%TYPE;
100: begin
101: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
102: select end_date

Line 99: l_end_date AP_OTHER_PERIODS.Start_Date%TYPE;

95: end get_ORG_NAME;
96: -------------------------------------------------------------------------------
97: function get_PERIOD_END_DATE return varchar2 is
98: l_period_type AP_OTHER_PERIODS.Period_Type%TYPE;
99: l_end_date AP_OTHER_PERIODS.Start_Date%TYPE;
100: begin
101: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
102: select end_date
103: into l_end_date

Line 104: from AP_OTHER_PERIODS

100: begin
101: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
102: select end_date
103: into l_end_date
104: from AP_OTHER_PERIODS
105: where period_type = l_period_type
106: and period_name = P_PERIOD;
107: return(l_end_date);
108: exception