DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPPADR_PKG dependencies on AP_OTHER_PERIODS

Line 100: l_period_type AP_OTHER_PERIODS.Period_Type%TYPE;

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

Line 101: l_end_date AP_OTHER_PERIODS.Start_Date%TYPE;

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

Line 106: from AP_OTHER_PERIODS

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