APPS.AP_APXINAGE_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

  SELECT  p.base_currency_code,
          c.precision,
          nvl(c.minimum_accountable_unit,0),
          c.description
  INTO    base_curr,
          prec,
          min_au,
          descr
  FROM    ap_system_parameters p,
          fnd_currencies_vl c
  WHERE   p.base_currency_code  = c.currency_code;

Line: 51

    SELECT displayed_field
    INTO   l_sort_option
    FROM   ap_lookup_codes
    WHERE  lookup_type = 'AGING_SORT_OPTION'
    AND    lookup_code = P_SORT_OPTION;

Line: 60

    SELECT Meaning
    INTO   C_HEAD_SUMMARY_OPTION
    FROM   FND_LOOKUPS
    WHERE  lookup_code = P_SUMMARY_OPTION
    AND    lookup_type = 'YES_NO';

Line: 70

    SELECT Meaning
    INTO   C_HEAD_FORMAT_OPTION
    FROM   FND_LOOKUPS
    WHERE  lookup_code = P_FORMAT_OPTION
    AND    lookup_type = 'YES_NO';

Line: 79

    SELECT displayed_field
    INTO   l_nls_all
    FROM   ap_lookup_codes
    WHERE  lookup_type = 'NLS REPORT PARAMETER'
    AND    lookup_code = 'ALL';

Line: 87

      C_INVOICE_TYPE_SELECT := '%';

Line: 90

      SELECT displayed_field
      INTO   l_invoice_type
      FROM   ap_lookup_codes
      WHERE  lookup_type = 'INVOICE TYPE'
      AND    lookup_code = P_INVOICE_TYPE;

Line: 96

      C_INVOICE_TYPE_SELECT := P_INVOICE_TYPE;

Line: 101

       SELECT hp.party_name
       INTO   l_party_name
       FROM   hz_parties hp
       WHERE  party_id = P_PARTY_ID;

Line: 105

       C_VENDOR_NAME_SELECT := L_PARTY_NAME;

Line: 109

       C_VENDOR_NAME_SELECT := '%';

Line: 114

    SELECT min(days_start), max(days_to)
    INTO   MINDAY, MAXDAY
    FROM   ap_aging_period_lines aapl, ap_aging_periods aap
    WHERE  aapl.aging_period_id = aap.aging_period_id
      AND  upper(aap.period_name) = upper(P_PERIOD_TYPE);

Line: 163

   SELECT  ly.meaning,
           ln.meaning,
           la.displayed_field
   INTO    nls_yes,  nls_no,  nls_all
   FROM    fnd_lookups ly,  fnd_lookups ln,  ap_lookup_codes la
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   la.lookup_type = 'NLS REPORT PARAMETER'
     AND   la.lookup_code = 'ALL';

Line: 282

	SELECT sort_by_alternate_field
	INTO SORT_BY_ALTERNATE
	FROM AP_SYSTEM_PARAMETERS;

Line: 354

  SELECT  name,
          chart_of_accounts_id
  INTO    l_name,
          l_chart_of_accounts_id
  FROM    gl_sets_of_books
  WHERE   set_of_books_id = l_sob_id;

Line: 392

             decode(:C_VENDOR_NAME_SELECT,
                        ''%'',decode(:SORT_BY_ALTERNATE, ''Y'',
                                     UPPER(v.vendor_name_alt), UPPER(v.vendor_name)),
                              decode(:SORT_BY_ALTERNATE, ''Y'', v.vendor_name_alt, v.vendor_name)),
             v.vendor_id,
             decode(:SORT_BY_ALTERNATE, ''Y'', vs.vendor_site_code_alt, vs.vendor_site_code),
	     i.invoice_type_lookup_code,
	     ps.due_date,
             i.invoice_num,
             ps.payment_num';

Line: 409

             decode(:C_VENDOR_NAME_SELECT,
                        ''%'',decode(:SORT_BY_ALTERNATE, ''Y'',
                                     UPPER(v.vendor_name_alt), UPPER(v.vendor_name)),
                              decode(:SORT_BY_ALTERNATE, ''Y'', v.vendor_name_alt, v.vendor_name)),
             v.vendor_id,
             decode(:SORT_BY_ALTERNATE, ''Y'', vs.vendor_site_code_alt, vs.vendor_site_code),
	     i.invoice_type_lookup_code,
	     ps.due_date,
             i.invoice_num,
             ps.payment_num';

Line: 425

             decode(:C_VENDOR_NAME_SELECT,
                        ''%'',decode(:SORT_BY_ALTERNATE, ''Y'',
                                     UPPER(v.vendor_name_alt), UPPER(v.vendor_name)),
                              decode(:SORT_BY_ALTERNATE, ''Y'', v.vendor_name_alt, v.vendor_name)),
             v.vendor_id,
             decode(:SORT_BY_ALTERNATE, ''Y'', vs.vendor_site_code_alt, vs.vendor_site_code),
	     i.invoice_type_lookup_code,
	     ps.due_date,
             i.invoice_num,
             ps.payment_num';

Line: 442

             decode(:C_VENDOR_NAME_SELECT,
                        ''%'',decode(:SORT_BY_ALTERNATE, ''Y'',
                                     UPPER(v.vendor_name_alt), UPPER(v.vendor_name)),
                              decode(:SORT_BY_ALTERNATE, ''Y'', v.vendor_name_alt, v.vendor_name)),
             v.vendor_id,
             decode(:SORT_BY_ALTERNATE, ''Y'', vs.vendor_site_code_alt, vs.vendor_site_code),
	     i.invoice_type_lookup_code,
	     ps.due_date,
             i.invoice_num,
             ps.payment_num';

Line: 470

  SELECT   lines.days_start,
           lines.days_to,
           lines.period_sequence_num,
           report_heading1,
           report_heading2
  FROM     ap_aging_period_lines lines,
           ap_aging_periods periods
  WHERE    lines.aging_period_id = periods.aging_period_id
  AND      upper(periods.period_name) = upper(p_period_type)
  ORDER BY lines.period_sequence_num;

Line: 533

   SELECT  substr(first_name,1,1), last_name,phone
   INTO    l_first_name,l_last_name,l_phone
   FROM    po_vendor_contacts
   WHERE   vendor_site_id = C_CONTACT_SITE_ID
   AND     rownum = 1;

Line: 904

 Function C_VENDOR_NAME_SELECT_p return varchar2 is
	Begin
	 return C_VENDOR_NAME_SELECT;

Line: 908

 Function C_INVOICE_TYPE_SELECT_p return varchar2 is
	Begin
	 return C_INVOICE_TYPE_SELECT;