APPS.PAY_PAYKRSOE_XMLP_PKG SQL Statements

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

Line: 49

  select org_information9
  from   hr_organization_information
  where  organization_id  = c_business_group_id
  and    org_information9 is not null
  and    org_information_context = 'Business Group Information';

Line: 70

  select currency_code
  from   fnd_currencies
  where  issuing_territory_code = c_territory_code;

Line: 162

					Select	Amount
					From		Pay_Kr_Asg_Elements_V
					Where		Classification_Name = 'EARNINGS'
					And			Assignment_Action_Id = Assignment_Action_Id
					Order by	Processing_Priority desc;

Line: 187

					Select	Hours
					From		Pay_Kr_Asg_Elements_V
					Where		Classification_Name  = 'EARNINGS'
					And			Assignment_Action_Id = Assignment_Action_Id
					Order by	Processing_Priority desc;

Line: 212

					Select	Amount
					From		Pay_Kr_Asg_Elements_V
					Where		Classification_Name  = 'DEDUCTIONS'
					And			Assignment_Action_Id = Assignment_Action_Id
					Order by	Processing_Priority desc;

Line: 253

						Select  Payroll_Name
						From		Pay_Payrolls_F
						Where		Payroll_Id = P_PAYROLL_ID;

Line: 258

						Select	Assignment_Number
						From		Per_Assignments_F
						Where		Assignment_Id = P_ASSIGNMENT_ID;

Line: 274

		Select	distinct Run_Type_Name||'-'||Period_Name||'-'||ppa.Payroll_Action_Id
		Into		lv_RunType_Period
 		From		Pay_Payroll_Actions	ppa
 						,Pay_Assignment_Actions paa
 						,Pay_Run_Types_F prt
 						,Per_Time_Periods ptp
 						,Pay_Payroll_Actions rppa
 						,Pay_Assignment_Actions rpaa
 						,Pay_Action_Interlocks pai
    Where		ppa.Payroll_Action_Id = P_TIME_PERIOD_ID     And			rppa.Payroll_Id				= P_PAYROLL_ID
    And			ppa.Payroll_Action_Id = paa.Payroll_Action_Id
    And			ppa.action_type IN ('U','P')
    And			ppa.action_status = 'C'
    And			rppa.Payroll_Action_Id = rpaa.Payroll_Action_Id
    And			rppa.action_type IN ('R','Q')
    And			rppa.action_status = 'C'
    And			pai.Locking_Action_Id = paa.Assignment_Action_Id
    And			pai.Locked_Action_Id  = rpaa.Assignment_Action_Id
    And			rpaa.Run_Type_Id = prt.Run_Type_Id
    And			pai.Locked_Action_Id = ( Select max(Locked_Action_Id) Locked_Action_Id
 							 From		Pay_Action_Interlocks ai
							where    ai.Locking_Action_Id = pai.Locking_Action_Id )
    And			rppa.Payroll_Id = ptp.Payroll_Id
    And			rppa.Effective_Date		Between	ptp.Start_Date
    															And			ptp.End_Date
    And			rppa.Effective_Date		Between prt.Effective_Start_Date
    															And			prt.Effective_End_Date	;

Line: 311

		Select	Org_Information1
		Into		lv_Bus_Place
		From		hr_organization_information
		Where		org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
		And			Organization_Id = P_ESTABLISHMENT_ID;

Line: 335

		Select count(*)
		Into   lvnum
		From ( Select distinct paa.Run_Type_Id
					 From 	Pay_Assignment_Actions paa
					 				,Pay_Action_Interlocks pai
					 				,Pay_Payroll_Actions   pa
					 				,Pay_Assignment_Actions aa
					 Where	pa.Payroll_Action_Id = aa.Payroll_Action_Id
					 And		pa.Action_Type IN ('P','U')
					 And		pai.Locked_Action_Id = paa.Assignment_Action_Id
					 And		pai.Locking_Action_Id = aa.Assignment_Action_Id
					 And		paa.Run_Type_Id IS NOT NULL
					 And		pa.Payroll_Action_Id =  P_TIME_PERIOD_ID );

Line: 384

  	Select	Effective_Date
  	Into		lv_Effective_Date
  	From		Pay_Payroll_Actions
  	Where		Payroll_Action_Id = P_TIME_PERIOD_ID;

Line: 400

  Select	decode(Pay_Advice_Message,null,0,1)
  Into		lvFlagNum
  From    Pay_Payroll_Actions
  Where   Payroll_Action_Id = Payroll_Action_Id_Payroll;