APPS.HR_PAY_RATE_GSP_SS SQL Statements

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

Line: 213

    SELECT transaction_step_id
    FROM   hr_api_transaction_steps
    WHERE  item_type = c_item_type
    AND    item_key  = c_item_key
    --AND    api_name = 'HR_PAY_RATE_SS.process_api_java';

Line: 580

select pay_transaction_id from per_pay_transactions where
item_type=p_item_type and item_key=p_item_key and status='NEW';

Line: 584

select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and
P_Effective_Date between change_date and date_to;

Line: 609

    update per_pay_transactions set
     PAY_BASIS_ID       = l_pay_basis_id,
     change_amount_n    = p_ltt_salary_data(1).salary_change_amount,
     change_percentage  = p_ltt_salary_data(1).salary_change_percent,
     PROPOSED_SALARY_N  = p_ltt_salary_data(1).proposed_salary
    where PAY_TRANSACTION_ID = pay_txn_id;

Line: 626

           insert into per_pay_transactions(
               	            PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
	            TRANSACTION_ID, -- TRANSACTION_ID,
	            TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
	            ITEM_TYPE,--  ITEM_TYPE,
	            ITEM_KEY,--  ITEM_KEY,
	            pay_proposal_id,
	            ASSIGNMENT_ID,-- ASSIGNMENT_ID,
	            PAY_BASIS_ID,-- PAY_BASIS_ID,
	            business_group_id,
	            CHANGE_DATE,
	            DATE_TO,
	            last_change_date,
                	            reason,
	            multiple_components,
    	            change_amount_n,
	            change_percentage,
	            PROPOSED_SALARY_N,
	            parent_pay_transaction_id,
	            prior_pay_proposal_id,
	            PRIOR_PAY_TRANSACTION_ID,
	            PRIOR_PROPOSED_SALARY_N,
	            PRIOR_PAY_BASIS_ID,
	            approved,
	            STATUS,-- STATUS,
	            DML_OPERATION,-- DML_OPERATION,
           	            object_version_number)
         values(
	            PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
	            p_transaction_id, -- TRANSACTION_ID,
	            p_transaction_step_id,-- TRANSACTION_STEP_ID,
	            p_item_type,--  ITEM_TYPE,
	            p_item_key,--  ITEM_KEY,
	            pay_prop_id,
	            p_assignment_id,
	            l_old_pay_basis_id,
	            p_business_group_id,
             	            p_ltt_salary_data(1).default_last_change_date,
	            p_ltt_salary_data(1).salary_effective_date - 1,
	            null,
	            'GSP',
	            'N',  -- change_amount_n,
	            null,
	            null,
	            p_ltt_salary_data(1).current_salary,
	            null,
	            null,
	            null,
	            null,
	            null,
	            'Y',
	            'DATE_ADJUSTED',-- STATUS,
	            'UPDATE',-- DML_OPERATION,
	            1);

Line: 683

           insert into per_pay_transactions(
               	            PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
	            TRANSACTION_ID, -- TRANSACTION_ID,
	            TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
	            ITEM_TYPE,--  ITEM_TYPE,
	            ITEM_KEY,--  ITEM_KEY,
	            pay_proposal_id,
	            ASSIGNMENT_ID,-- ASSIGNMENT_ID,
	            PAY_BASIS_ID,-- PAY_BASIS_ID,
	            business_group_id,
	            CHANGE_DATE,
	            DATE_TO,
	            last_change_date,
                	            reason,
	            multiple_components,
	            change_amount_n,
	            change_percentage,
	            PROPOSED_SALARY_N,
	            parent_pay_transaction_id,
	            prior_pay_proposal_id,
	            PRIOR_PAY_TRANSACTION_ID,
	            PRIOR_PROPOSED_SALARY_N,
	            PRIOR_PAY_BASIS_ID,
	            approved,
	            STATUS,-- STATUS,
	            DML_OPERATION,-- DML_OPERATION,
          	            object_version_number)
         values(
	            PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
	            p_transaction_id, -- TRANSACTION_ID,
	            p_transaction_step_id,-- TRANSACTION_STEP_ID,
	            p_item_type,--  ITEM_TYPE,
	            p_item_key,--  ITEM_KEY,
	            null,
	            p_assignment_id,
	            l_pay_basis_id,
	            p_business_group_id,
          	            p_ltt_salary_data(1).salary_effective_date,
	            null,
	            null,
	            'GSP',
	            'N',  -- change_amount_n,
	            p_ltt_salary_data(1).salary_change_amount,
	            p_ltt_salary_data(1).salary_change_percent,
	            p_ltt_salary_data(1).proposed_salary,
	            null,
	            pay_prop_id,
	            null,
	            p_ltt_salary_data(1).current_salary,
	            l_old_pay_basis_id,
	            'Y',
	            'NEW',-- STATUS,
	            'INSERT',-- DML_OPERATION,
	            1);

Line: 787

         select    name
         from      ben_pgm_f
         where     pgm_id      = p_grade_ladder_id;