eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_JEHUIAGE_XMLP_PKG dependencies on AP_AGING_PERIOD_LINES

Line 138: AP_AGING_PERIOD_LINES AAPL,

134: MIN(DAYS_START),
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;

Line 440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;

436: RETURN (FALSE);
437: END SET_ORDER_BY;
438:
439: FUNCTION GET_PERIOD_INFO RETURN BOOLEAN IS
440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;
441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;
442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;
443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;
444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;

Line 441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;

437: END SET_ORDER_BY;
438:
439: FUNCTION GET_PERIOD_INFO RETURN BOOLEAN IS
440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;
441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;
442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;
443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;
444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;
445: CURSOR PERIOD_INFO IS

Line 442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;

438:
439: FUNCTION GET_PERIOD_INFO RETURN BOOLEAN IS
440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;
441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;
442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;
443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;
444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;
445: CURSOR PERIOD_INFO IS
446: SELECT

Line 443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;

439: FUNCTION GET_PERIOD_INFO RETURN BOOLEAN IS
440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;
441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;
442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;
443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;
444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;
445: CURSOR PERIOD_INFO IS
446: SELECT
447: LINES.DAYS_START,

Line 444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;

440: L_PERIOD_DAYS_START AP_AGING_PERIOD_LINES.DAYS_START%TYPE;
441: L_PERIOD_DAYS_TO AP_AGING_PERIOD_LINES.DAYS_TO%TYPE;
442: L_PERIOD_SEQ_NUM AP_AGING_PERIOD_LINES.PERIOD_SEQUENCE_NUM%TYPE;
443: L_PERIOD_TITLE1 AP_AGING_PERIOD_LINES.REPORT_HEADING1%TYPE;
444: L_PERIOD_TITLE2 AP_AGING_PERIOD_LINES.REPORT_HEADING2%TYPE;
445: CURSOR PERIOD_INFO IS
446: SELECT
447: LINES.DAYS_START,
448: LINES.DAYS_TO,

Line 453: AP_AGING_PERIOD_LINES LINES,

449: LINES.PERIOD_SEQUENCE_NUM,
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