APPS.AP_APXINAGE_XMLP_PKG dependencies on AP_AGING_PERIODS

Line 116: FROM ap_aging_period_lines aapl, ap_aging_periods aap

112: END;
113: BEGIN
114: SELECT min(days_start), max(days_to)
115: INTO MINDAY, MAXDAY
116: FROM ap_aging_period_lines aapl, ap_aging_periods aap
117: WHERE aapl.aging_period_id = aap.aging_period_id
118: AND upper(aap.period_name) = upper(P_PERIOD_TYPE);
119: C_MINDAYS := MINDAY;
120: C_MAXDAYS := MAXDAY;

Line 476: ap_aging_periods periods

472: lines.period_sequence_num,
473: report_heading1,
474: report_heading2
475: FROM ap_aging_period_lines lines,
476: ap_aging_periods periods
477: WHERE lines.aging_period_id = periods.aging_period_id
478: AND upper(periods.period_name) = upper(p_period_type)
479: ORDER BY lines.period_sequence_num;
480: