eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_BALANCE_PKG

Line 4196: l_balance_amount := Pay_Balance_Pkg.get_value

4192: IF csr_asg_balid%NOTFOUND THEN
4193: Hr_Utility.set_location('..Def. Balance Id not found', 5);
4194: END IF;
4195: CLOSE csr_asg_balid;
4196: l_balance_amount := Pay_Balance_Pkg.get_value
4197: (p_defined_balance_id => l_defined_balance_id,
4198: p_assignment_action_id => g_asg_action_id );
4199: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
4200: END IF;

Line 4239: l_balance_amount := Pay_Balance_Pkg.get_value

4235: ,c_business_group_id => p_business_group_id);
4236: FETCH csr_asg_balid INTO l_defined_balance_id;
4237:
4238: IF csr_asg_balid%FOUND THEN
4239: l_balance_amount := Pay_Balance_Pkg.get_value
4240: (p_defined_balance_id => l_defined_balance_id,
4241: p_assignment_action_id => act_rec.assignment_action_id );
4242: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
4243: END IF;-- If csr_asg_balid%FOUND

Line 4560: l_balance_amount := Pay_Balance_Pkg.get_value

4556: --If Reporting dimension is ASG_RUN
4557: IF g_extract_params(i).reporting_dimension = 'ASG_RUN' THEN
4558: --Get the balance amount
4559: IF l_defined_balance_id IS NOT NULL AND g_asg_action_id IS NOT NULL THEN
4560: l_balance_amount := Pay_Balance_Pkg.get_value
4561: (p_defined_balance_id => l_defined_balance_id,
4562: p_assignment_action_id => g_asg_action_id );
4563: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
4564: Hr_Utility.set_location('l_bal_total_amt:'||l_bal_total_amt, 5);

Line 4585: l_balance_amount := Pay_Balance_Pkg.get_value

4581: ,c_end_date => g_extract_params(i).extract_end_date
4582: );
4583: FETCH csr_max_act INTO l_assignment_action_id;
4584: CLOSE csr_max_act;
4585: l_balance_amount := Pay_Balance_Pkg.get_value
4586: (p_defined_balance_id => l_defined_balance_id,
4587: p_assignment_action_id => l_assignment_action_id );
4588:
4589: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);

Line 4607: l_beg_amt := Pay_Balance_Pkg.get_value

4603: ,c_end_date => g_extract_params(i).extract_start_date
4604: );
4605: FETCH csr_max_act INTO l_assignment_action_id;
4606: CLOSE csr_max_act;
4607: l_beg_amt := Pay_Balance_Pkg.get_value
4608: (p_defined_balance_id => l_defined_balance_id,
4609: p_assignment_action_id => l_assignment_action_id );
4610: -- Get YTD amount as of the end date of the extract based on the
4611: -- criteria entered

Line 4622: l_end_amt := Pay_Balance_Pkg.get_value

4618: ,c_end_date => l_yr_end_date
4619: );
4620: FETCH csr_max_act INTO l_assignment_action_id;
4621: CLOSE csr_max_act;
4622: l_end_amt := Pay_Balance_Pkg.get_value
4623: (p_defined_balance_id => l_defined_balance_id,
4624: p_assignment_action_id => l_assignment_action_id );
4625: -- Take the difference of the amount.
4626: l_tot_prv_yr_amt := l_end_amt - l_beg_amt;

Line 4643: l_bal_amt := Pay_Balance_Pkg.get_value

4639: ,c_end_date => g_extract_params(i).extract_end_date
4640: );
4641: FETCH csr_max_act INTO l_assignment_action_id;
4642: CLOSE csr_max_act;
4643: l_bal_amt := Pay_Balance_Pkg.get_value
4644: (p_defined_balance_id => l_defined_balance_id,
4645: p_assignment_action_id => l_assignment_action_id );
4646: l_bal_total_amt := l_bal_amt + l_tot_prv_yr_amt;
4647: END IF;

Line 4718: l_balance_amount := Pay_Balance_Pkg.get_value

4714: --If Reporting dimension is ASG_RUN
4715: IF g_extract_params(i).reporting_dimension = 'ASG_RUN' THEN
4716: --Get the balance amount
4717: IF l_defined_balance_id IS NOT NULL THEN
4718: l_balance_amount := Pay_Balance_Pkg.get_value
4719: (p_defined_balance_id => l_defined_balance_id,
4720: p_assignment_action_id => g_asg_action_id );
4721: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
4722: END IF;

Line 4735: l_balance_amount := Pay_Balance_Pkg.get_value

4731: ,c_start_date => g_extract_params(i).extract_start_date
4732: ,c_end_date => g_extract_params(i).extract_end_date
4733: )
4734: LOOP
4735: l_balance_amount := Pay_Balance_Pkg.get_value
4736: (p_defined_balance_id => l_defined_balance_id,
4737: p_assignment_action_id => asgact_rec.assignment_action_id );
4738: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
4739: END LOOP; -- For Loop