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 ppt.transaction_step_id = ln_step_id;
782: exception
783: when no_data_found then

Line 818: p_sum_amount per_pay_transactions.change_amount_n%type;

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

Line 857: from per_pay_transactions ppt

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