APPS.PA_CAPITALIZED_INTEREST SQL Statements

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

Line: 12

      SELECT organization_id_child, organization_id_parent
      FROM   per_org_structure_elements
      CONNECT BY PRIOR organization_id_child = organization_id_parent
              AND  org_structure_version_id = ver_id
      START WITH organization_id_parent = org_id
              AND  org_structure_version_id = ver_id;

Line: 23

   l_last_updated_by            NUMBER(15);

Line: 24

   l_last_update_login          NUMBER(15);

Line: 51

   l_last_updated_by            := FND_GLOBAL.USER_ID;

Line: 52

   l_last_update_login          := FND_GLOBAL.LOGIN_ID;

Line: 65

   UPDATE pa_ind_rate_sch_revisions
   SET
	last_update_date = SYSDATE,
	last_updated_by = l_last_updated_by,
	last_update_login = l_last_update_login,
	request_id = l_request_id,
	program_application_id = l_program_application_id,
	program_id = l_program_id,
	program_update_date = SYSDATE,
	compiled_flag = 'I'
   WHERE
	ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;

Line: 84

     delete pa_cint_rate_multipliers
      where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;

Line: 91

     delete pa_ind_cost_multipliers
      where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id
	and ready_to_compile_flag = 'X';

Line: 96

           pa_debug.g_err_stage := 'Deleted all the existing compiled multipliers. No. of rows deleted: '||to_char(SQL%ROWCOUNT);

Line: 121

   select ind_rate_sch_id
     into l_ind_rate_sch_id
     from pa_ind_rate_sch_revisions
    where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;

Line: 181

   UPDATE pa_ind_rate_sch_revisions
   SET
	compiled_flag    = 'Y',
	compiled_date    = SYSDATE
   WHERE
	ind_rate_sch_revision_id    = l_ind_rate_sch_rev_id;

Line: 189

        pa_debug.g_err_stage := 'Updated the compiled_flag to Y ';

Line: 208

         UPDATE pa_ind_rate_sch_revisions
   	    SET compiled_flag = 'N'
	   WHERE ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;

Line: 227

   l_last_updated_by   		NUMBER(15);

Line: 229

   l_last_update_login		NUMBER(15);

Line: 249

   l_last_updated_by 		:= FND_GLOBAL.USER_ID;

Line: 250

   l_last_update_login		:= FND_GLOBAL.LOGIN_ID;

Line: 255

   INSERT INTO pa_cint_rate_multipliers
		  (IND_RATE_SCH_REVISION_ID,
		   ORGANIZATION_ID,
		   IND_RATE_SCH_ID,
		   RATE_NAME,
		   MULTIPLIER,
		   LAST_UPDATE_DATE,
		   LAST_UPDATED_BY,
		   CREATED_BY,
		   CREATION_DATE,
		   LAST_UPDATE_LOGIN,
		   REQUEST_ID,
		   PROGRAM_APPLICATION_ID,
		   PROGRAM_ID,
		   PROGRAM_UPDATE_DATE)
    SELECT p_rate_sch_rev_id,
           p_current_org_id,
	   p_ind_rate_sch_id,
    	   cm.ind_cost_code,
	   cm.multiplier,
	   SYSDATE,
     	   l_last_updated_by,
	   l_created_by,
	   SYSDATE,
	   l_last_update_login,
	   l_request_id,
	   l_program_application_id,
	   l_program_id,
	   SYSDATE
      from pa_ind_cost_multipliers cm
     where cm.ind_rate_sch_revision_id = p_rate_sch_rev_id
       and cm.organization_id = p_current_org_id
   UNION ALL
    SELECT p_rate_sch_rev_id,
           p_current_org_id,
	   p_ind_rate_sch_id,
    	   icm.rate_name,
	   icm.multiplier,
	   SYSDATE,
     	   l_last_updated_by,
	   l_created_by,
	   SYSDATE,
	   l_last_update_login,
	   l_request_id,
	   l_program_application_id,
	   l_program_id,
	   SYSDATE
      from pa_cint_rate_multipliers  icm
     where icm.ind_rate_sch_revision_id = p_rate_sch_rev_id
       and icm.organization_id = p_org_id_parent
       and icm.rate_name not in (select cm1.ind_cost_code
                                   from pa_ind_cost_multipliers cm1
                                  where cm1.ind_rate_sch_revision_id = p_rate_sch_rev_id
                                   and cm1.organization_id = p_current_org_id);