DBA Data[Home] [Help]

APPS.JE_JEHUIAGE_XMLP_PKG dependencies on AP_AGING_PERIODS

Line 139: AP_AGING_PERIODS AAP

135: MAX(DAYS_TO)
136: INTO MINDAY,MAXDAY
137: FROM
138: AP_AGING_PERIOD_LINES AAPL,
139: AP_AGING_PERIODS AAP
140: WHERE AAPL.AGING_PERIOD_ID = AAP.AGING_PERIOD_ID
141: AND UPPER(AAP.PERIOD_NAME) = UPPER(P_PERIOD_TYPE);
142: C_MINDAYS := MINDAY;
143: C_MAXDAYS := MAXDAY;

Line 454: AP_AGING_PERIODS PERIODS

450: REPORT_HEADING1,
451: REPORT_HEADING2
452: FROM
453: AP_AGING_PERIOD_LINES LINES,
454: AP_AGING_PERIODS PERIODS
455: WHERE LINES.AGING_PERIOD_ID = PERIODS.AGING_PERIOD_ID
456: AND UPPER(PERIODS.PERIOD_NAME) = UPPER(P_PERIOD_TYPE)
457: ORDER BY
458: LINES.PERIOD_SEQUENCE_NUM;