APPS.PA_PAXPRCON_XMLP_PKG SQL Statements

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

Line: 28

   Select Decode ( pa_install.is_billing_licensed (), 'Y','N','Y')
   Into   p_costing
   From   Dual;

Line: 39

SELECT name, segment1, project_type INTO p_name, p_number, p_ptype
FROM   pa_projects
WHERE  project_id = p_project_id;

Line: 44

SELECT billing_cycle_id INTO p_bill_id FROM pa_project_types
WHERE  project_type = p_ptype ;

Line: 47

   SELECT billing_cycle_name INTO p_bill_name
   FROM   pa_billing_cycles
   WHERE  billing_cycle_id = p_bill_id ;

Line: 65

  SELECT  name
 INTO    l_name
 FROM    gl_sets_of_books
 WHERE   set_of_books_id = (SELECT set_of_books_id
			    FROM   pa_implementations_all
			    WHERE org_id = (SELECT org_id
			                    FROM pa_projects_all
					    WHERE project_id = p_project_id ));

Line: 82

 select
  meaning
 into
  message_name
 from
  pa_lookups
 where
    lookup_type = 'MESSAGE'
and lookup_code = 'NO_DATA_FOUND';

Line: 180

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = baseline_funding_flag ;

Line: 195

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = revaluate_funding_flag ;

Line: 210

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = include_gains_losses_flag ;

Line: 224

select meaning
  into l_reason
  from pa_lookups
 where lookup_type ='RATE AND DISCOUNT REASON'
   and lookup_code= emp_disc_reason;

Line: 238

select meaning
  into l_reason
  from pa_lookups
 where lookup_type ='RATE AND DISCOUNT REASON'
   and lookup_code= nl_disc_reason;

Line: 252

select meaning
  into l_reason
  from pa_lookups
 where lookup_type ='RATE AND DISCOUNT REASON'
   and lookup_code= job_disc_reason;

Line: 266

select decode(mrc_sob_type_code,'R','R','P')
into p_mrcsobtype
from gl_sets_of_books
where set_of_books_id = (SELECT set_of_books_id
			    FROM   pa_implementations_all
			    WHERE org_id = (SELECT org_id
			                    FROM pa_projects_all
					    WHERE project_id = p_project_id )
);

Line: 291

      select substr(party.party_name,1,50) into tmp_flag
      from
           hz_parties party,
           hz_cust_accounts cust_acct
      where
           party.party_id = cust_acct.party_id
       and cust_acct.cust_account_id = bill_to_customer_id;

Line: 310

      	SELECT substrb(party.party_name,1,50) INTO tmp_flag
	FROM
	      hz_parties party,
	      hz_cust_accounts cust_acct
	WHERE
	      party.party_id = cust_acct.party_id
	  and cust_acct.cust_account_id = ship_to_customer_id;

Line: 328

      	SELECT cust_acct.account_number INTO l_cust_no
	FROM
	      hz_parties party,
	      hz_cust_accounts cust_acct
	WHERE
	      party.party_id = cust_acct.party_id
	  and cust_acct.cust_account_id = bill_to_customer_id;

Line: 346

      SELECT cust_acct.account_number INTO l_cust_no
      FROM
            hz_parties party,
            hz_cust_accounts cust_acct
      WHERE
            party.party_id = cust_acct.party_id
        and cust_acct.cust_account_id = ship_to_customer_id;

Line: 365

	SELECT meaning INTO tmp_flag
        FROM pa_lookups lkp, pa_projects prj
        WHERE lkp.lookup_type = 'YES_NO'
        AND   lkp.lookup_code = prj.enable_top_task_customer_flag
       -- AND   prj.project_id = project_id;

Line: 383

	SELECT meaning INTO tmp_flag
        FROM pa_lookups lkp, pa_projects prj
        WHERE lkp.lookup_type = 'YES_NO'
        AND   lkp.lookup_code = prj.enable_top_task_inv_mth_flag
       -- AND   prj.project_id = project_id;

Line: 401

	SELECT meaning INTO tmp_flag
        FROM pa_lookups lkp, pa_projects prj
        WHERE lkp.lookup_type = 'REVENUE ACCRUAL METHOD'
        AND   lkp.lookup_code = prj.revenue_accrual_method
       -- AND   prj.project_id = project_id;

Line: 419

	SELECT meaning INTO tmp_flag
        FROM pa_lookups lkp, pa_projects prj
        WHERE lkp.lookup_type = 'INVOICE METHOD'
        AND   lkp.lookup_code = prj.invoice_method
       -- AND   prj.project_id = project_id;