APPS.PA_CC_IDENT SQL Statements

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

Line: 115

                        SELECT imp.org_id,
                                nvl(imp.cc_process_io_code,'N'),
                                nvl(imp.cc_process_iu_code,'N')
                        INTO    l_current_org_id,
                                l_current_process_io_code,
                                l_current_process_iu_code
                        FROM pa_implementations_all imp
                        WHERE imp.org_id = P_ExpOrgidTab(j) ; -- bug 5365276

Line: 158

                   SELECT  p.carrying_out_organization_id,
                           decode(sl.LABOR_NON_LABOR_FLAG,
                                     'Y', p.cc_process_labor_flag,
                                          p.cc_process_nl_flag)
                     INTO  l_recvr_organization_id,
                           l_cc_prj_process_flag
                     FROM  pa_system_linkages sl,
                           pa_projects_all p
                    WHERE  p.project_id   = P_ProjectIdTab(j)
                      AND  sl.function = P_SysLinkTab(j) ;

Line: 617

     SELECT distinct  ADJUSTED_EXPENDITURE_ITEM_ID ,period_accrual_flag
       FROM PA_EXPENDITURE_ITEMS exp_item,
            pa_expenditure_groups grp ,
            pa_expenditures exp
      WHERE exp_item.EXPENDITURE_ITEM_ID  =c_exp_item_id
        and exp_item.expenditure_id =exp.expenditure_id
        and exp.expenditure_group = grp.expenditure_group
        and exp_item.transaction_source = NVL(c_transaction_source, exp_item.transaction_source); -- added bug 14173646

Line: 658

          print_message('Selecting from pa_implementaions');

Line: 661

       SELECT imp.org_id,
               nvl(imp.cc_process_io_code,'N'),
               nvl(imp.cc_process_iu_code,'N')
         INTO l_current_org_id,
              l_current_process_io_code,
              l_current_process_iu_code
         FROM pa_implementations imp ;

Line: 837

                   SELECT  t.carrying_out_organization_id,
                           decode(sl.LABOR_NON_LABOR_FLAG,
                                     'Y', t.cc_process_labor_flag,
                                          t.cc_process_nl_flag)
                     INTO  l_recvr_organization_id,
                           l_cc_prj_process_flag
                     FROM  pa_system_linkages sl,
                           pa_tasks t
                    WHERE  t.task_id   = P_TaskIdTab(j)
                      AND  sl.function = P_SysLinkTab(j) ;

Line: 870

                   SELECT  t.carrying_out_organization_id,
                           p.org_id,
                           decode(sl.LABOR_NON_LABOR_FLAG,
                                     'Y', t.cc_process_labor_flag,
                                          t.cc_process_nl_flag)
                     INTO  l_recvr_organization_id,
                           l_project_org_id,
                           l_cc_prj_process_flag
                     FROM  pa_system_linkages sl,
                           pa_projects_all p,
                           pa_tasks t
                    WHERE  p.project_id = t.project_id
                      AND  t.task_id   = P_TaskIdTab(j)
                      AND  sl.function = P_SysLinkTab(j) ;

Line: 890

			   UPDATE pa_expenditure_items_all
			   SET    cost_dist_rejection_code = 'INV_DATA'
			   WHERE  task_id = P_TaskIdTab(j)
			   AND    cost_distributed_flag = 'S'
			   AND    cost_dist_rejection_code is null;

Line: 968

                    SELECT nvl(imp.cc_process_io_code,'N'),
                           nvl(imp.cc_process_iu_code,'N')
                      INTO l_cc_process_io_code,
                           l_cc_process_iu_code
                      FROM pa_implementations_all imp
                     WHERE imp.org_id = nvl(P_ExpOrgidTab(j), l_current_org_id) ;

Line: 1119

           SELECT DECODE(co.prvdr_allow_cc_flag, 'N','N', co.cross_charge_code),
                  co.prvdr_project_id, co.vendor_site_id
             FROM pa_cc_org_relationships co
            WHERE co.prvdr_org_id = c_prvdr_org_id
              AND co.recvr_org_id = c_recvr_org_id;

Line: 1132

     SELECT distinct  ADJUSTED_EXPENDITURE_ITEM_ID ,period_accrual_flag
       FROM PA_EXPENDITURE_ITEMS exp_item,
            pa_expenditure_groups grp ,
            pa_expenditures exp
      WHERE exp_item.EXPENDITURE_ITEM_ID  =c_exp_item_id
        and exp_item.expenditure_id =exp.expenditure_id
        and exp.expenditure_group = grp.expenditure_group
        and exp_item.transaction_source = NVL(c_transaction_source, exp_item.transaction_source); -- added bug 14173646;

Line: 1444

                 SELECT t.cc_process_flag
                   INTO l_cc_tr_src_process_flag
                   FROM pa_transaction_sources t
                  WHERE t.transaction_source = P_TransSourceTab(j) ;

Line: 1714

     SELECT  org_information2
       INTO  l_legal_entity_id
       FROM  hr_organization_information
      WHERE  organization_id = p_org_id
        AND  org_information_context = 'Operating Unit Information';

Line: 1748

    SELECT h.default_legal_context_id
    INTO   l_legal_entity_id
    FROM   hr_operating_units h,
           xle_entity_profiles xep,
           pa_implementations_all i
    WHERE  i.org_id = p_org_id
    AND    i.org_id = h.organization_id
    AND    h.default_legal_context_id = xep.legal_entity_id;