APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_BALANCE_PKG

Line 1033: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,

1029: -- now get ASG_YTD balances for that assignment, using defined balance id
1030: -- and latest assignment actions just obtained
1031: hr_utility.set_location('mileage_balance',8);
1032:
1033: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1034: p_assignment_action_id => l_asg_act_id_ext);
1035:
1036: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1037: p_assignment_action_id => l_asg_act_id_tye);

Line 1036: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,

1032:
1033: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1034: p_assignment_action_id => l_asg_act_id_ext);
1035:
1036: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1037: p_assignment_action_id => l_asg_act_id_tye);
1038:
1039: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1040: hr_utility.trace('l_tye_balance: '||l_tye_balance);

Line 1184: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,

1180: -- now get ASG_YTD balances for that assignment, using defined balance id
1181: -- and latest assignment actions just obtained
1182: hr_utility.set_location('add_pass_balance',8);
1183:
1184: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1185: p_assignment_action_id => l_asg_act_id_ext);
1186:
1187: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1188: p_assignment_action_id => l_asg_act_id_tye);

Line 1187: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,

1183:
1184: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1185: p_assignment_action_id => l_asg_act_id_ext);
1186:
1187: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1188: p_assignment_action_id => l_asg_act_id_tye);
1189:
1190: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1191: hr_utility.trace('l_tye_balance: '||l_tye_balance);

Line 1326: l_miles_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_miles_bal_id.defined_balance_id,

1322: l_miles := 0;
1323: l_miles_temp := 0;
1324: for l_miles_bal_id in get_odd_miles_bal_id
1325: loop
1326: l_miles_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_miles_bal_id.defined_balance_id,
1327: p_assignment_action_id => l_asg_act_id_ext);
1328: l_miles := l_miles_temp + l_miles;
1329:
1330: exit when l_miles>0;

Line 2347: l_ext_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,

2343: LOOP
2344: l_ext_balance_temp := 0;
2345: l_tye_balance_temp := 0;
2346:
2347: l_ext_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,
2348: p_assignment_action_id => p_asg_act_id_ext);
2349:
2350: l_tye_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,
2351: p_assignment_action_id => p_asg_act_id_tye);

Line 2350: l_tye_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,

2346:
2347: l_ext_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,
2348: p_assignment_action_id => p_asg_act_id_ext);
2349:
2350: l_tye_balance_temp := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal(i).def_bal_id,
2351: p_assignment_action_id => p_asg_act_id_tye);
2352:
2353: l_ext_balance := l_ext_balance + l_ext_balance_temp;
2354: l_tye_balance := l_tye_balance + l_tye_balance_temp;