APPS.AR_RAXNCAR_XMLP_PKG SQL Statements

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

Line: 12

    SELECT cp.user_concurrent_program_name
    INTO   l_report_name
    FROM   FND_CONCURRENT_PROGRAMS_VL cp,
           FND_CONCURRENT_REQUESTS cr
    WHERE  cr.request_id = P_CONC_REQUEST_ID
    AND    cp.application_id = cr.program_application_id
    AND    cp.concurrent_program_id = cr.concurrent_program_id;

Line: 53

SELECT
        INITCAP(YES.MEANING)                            yes,
        INITCAP(NO.MEANING)                             no,
        CM.MEANING                                      cm_foot,
        DEP.MEANING                                     dep_foot,
        GUAR.MEANING                                    guar_foot,
        INV.MEANING                                     inv_foot
INTO
 	yes,
        no,
        cm_foot,
        dep_foot,
        guar_foot,
        inv_foot
FROM
        AR_LOOKUPS                      YES,
        AR_LOOKUPS                      NO,
        AR_LOOKUPS                      CM,
        AR_LOOKUPS                      DEP,
        AR_LOOKUPS                      GUAR,
        AR_LOOKUPS                      INV
WHERE
        YES.LOOKUP_TYPE = 'YES/NO'                              AND
        YES.LOOKUP_CODE = 'Y'
AND
        NO.LOOKUP_TYPE = 'YES/NO'                               AND
        NO.LOOKUP_CODE = 'N'
AND
        CM.LOOKUP_TYPE = 'INV/CM'                               AND
        CM.LOOKUP_CODE = 'CM'
AND
        DEP.LOOKUP_TYPE = 'INV/CM'                              AND
        DEP.LOOKUP_CODE = 'DEP'
AND
        GUAR.LOOKUP_TYPE = 'INV/CM'                             AND
        GUAR.LOOKUP_CODE = 'GUAR'
AND
        INV.LOOKUP_TYPE = 'INV/CM'                              AND
        INV.LOOKUP_CODE = 'INV';

Line: 102

SELECT TO_CHAR(MIN(GL_DATE), 'DD-MON-YYYY')             arra_min,
       TO_CHAR(MAX(GL_DATE), 'DD-MON-YYYY')             arra_max
INTO	arra_min,
	arra_max
FROM   AR_RECEIVABLE_APPLICATIONS;

Line: 111

SELECT TO_CHAR(MIN(GL_DATE), 'DD-MON-YYYY')             adjs_min,
       TO_CHAR(MAX(GL_DATE), 'DD-MON-YYYY')             adjs_max
INTO	adjs_min,
	adjs_max
FROM   AR_ADJUSTMENTS;

Line: 120

SELECT TO_CHAR(LEAST(TO_DATE(arra_min, 'DD-MM-YYYY'), TO_DATE(adjs_min, 'DD-MM-YYYY')),'DD-MM-YYYY')                                   min_date,
       TO_CHAR(GREATEST(TO_DATE(arra_max, 'DD-MM-YYYY'),TO_DATE(adjs_max, 'DD-MM-YYYY')),'DD-MM-YYYY')                          max_date
INTO
	min_date,
	max_date
FROM   DUAL;

Line: 130

SELECT DECODE(TO_CHAR(p_start_gl_date, 'DD-MON-YYYY'),
              NULL, min_date,
              TO_CHAR(p_start_gl_date, 'DD-MON-YYYY'))                 sql_start_date,
       DECODE(TO_CHAR(p_end_gl_date, 'DD-MON-YYYY'),
              NULL, max_date,
              TO_CHAR(p_end_gl_date, 'DD-MON-YYYY'))                   sql_end_date
INTO
	sql_start_date,
	sql_end_date
FROM   DUAL;