APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_BALANCE_PKG

Line 1257: p_col_bal_def_table(i).balance_value := pay_balance_pkg.get_value

1253: l_source_text2 := p_si_provider;
1254: END IF;
1255: --
1256: BEGIN
1257: p_col_bal_def_table(i).balance_value := pay_balance_pkg.get_value
1258: (p_defined_balance_id => p_col_bal_def_table(i).defined_balance_id
1259: ,p_assignment_action_id => p_ass_action_id
1260: ,p_tax_unit_id => l_tax_unit_id
1261: ,p_jurisdiction_code => NULL

Line 1328: p_col_bal_def_table(i).balance_value2 := pay_balance_pkg.get_value

1324: l_source_text2 := p_si_provider;
1325: END IF;
1326: --
1327: BEGIN
1328: p_col_bal_def_table(i).balance_value2 := pay_balance_pkg.get_value
1329: (p_defined_balance_id => p_col_bal_def_table(i).defined_balance_id2
1330: ,p_assignment_action_id => p_ass_action_id
1331: ,p_tax_unit_id => l_tax_unit_id
1332: ,p_jurisdiction_code => NULL

Line 2443: l_lca_payments := pay_balance_pkg.get_value

2439: l_balance_dim_ytd := '_TU_WEEK_YTD'; --13974145
2440: END IF;
2441:
2442: l_lca_payments_bal_id := get_defined_balance_id(l_balance_name,l_balance_dim_ptd);
2443: l_lca_payments := pay_balance_pkg.get_value
2444: (p_defined_balance_id => l_lca_payments_bal_id
2445: ,p_assignment_action_id => p_ass_action_id
2446: ,p_tax_unit_id => p_tax_unit_id
2447: ,p_jurisdiction_code => NULL

Line 2491: l_lca_payments_ytd := pay_balance_pkg.get_value

2487:
2488: /* Fetch LCA Payments YTD Value */
2489: l_lca_payments_bal_id := get_defined_balance_id(l_balance_name,l_balance_dim_ytd);
2490:
2491: l_lca_payments_ytd := pay_balance_pkg.get_value
2492: (p_defined_balance_id => l_lca_payments_bal_id
2493: ,p_assignment_action_id => p_ass_action_id
2494: ,p_tax_unit_id => p_tax_unit_id
2495: ,p_jurisdiction_code => NULL

Line 2534: l_lca_payments_ytd := pay_balance_pkg.get_value

2530: /* Fetch LCA Payments YTD Value */
2531: hr_utility.set_location('Method 3 Normal calculation',300);
2532: l_lca_payments_bal_id := get_defined_balance_id(l_balance_name,l_balance_dim_ytd);
2533:
2534: l_lca_payments_ytd := pay_balance_pkg.get_value
2535: (p_defined_balance_id => l_lca_payments_bal_id
2536: ,p_assignment_action_id => p_ass_action_id
2537: ,p_tax_unit_id => p_tax_unit_id
2538: ,p_jurisdiction_code => NULL

Line 3570: p_balance_values(i).balance_value := pay_balance_pkg.get_value

3566: p_balance_values(i).balance_value := 0;
3567: ELSE
3568: IF l_context = 'Y' THEN
3569: BEGIN
3570: p_balance_values(i).balance_value := pay_balance_pkg.get_value
3571: (p_defined_balance_id => g_nom_bal_def_table(i).defined_balance_id
3572: ,p_assignment_action_id => l_assignment_action_id
3573: ,p_tax_unit_id => l_tax_unit_id
3574: ,p_jurisdiction_code => NULL

Line 3602: p_balance_values(i).balance_value := pay_balance_pkg.get_value(g_nom_bal_def_table(i).defined_balance_id

3598: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
3599: END;
3600: ELSE --IF g_nom_bal_def_table(i).database_item_suffix <> '_ASG_ADJ_PTD' THEN
3601: BEGIN
3602: p_balance_values(i).balance_value := pay_balance_pkg.get_value(g_nom_bal_def_table(i).defined_balance_id
3603: ,p_assignment_action_id);
3604: --##--Fnd_file.put_line(FND_FILE.LOG,'#########'||g_nom_bal_def_table(i).balance_name||' '||g_nom_bal_def_table(i).database_item_suffix||' '||p_balance_values(i).balance_value||' '||g_nom_bal_def_table(i).context_val);
3605: --##--Fnd_file.put_line(FND_FILE.LOG,'#########defined_balance_id :'||g_nom_bal_def_table(i).defined_balance_id);
3606: EXCEPTION

Line 13910: p_balance_values(i).balance_value := pay_balance_pkg.get_value

13906: ELSE
13907: IF l_context = 'Y' THEN
13908: BEGIN
13909: Fnd_file.put_line(FND_FILE.LOG,'#### Point 2');
13910: p_balance_values(i).balance_value := pay_balance_pkg.get_value
13911: (p_defined_balance_id => g_nom_bal_def_table(i).defined_balance_id
13912: ,p_assignment_action_id => l_assignment_action_id
13913: ,p_tax_unit_id => p_tax_unit_id
13914: ,p_jurisdiction_code => NULL

Line 13934: p_balance_values(i).balance_value := pay_balance_pkg.get_value

13930: END;
13931: ELSE
13932: BEGIN
13933: Fnd_file.put_line(FND_FILE.LOG,'#### Point 3');
13934: p_balance_values(i).balance_value := pay_balance_pkg.get_value
13935: (p_defined_balance_id => g_nom_bal_def_table(i).defined_balance_id
13936: ,p_assignment_action_id => l_assignment_action_id
13937: ,p_tax_unit_id => p_tax_unit_id
13938: ,p_jurisdiction_code => NULL