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 2178: l_balance_amount := Pay_Balance_Pkg.get_value

2174: ,c_start_date => p_start_date
2175: ,c_end_date => p_end_date
2176: )
2177: LOOP
2178: l_balance_amount := Pay_Balance_Pkg.get_value
2179: (p_defined_balance_id => l_defined_balance_id,
2180: p_assignment_action_id => asgact_rec.assignment_action_id );
2181: l_bal_total_amt := l_bal_total_amt + Nvl(l_balance_amount,0);
2182: END LOOP; -- For Loop

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

3142: IF l_def_bal_id <> -1 THEN
3143: --
3144: -- Derive the late hire indicator value from the balance
3145: --
3146: l_late_hire_ind := pay_balance_pkg.get_value( p_assignment_id => p_assignment_id
3147: ,p_defined_balance_id => l_def_bal_id
3148: ,p_virtual_date => g_extract_params(p_business_group_id).extract_end_date);
3149: END IF;
3150:

Line 4460: -- Call pay_balance_pkg

4456: -- Check if Run Results exist for this element/ass act
4457: --
4458: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4459: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4460: -- Call pay_balance_pkg
4461: hr_utility.set_location('Run results exist for current period',40);
4462:
4463: IF l_rec_09(i).defined_bal_id <> -1 THEN
4464:

Line 4466: Pay_Balance_Pkg.get_value

4462:
4463: IF l_rec_09(i).defined_bal_id <> -1 THEN
4464:
4465: l_rec_09_values(k).basis_amount :=
4466: Pay_Balance_Pkg.get_value
4467: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4468: ,p_assignment_action_id => act_rec.assignment_action_id);
4469: hr_utility.set_location('Defined bal id used :'
4470: ||l_rec_09(i).defined_bal_id,50);

Line 4545: -- Call pay_balance_pkg

4541: IF l_reg_09_age < 65 THEN
4542: -- Check if Run Results exist for this element/ass act
4543: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4544: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4545: -- Call pay_balance_pkg
4546: hr_utility.set_location('run results exist for current period',40);
4547: IF l_rec_09(i).defined_bal_id <> -1 THEN
4548: l_rec_09_values(k).basis_amount :=
4549: Pay_Balance_Pkg.get_value

Line 4549: Pay_Balance_Pkg.get_value

4545: -- Call pay_balance_pkg
4546: hr_utility.set_location('run results exist for current period',40);
4547: IF l_rec_09(i).defined_bal_id <> -1 THEN
4548: l_rec_09_values(k).basis_amount :=
4549: Pay_Balance_Pkg.get_value
4550: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4551: ,p_assignment_action_id => act_rec.assignment_action_id);
4552: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
4553: l_rec_09_disp := 'Y';

Line 4617: -- Call pay_balance_pkg

4613: IF l_reg_09_age < 65 THEN
4614: -- Check if Run Results exist for this element/ass act
4615: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4616: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
4617: -- Call pay_balance_pkg
4618: hr_utility.set_location('run results exist for current period',40);
4619: IF l_rec_09(i).defined_bal_id <> -1 THEN
4620: l_rec_09_values(k).basis_amount :=
4621: Pay_Balance_Pkg.get_value

Line 4621: Pay_Balance_Pkg.get_value

4617: -- Call pay_balance_pkg
4618: hr_utility.set_location('run results exist for current period',40);
4619: IF l_rec_09(i).defined_bal_id <> -1 THEN
4620: l_rec_09_values(k).basis_amount :=
4621: Pay_Balance_Pkg.get_value
4622: (p_defined_balance_id => l_rec_09(i).defined_bal_id
4623: ,p_assignment_action_id => act_rec.assignment_action_id);
4624: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
4625: l_rec_09_disp := 'Y';

Line 4850: -- Call pay_balance_pkg

4846:
4847: -- Check if Run Results exist for this element/ass act
4848: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4849: ,p_element_type_id => l_rec_31(i).element_type_id ) THEN
4850: -- Call pay_balance_pkg
4851: IF l_rec_31(i).defined_bal_id <> -1 THEN
4852: l_rec_31_values(k).basis_amount :=
4853: Pay_Balance_Pkg.get_value
4854: (p_defined_balance_id => l_rec_31(i).defined_bal_id

Line 4853: Pay_Balance_Pkg.get_value

4849: ,p_element_type_id => l_rec_31(i).element_type_id ) THEN
4850: -- Call pay_balance_pkg
4851: IF l_rec_31(i).defined_bal_id <> -1 THEN
4852: l_rec_31_values(k).basis_amount :=
4853: Pay_Balance_Pkg.get_value
4854: (p_defined_balance_id => l_rec_31(i).defined_bal_id
4855: ,p_assignment_action_id => act_rec.assignment_action_id);
4856: l_rec_31_disp := 'Y';
4857: l_rec_31_values(k).processed := 'N';

Line 4965: -- Call pay_balance_pkg

4961:
4962: -- Check if Run Results exist for this element/ass act
4963: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
4964: ,p_element_type_id => l_basis_rec_41(i).element_type_id ) THEN
4965: -- Call pay_balance_pkg
4966: IF l_basis_rec_41(i).defined_bal_id <> -1 THEN
4967: l_rec_41_basis_values(k).basis_amount :=
4968: Pay_Balance_Pkg.get_value
4969: (p_defined_balance_id => l_basis_rec_41(i).defined_bal_id

Line 4968: Pay_Balance_Pkg.get_value

4964: ,p_element_type_id => l_basis_rec_41(i).element_type_id ) THEN
4965: -- Call pay_balance_pkg
4966: IF l_basis_rec_41(i).defined_bal_id <> -1 THEN
4967: l_rec_41_basis_values(k).basis_amount :=
4968: Pay_Balance_Pkg.get_value
4969: (p_defined_balance_id => l_basis_rec_41(i).defined_bal_id
4970: ,p_assignment_action_id => act_rec.assignment_action_id);
4971: l_basis_rec_41_disp := 'Y';
4972: l_rec_41_basis_values(k).processed := 'N';

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

5025: );
5026: FETCH csr_defined_bal1 INTO l_def_bal_id;
5027: IF csr_defined_bal1%FOUND THEN
5028: CLOSE csr_defined_bal1;
5029: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5030: ,p_assignment_action_id => rec12_act_rec.assignment_action_id
5031: );
5032: ELSE
5033: CLOSE csr_defined_bal1;

Line 5044: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5040: FETCH csr_defined_bal1 INTO l_def_bal_id;
5041: IF csr_defined_bal1%FOUND THEN
5042: CLOSE csr_defined_bal1;
5043: l_rec12_amt := l_rec12_amt +
5044: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5045: ,p_assignment_action_id => rec12_act_rec.assignment_action_id
5046: );
5047: ELSE
5048: CLOSE csr_defined_bal1;

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

5090: );
5091: FETCH csr_defined_bal1 INTO l_def_bal_id;
5092: IF csr_defined_bal1%FOUND THEN
5093: CLOSE csr_defined_bal1;
5094: l_rec41_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5095: ,p_assignment_action_id => l_asg_act_id
5096: );
5097: ELSE
5098: CLOSE csr_defined_bal1;

Line 5109: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5105: FETCH csr_defined_bal1 INTO l_def_bal_id;
5106: IF csr_defined_bal1%FOUND THEN
5107: CLOSE csr_defined_bal1;
5108: l_rec41_amt := l_rec41_amt +
5109: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5110: ,p_assignment_action_id => l_asg_act_id
5111: );
5112: ELSE
5113: CLOSE csr_defined_bal1;

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

5195: ,c_business_group_id => p_business_group_id);
5196: FETCH csr_defined_bal1 INTO l_def_bal_id;
5197: IF csr_defined_bal1%FOUND THEN
5198: CLOSE csr_defined_bal1;
5199: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5200: ,p_assignment_action_id => l_asg_act_id);
5201: ELSE
5202: CLOSE csr_defined_bal1;
5203: END IF;

Line 5213: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5209: FETCH csr_defined_bal1 INTO l_def_bal_id;
5210: IF csr_defined_bal1%FOUND THEN
5211: CLOSE csr_defined_bal1;
5212: l_rec12_amt := l_rec12_amt +
5213: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5214: ,p_assignment_action_id => l_asg_act_id);
5215: ELSE
5216: CLOSE csr_defined_bal1;
5217: END IF;

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

5288: ,c_business_group_id => p_business_group_id);
5289: FETCH csr_defined_bal1 INTO l_def_bal_id;
5290: IF csr_defined_bal1%FOUND THEN
5291: CLOSE csr_defined_bal1;
5292: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5293: ,p_assignment_action_id => l_asg_act_id);
5294: ELSE
5295: CLOSE csr_defined_bal1;
5296: END IF;

Line 5306: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5302: FETCH csr_defined_bal1 INTO l_def_bal_id;
5303: IF csr_defined_bal1%FOUND THEN
5304: CLOSE csr_defined_bal1;
5305: l_rec12_amt := l_rec12_amt +
5306: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5307: ,p_assignment_action_id => l_asg_act_id);
5308: ELSE
5309: CLOSE csr_defined_bal1;
5310: END IF;

Line 5502: -- Call pay_balance_pkg

5498: IF l_reg_09_age < 65 THEN
5499: -- Check if Run Results exist for this element/ass act
5500: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
5501: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
5502: -- Call pay_balance_pkg
5503: hr_utility.set_location('run results exist for current period',40);
5504: IF l_rec_09(i).defined_bal_id <> -1 THEN
5505: l_rec_09_values(k).basis_amount :=
5506: Pay_Balance_Pkg.get_value

Line 5506: Pay_Balance_Pkg.get_value

5502: -- Call pay_balance_pkg
5503: hr_utility.set_location('run results exist for current period',40);
5504: IF l_rec_09(i).defined_bal_id <> -1 THEN
5505: l_rec_09_values(k).basis_amount :=
5506: Pay_Balance_Pkg.get_value
5507: (p_defined_balance_id => l_rec_09(i).defined_bal_id
5508: ,p_assignment_action_id => act_rec.assignment_action_id);
5509: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
5510: l_rec_09_disp := 'Y';

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

5587: ,c_business_group_id => p_business_group_id);
5588: FETCH csr_defined_bal1 INTO l_def_bal_id;
5589: IF csr_defined_bal1%FOUND THEN
5590: CLOSE csr_defined_bal1;
5591: l_rec12_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5592: ,p_assignment_action_id => l_asg_act_id);
5593: ELSE
5594: CLOSE csr_defined_bal1;
5595: END IF;

Line 5605: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

5601: FETCH csr_defined_bal1 INTO l_def_bal_id;
5602: IF csr_defined_bal1%FOUND THEN
5603: CLOSE csr_defined_bal1;
5604: l_rec12_amt := l_rec12_amt +
5605: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
5606: ,p_assignment_action_id => l_asg_act_id);
5607: ELSE
5608: CLOSE csr_defined_bal1;
5609: END IF;

Line 7690: l_balance_amount := Pay_Balance_Pkg.get_value

7686:
7687: IF l_balance_id IS NOT NULL THEN
7688:
7689: IF p_asg_act <> - 1 THEN
7690: l_balance_amount := Pay_Balance_Pkg.get_value
7691: (p_defined_balance_id => l_balance_id
7692: ,p_assignment_action_id => p_asg_act);
7693: Hr_Utility.set_location(' l_balance_amount ' || l_balance_amount , 25);
7694: l_balance_amount := NVL(l_balance_amount,0);

Line 7712: l_balance_amount := Pay_Balance_Pkg.get_value

7708: FETCH csr_asg_act1 INTO l_asg_action_id;
7709: CLOSE csr_asg_act1;
7710:
7711: IF l_asg_action_id IS NOT NULL THEN
7712: l_balance_amount := Pay_Balance_Pkg.get_value
7713: (p_defined_balance_id => l_balance_id
7714: ,p_assignment_action_id => l_asg_action_id);
7715: Hr_Utility.set_location(' l_balance_amount ' || l_balance_amount , 25);
7716: l_balance_amount := NVL(l_balance_amount,0);

Line 8984: l_balance_amount := pay_balance_pkg.get_value

8980: CLOSE csr_asg_act1;
8981:
8982: IF l_asg_action_id IS NOT NULL THEN
8983: Hr_Utility.set_location('...Deriving balance value ',50);
8984: l_balance_amount := pay_balance_pkg.get_value
8985: (p_defined_balance_id => l_balance_id
8986: ,p_assignment_action_id => l_asg_action_id);
8987: Hr_Utility.set_location('...Value of l_balance_amount is:'
8988: ||l_balance_amount, 25);

Line 10918: -- Call pay_balance_pkg

10914: IF l_reg_09_age < 65 THEN
10915: -- Check if Run Results exist for this element/ass act
10916: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
10917: ,p_element_type_id => l_rec_09(i).element_type_id ) THEN
10918: -- Call pay_balance_pkg
10919: hr_utility.set_location('run results exist for current period',40);
10920: IF l_rec_09(i).defined_bal_id <> -1 THEN
10921: l_rec_09_values(k).basis_amount :=
10922: Pay_Balance_Pkg.get_value

Line 10922: Pay_Balance_Pkg.get_value

10918: -- Call pay_balance_pkg
10919: hr_utility.set_location('run results exist for current period',40);
10920: IF l_rec_09(i).defined_bal_id <> -1 THEN
10921: l_rec_09_values(k).basis_amount :=
10922: Pay_Balance_Pkg.get_value
10923: (p_defined_balance_id => l_rec_09(i).defined_bal_id
10924: ,p_assignment_action_id => act_rec.assignment_action_id);
10925: hr_utility.set_location('defined bal id used :'||l_rec_09(i).defined_bal_id,50);
10926: l_rec_09_disp := 'Y';

Line 13771: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

13767: CLOSE c_run_results_exist;
13768: Hr_Utility.set_location('found asg action id : '||l_asg_act_id,30);
13769: --from the assignment action id,and defined balance id fetched above , find the balance value
13770: p_data_element_value := Fnd_Number.number_to_canonical(
13771: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
13772: ,p_assignment_action_id => l_asg_act_id
13773: ));
13774: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
13775: g_fur_contribution := Fnd_Number.canonical_to_number(p_data_element_value);

Line 13859: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

13855: CLOSE csr_defined_bal;
13856: Hr_Utility.set_location('found defined balance id : '||l_defined_balance_id,20);
13857: --from the assignment action id,and defined balance id fetched above , find the balance value
13858: p_data_element_value := Fnd_Number.number_to_canonical(
13859: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
13860: ,p_assignment_action_id => l_asg_act_id
13861: ));
13862: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
13863: IF p_sub_cat = 'FUR_S' THEN

Line 14153: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id

14149: CLOSE c_run_results_exist;
14150: Hr_Utility.set_location('found asg action id : '||l_asg_act_id,30);
14151: --from the assignment action id,and defined balance id fetched above , find the balance value
14152: p_data_element_value := Fnd_Number.number_to_canonical(
14153: Pay_Balance_Pkg.get_value(p_defined_balance_id => l_defined_balance_id
14154: ,p_assignment_action_id => l_asg_act_id
14155: ));
14156: Hr_Utility.set_location('found value for the contribution as : '||p_data_element_value,40);
14157: g_ipap_contribution := Fnd_Number.canonical_to_number(p_data_element_value);