APPS.FII_AR_BILL_ACT_TREND_PKG SQL Statements

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

Line: 47

     /* Get the parameters that the user has selected */
  fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

Line: 87

l_sql_stmt := 'SELECT per.name VIEWBY,
                      per.name FII_AR_VIEWBY,
		      TO_CHAR(per.end_date,''DD/MM/YYYY'')    FII_AR_PERIOD_END_DATE,
		      SUM(FII_AR_BILL_ACT_AMT) FII_AR_BILL_ACT_AMT,
                      SUM(FII_AR_BILL_ACT_COUNT) FII_AR_BILL_ACT_COUNT,
                      SUM(FII_AR_BILL_ACT_AMT_PRIOR) FII_AR_BILL_ACT_AMT_PRIOR ,
                      SUM(FII_AR_BILL_ACT_COUNT_PRIOR) FII_AR_BILL_ACT_COUNT_PRIOR ,
                      DECODE(nvl(SUM(FII_AR_BILL_ACT_AMT),0),0,NULL,
		                     DECODE(SIGN(per.end_date - :ASOF_DATE),1,
                                        ''&pFunctionName=FII_AR_BILL_ACT_TRX_CLASS&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ORGANIZATION+FII_OPERATING_UNITS&pParamIds=Y'',
                                        ''AS_OF_DATE=FII_AR_PERIOD_END_DATE&pFunctionName=FII_AR_BILL_ACT_TRX_CLASS&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ORGANIZATION+FII_OPERATING_UNITS&pParamIds=Y'')) FII_AR_BILL_ACT_AMT_DRILL
               FROM ( SELECT cal.name NAME ,
	                     cal.end_date END_DATE,
	                     cal.start_date START_DATE,
	                     cal.sequence SEQUENCE, ';

Line: 147

                                       (SELECT /*+no_merge INDEX(cal FII_TIME_STRUCTURES_N1) leading(gt) cardinality(gt 1)*/ *
				        FROM fii_ar_summary_gt gt,
					     fii_time_structures cal,
					           '||l_time_dim_ltc||' per
					           WHERE
					           BITAND(cal.record_type_id, :BITAND) = :BITAND
					           and per.end_date = cal.report_date
					           and per.start_date < ';

Line: 170

                         SELECT per.name NAME,
			        per.end_date END_DATE,
				per.start_date START_DATE,
				per.sequence SEQUENCE,
                                f.inv_ba_amount+f.dm_ba_amount+f.cb_ba_amount
                                   +f.br_ba_amount+f.dep_ba_amount + f.cm_ba_amount FII_AR_BILL_ACT_AMT,
                                f.inv_ba_count+f.dm_ba_count+f.cb_ba_count
                                   +f.br_ba_count+f.dep_ba_count + f.cm_ba_count FII_AR_BILL_ACT_COUNT,
                                NULL FII_AR_BILL_ACT_AMT_PRIOR,
				NULL FII_AR_BILL_ACT_COUNT_PRIOR
                         FROM '||l_time_dim_ltc ||' per,
			      fii_ar_billing_act'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
                              ( SELECT  /*+no_merge leading(gt) cardinality(gt 1)*/ *
			        FROM fii_time_structures cal,
				     fii_ar_summary_gt gt
                                WHERE cal.report_date = :ASOF_DATE
                                  AND BITAND(cal.record_type_id, :BITAND) = :BITAND ) cal
                         WHERE f.time_id=cal.time_id
			 AND f.period_type_id=cal.period_type_id
			 AND per.end_date = :CURR_PERIOD_END '|| l_where_clause;