APPS.HR_AMEUTIL_SS dependencies on PER_PAY_TRANSACTIONS

Line 737: p_sum_percentage per_pay_transactions.change_percentage%type;

733: ln_salary_percent_change number default null;
734: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
735: ln_no_of_components NUMBER ;
736: lv_param_name hr_api_transaction_values.varchar2_value%type;
737: p_sum_percentage per_pay_transactions.change_percentage%type;
738: BEGIN
739: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
740: if(hr_utility.debug_enabled) then
741: -- write debug statements

Line 779: from per_pay_transactions ppt

775: else
776: begin
777: select sum(change_percentage)
778: into p_sum_percentage
779: from per_pay_transactions ppt
780: where parent_pay_transaction_id is null
781: and pay_proposal_id is null ---8847573
782: and ppt.transaction_step_id = ln_step_id;
783: exception

Line 819: p_sum_amount per_pay_transactions.change_amount_n%type;

815: ln_salary_amt_change number default null;
816: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
817: ln_no_of_components NUMBER ;
818: lv_param_name hr_api_transaction_values.varchar2_value%type;
819: p_sum_amount per_pay_transactions.change_amount_n%type;
820: BEGIN
821: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
822: if(hr_utility.debug_enabled) then
823: -- write debug statements

Line 858: from per_pay_transactions ppt

854: else
855: begin
856: select sum(change_amount_n)
857: into p_sum_amount
858: from per_pay_transactions ppt
859: where parent_pay_transaction_id is null
860: and pay_proposal_id is null ---8847573
861: and ppt.transaction_step_id = ln_step_id;
862: exception