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: 620

          print_message('Selecting from pa_implementaions');

Line: 623

       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: 774

                   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: 807

                   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: 827

			   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: 905

                    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: 1050

           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: 1330

                 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: 1597

     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';