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_NL_PENSION_EXTRACTS dependencies on PAY_BALANCE_PKG

Line 2157: l_balance_amount := Pay_Balance_Pkg.get_value

2153: ,c_start_date => p_start_date
2154: ,c_end_date => p_end_date
2155: )
2156: LOOP
2157: l_balance_amount := Pay_Balance_Pkg.get_value
2158: (p_defined_balance_id => l_defined_balance_id,
2159: p_assignment_action_id => asgact_rec.assignment_action_id );
2160: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
2161: END LOOP; -- For Loop

Line 3125: l_late_hire_ind := pay_balance_pkg.get_value( p_assignment_id => p_assignment_id

3121: IF l_def_bal_id <> -1 THEN
3122: --
3123: -- Derive the late hire indicator value from the balance
3124: --
3125: l_late_hire_ind := pay_balance_pkg.get_value( p_assignment_id => p_assignment_id
3126: ,p_defined_balance_id => l_def_bal_id
3127: ,p_virtual_date => g_extract_params(p_business_group_id).extract_end_date);
3128: END IF;
3129:

Line 4272: -- Call pay_balance_pkg

4268: -- Check if Run Results exist for this element/ass act
4269: --
4270: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4271: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4272: -- Call pay_balance_pkg
4273: hr_utility.set_location('Run results exist for current period',40);
4274:
4275: IF l_rec_09(i).defined_bal_id <> -1 THEN
4276:

Line 4278: Pay_Balance_Pkg.get_value

4274:
4275: IF l_rec_09(i).defined_bal_id <> -1 THEN
4276:
4277: l_rec_09_values(k).basis_amount :=
4278: Pay_Balance_Pkg.get_value
4279: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4280: ,p_assignment_action_id => act_rec.assignment_action_id);
4281: hr_utility.set_location('Defined bal id used :'
4282: ||l_rec_09(i).defined_bal_id,50);

Line 4357: -- Call pay_balance_pkg

4353: IF l_reg_09_age < 65 THEN
4354: -- Check if Run Results exist for this element/ass act
4355: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4356: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4357: -- Call pay_balance_pkg
4358: hr_utility.set_location('run results exist for current period',40);
4359: IF l_rec_09(i).defined_bal_id <> -1 THEN
4360: l_rec_09_values(k).basis_amount :=
4361: Pay_Balance_Pkg.get_value

Line 4361: Pay_Balance_Pkg.get_value

4357: -- Call pay_balance_pkg
4358: hr_utility.set_location('run results exist for current period',40);
4359: IF l_rec_09(i).defined_bal_id <> -1 THEN
4360: l_rec_09_values(k).basis_amount :=
4361: Pay_Balance_Pkg.get_value
4362: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4363: ,p_assignment_action_id => act_rec.assignment_action_id);
4364: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
4365: l_rec_09_disp := 'Y';

Line 4429: -- Call pay_balance_pkg

4425: IF l_reg_09_age < 65 THEN
4426: -- Check if Run Results exist for this element/ass act
4427: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4428: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4429: -- Call pay_balance_pkg
4430: hr_utility.set_location('run results exist for current period',40);
4431: IF l_rec_09(i).defined_bal_id <> -1 THEN
4432: l_rec_09_values(k).basis_amount :=
4433: Pay_Balance_Pkg.get_value

Line 4433: Pay_Balance_Pkg.get_value

4429: -- Call pay_balance_pkg
4430: hr_utility.set_location('run results exist for current period',40);
4431: IF l_rec_09(i).defined_bal_id <> -1 THEN
4432: l_rec_09_values(k).basis_amount :=
4433: Pay_Balance_Pkg.get_value
4434: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4435: ,p_assignment_action_id => act_rec.assignment_action_id);
4436: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
4437: l_rec_09_disp := 'Y';

Line 4662: -- Call pay_balance_pkg

4658:
4659: -- Check if Run Results exist for this element/ass act
4660: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4661: ,p_element_type_id => l_rec_31(i).element_type_id ) THEN
4662: -- Call pay_balance_pkg
4663: IF l_rec_31(i).defined_bal_id <> -1 THEN
4664: l_rec_31_values(k).basis_amount :=
4665: Pay_Balance_Pkg.get_value
4666: (p_defined_balance_id => l_rec_31(i).defined_bal_id

Line 4665: Pay_Balance_Pkg.get_value

4661: ,p_element_type_id => l_rec_31(i).element_type_id ) THEN
4662: -- Call pay_balance_pkg
4663: IF l_rec_31(i).defined_bal_id <> -1 THEN
4664: l_rec_31_values(k).basis_amount :=
4665: Pay_Balance_Pkg.get_value
4666: (p_defined_balance_id => l_rec_31(i).defined_bal_id
4667: ,p_assignment_action_id => act_rec.assignment_action_id);
4668: l_rec_31_disp := 'Y';
4669: l_rec_31_values(k).processed := 'N';

Line 4777: -- Call pay_balance_pkg

4773:
4774: -- Check if Run Results exist for this element/ass act
4775: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4776: ,p_element_type_id => l_basis_rec_41(i).element_type_id ) THEN
4777: -- Call pay_balance_pkg
4778: IF l_basis_rec_41(i).defined_bal_id <> -1 THEN
4779: l_rec_41_basis_values(k).basis_amount :=
4780: Pay_Balance_Pkg.get_value
4781: (p_defined_balance_id => l_basis_rec_41(i).defined_bal_id

Line 4780: Pay_Balance_Pkg.get_value

4776: ,p_element_type_id => l_basis_rec_41(i).element_type_id ) THEN
4777: -- Call pay_balance_pkg
4778: IF l_basis_rec_41(i).defined_bal_id <> -1 THEN
4779: l_rec_41_basis_values(k).basis_amount :=
4780: Pay_Balance_Pkg.get_value
4781: (p_defined_balance_id => l_basis_rec_41(i).defined_bal_id
4782: ,p_assignment_action_id => act_rec.assignment_action_id);
4783: l_basis_rec_41_disp := 'Y';
4784: l_rec_41_basis_values(k).processed := 'N';

Line 4840: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

4836: );
4837: FETCH csr_defined_bal1 INTO l_def_bal_id;
4838: IF csr_defined_bal1%FOUND THEN
4839: CLOSE csr_defined_bal1;
4840: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
4841: ,p_assignment_action_id => rec12_act_rec.assignment_action_id
4842: );
4843: ELSE
4844: CLOSE csr_defined_bal1;

Line 4855: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

4851: FETCH csr_defined_bal1 INTO l_def_bal_id;
4852: IF csr_defined_bal1%FOUND THEN
4853: CLOSE csr_defined_bal1;
4854: l_rec12_amt := l_rec12_amt +
4855: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
4856: ,p_assignment_action_id => rec12_act_rec.assignment_action_id
4857: );
4858: ELSE
4859: CLOSE csr_defined_bal1;

Line 4905: l_rec41_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

4901: );
4902: FETCH csr_defined_bal1 INTO l_def_bal_id;
4903: IF csr_defined_bal1%FOUND THEN
4904: CLOSE csr_defined_bal1;
4905: l_rec41_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
4906: ,p_assignment_action_id => l_asg_act_id
4907: );
4908: ELSE
4909: CLOSE csr_defined_bal1;

Line 4920: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

4916: FETCH csr_defined_bal1 INTO l_def_bal_id;
4917: IF csr_defined_bal1%FOUND THEN
4918: CLOSE csr_defined_bal1;
4919: l_rec41_amt := l_rec41_amt +
4920: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
4921: ,p_assignment_action_id => l_asg_act_id
4922: );
4923: ELSE
4924: CLOSE csr_defined_bal1;

Line 5010: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5006: ,c_business_group_id => p_business_group_id);
5007: FETCH csr_defined_bal1 INTO l_def_bal_id;
5008: IF csr_defined_bal1%FOUND THEN
5009: CLOSE csr_defined_bal1;
5010: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5011: ,p_assignment_action_id => l_asg_act_id);
5012: ELSE
5013: CLOSE csr_defined_bal1;
5014: END IF;

Line 5024: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5020: FETCH csr_defined_bal1 INTO l_def_bal_id;
5021: IF csr_defined_bal1%FOUND THEN
5022: CLOSE csr_defined_bal1;
5023: l_rec12_amt := l_rec12_amt +
5024: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5025: ,p_assignment_action_id => l_asg_act_id);
5026: ELSE
5027: CLOSE csr_defined_bal1;
5028: END IF;

Line 5103: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5099: ,c_business_group_id => p_business_group_id);
5100: FETCH csr_defined_bal1 INTO l_def_bal_id;
5101: IF csr_defined_bal1%FOUND THEN
5102: CLOSE csr_defined_bal1;
5103: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5104: ,p_assignment_action_id => l_asg_act_id);
5105: ELSE
5106: CLOSE csr_defined_bal1;
5107: END IF;

Line 5117: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5113: FETCH csr_defined_bal1 INTO l_def_bal_id;
5114: IF csr_defined_bal1%FOUND THEN
5115: CLOSE csr_defined_bal1;
5116: l_rec12_amt := l_rec12_amt +
5117: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5118: ,p_assignment_action_id => l_asg_act_id);
5119: ELSE
5120: CLOSE csr_defined_bal1;
5121: END IF;

Line 5313: -- Call pay_balance_pkg

5309: IF l_reg_09_age < 65 THEN
5310: -- Check if Run Results exist for this element/ass act
5311: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
5312: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
5313: -- Call pay_balance_pkg
5314: hr_utility.set_location('run results exist for current period',40);
5315: IF l_rec_09(i).defined_bal_id <> -1 THEN
5316: l_rec_09_values(k).basis_amount :=
5317: Pay_Balance_Pkg.get_value

Line 5317: Pay_Balance_Pkg.get_value

5313: -- Call pay_balance_pkg
5314: hr_utility.set_location('run results exist for current period',40);
5315: IF l_rec_09(i).defined_bal_id <> -1 THEN
5316: l_rec_09_values(k).basis_amount :=
5317: Pay_Balance_Pkg.get_value
5318: (p_defined_balance_id => l_rec_09(i).defined_bal_id
5319: ,p_assignment_action_id => act_rec.assignment_action_id);
5320: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
5321: l_rec_09_disp := 'Y';

Line 5402: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5398: ,c_business_group_id => p_business_group_id);
5399: FETCH csr_defined_bal1 INTO l_def_bal_id;
5400: IF csr_defined_bal1%FOUND THEN
5401: CLOSE csr_defined_bal1;
5402: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5403: ,p_assignment_action_id => l_asg_act_id);
5404: ELSE
5405: CLOSE csr_defined_bal1;
5406: END IF;

Line 5416: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5412: FETCH csr_defined_bal1 INTO l_def_bal_id;
5413: IF csr_defined_bal1%FOUND THEN
5414: CLOSE csr_defined_bal1;
5415: l_rec12_amt := l_rec12_amt +
5416: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5417: ,p_assignment_action_id => l_asg_act_id);
5418: ELSE
5419: CLOSE csr_defined_bal1;
5420: END IF;

Line 7351: l_balance_amount := Pay_Balance_Pkg.get_value

7347:
7348: IF l_balance_id IS NOT NULL THEN
7349:
7350: IF p_asg_act <> - 1 THEN
7351: l_balance_amount := Pay_Balance_Pkg.get_value
7352: (p_defined_balance_id => l_balance_id
7353: ,p_assignment_action_id => p_asg_act);
7354: Hr_Utility.set_location(' l_balance_amount ' || l_balance_amount , 25);
7355: l_balance_amount := NVL(l_balance_amount,0);

Line 7373: l_balance_amount := Pay_Balance_Pkg.get_value

7369: FETCH csr_asg_act1 INTO l_asg_action_id;
7370: CLOSE csr_asg_act1;
7371:
7372: IF l_asg_action_id IS NOT NULL THEN
7373: l_balance_amount := Pay_Balance_Pkg.get_value
7374: (p_defined_balance_id => l_balance_id
7375: ,p_assignment_action_id => l_asg_action_id);
7376: Hr_Utility.set_location(' l_balance_amount ' || l_balance_amount , 25);
7377: l_balance_amount := NVL(l_balance_amount,0);

Line 8645: l_balance_amount := pay_balance_pkg.get_value

8641: CLOSE csr_asg_act1;
8642:
8643: IF l_asg_action_id IS NOT NULL THEN
8644: Hr_Utility.set_location('...Deriving balance value ',50);
8645: l_balance_amount := pay_balance_pkg.get_value
8646: (p_defined_balance_id => l_balance_id
8647: ,p_assignment_action_id => l_asg_action_id);
8648: Hr_Utility.set_location('...Value of l_balance_amount is:'
8649: ||l_balance_amount, 25);

Line 10579: -- Call pay_balance_pkg

10575: IF l_reg_09_age < 65 THEN
10576: -- Check if Run Results exist for this element/ass act
10577: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
10578: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
10579: -- Call pay_balance_pkg
10580: hr_utility.set_location('run results exist for current period',40);
10581: IF l_rec_09(i).defined_bal_id <> -1 THEN
10582: l_rec_09_values(k).basis_amount :=
10583: Pay_Balance_Pkg.get_value

Line 10583: Pay_Balance_Pkg.get_value

10579: -- Call pay_balance_pkg
10580: hr_utility.set_location('run results exist for current period',40);
10581: IF l_rec_09(i).defined_bal_id <> -1 THEN
10582: l_rec_09_values(k).basis_amount :=
10583: Pay_Balance_Pkg.get_value
10584: (p_defined_balance_id => l_rec_09(i).defined_bal_id
10585: ,p_assignment_action_id => act_rec.assignment_action_id);
10586: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
10587: l_rec_09_disp := 'Y';

Line 13402: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

13398: CLOSE c_run_results_exist;
13399: Hr_Utility.set_location('found asg action id : '||l_asg_act_id,30);
13400: --from the assignment action id,and defined balance id fetched above , find the balance value
13401: p_data_element_value := Fnd_Number.number_to_canonical(
13402: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
13403: ,p_assignment_action_id => l_asg_act_id
13404: ));
13405: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
13406: g_fur_contribution := Fnd_Number.canonical_to_number(p_data_element_value);

Line 13490: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

13486: CLOSE csr_defined_bal;
13487: Hr_Utility.set_location('found defined balance id : '||l_defined_balance_id,20);
13488: --from the assignment action id,and defined balance id fetched above , find the balance value
13489: p_data_element_value := Fnd_Number.number_to_canonical(
13490: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
13491: ,p_assignment_action_id => l_asg_act_id
13492: ));
13493: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
13494: IF p_sub_cat = 'FUR_S' THEN

Line 13784: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

13780: CLOSE c_run_results_exist;
13781: Hr_Utility.set_location('found asg action id : '||l_asg_act_id,30);
13782: --from the assignment action id,and defined balance id fetched above , find the balance value
13783: p_data_element_value := Fnd_Number.number_to_canonical(
13784: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
13785: ,p_assignment_action_id => l_asg_act_id
13786: ));
13787: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
13788: g_ipap_contribution := Fnd_Number.canonical_to_number(p_data_element_value);