APPS.AP_APXINAGE_XMLP_PKG dependencies on AP_AGING_PERIOD_LINES

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 463: l_period_days_start ap_aging_period_lines.days_start%TYPE;

459:
460: END;
461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;

Line 464: l_period_days_to ap_aging_period_lines.days_to%TYPE;

460: END;
461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:

Line 465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;

461:
462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is

Line 466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;

462: FUNCTION get_period_info RETURN BOOLEAN IS
463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is
470: SELECT lines.days_start,

Line 467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;

463: l_period_days_start ap_aging_period_lines.days_start%TYPE;
464: l_period_days_to ap_aging_period_lines.days_to%TYPE;
465: l_period_seq_num ap_aging_period_lines.period_sequence_num%TYPE;
466: l_period_title1 ap_aging_period_lines.report_heading1%TYPE;
467: l_period_title2 ap_aging_period_lines.report_heading2%TYPE;
468:
469: cursor period_info is
470: SELECT lines.days_start,
471: lines.days_to,

Line 475: FROM ap_aging_period_lines lines,

471: lines.days_to,
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;