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.PAY_NO_EOY_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);

1298: --
1299: --
1300: -- Set balance contexts.
1301: --
1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1306: --

Line 1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1299: --
1300: -- Set balance contexts.
1301: --
1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1306: --
1307: --

Line 1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);

1300: -- Set balance contexts.
1301: --
1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1306: --
1307: --
1308: -- Reset the values to Zero: changes 2007/2008

Line 1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);

1301: --
1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1306: --
1307: --
1308: -- Reset the values to Zero: changes 2007/2008
1309: l_reimb_bse := 0;

Line 1368: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);

1364: -- Employer Contribution Special Percentage_TU_LU_YTD
1365: -- Employer Contribution Special_TU_LU_YTD
1366: --
1367: --
1368: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);
1369: l_le_si_bal_table(l_le_si_count).tax := l_le_si_bal_table(l_le_si_count).tax + l_bal_value;
1370: --
1371: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1372: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;

Line 1371: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);

1367: --
1368: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);
1369: l_le_si_bal_table(l_le_si_count).tax := l_le_si_bal_table(l_le_si_count).tax + l_bal_value;
1370: --
1371: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1372: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;
1373: --
1374: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1375: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;

Line 1374: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);

1370: --
1371: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1372: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;
1373: --
1374: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1375: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;
1376: --
1377: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);
1378: l_le_si_bal_table(l_le_si_count).emp_contr_spcl := l_le_si_bal_table(l_le_si_count).emp_contr_spcl + l_bal_value;

Line 1377: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);

1373: --
1374: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1375: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;
1376: --
1377: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);
1378: l_le_si_bal_table(l_le_si_count).emp_contr_spcl := l_le_si_bal_table(l_le_si_count).emp_contr_spcl + l_bal_value;
1379: --
1380:
1381: END IF;

Line 1385: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_reimb_bse_defbal_id, p_assignment_action_id => l_asg_act_id);

1381: END IF;
1382: --
1383: -- Start changes 2007/2008
1384: -- Special Reimburesd Base for US/Canada
1385: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_reimb_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1386: l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base := l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base + l_bal_value;
1387: --
1388: -- Employer Contribution Base
1389: --

Line 1390: l_emp_contr_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);

1386: l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base := l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base + l_bal_value;
1387: --
1388: -- Employer Contribution Base
1389: --
1390: l_emp_contr_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);
1391: l_tot_emp_contr_bse := nvl(l_tot_emp_contr_bse,0) + nvl(l_emp_contr_bse,0);
1392: --
1393: -- Reimbursed Base
1394: --

Line 1395: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id

1391: l_tot_emp_contr_bse := nvl(l_tot_emp_contr_bse,0) + nvl(l_emp_contr_bse,0);
1392: --
1393: -- Reimbursed Base
1394: --
1395: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1396: ,p_assignment_action_id => l_asg_act_id);
1397: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1398: ,p_assignment_action_id => l_asg_act_id),0);
1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id

Line 1397: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id

1393: -- Reimbursed Base
1394: --
1395: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1396: ,p_assignment_action_id => l_asg_act_id);
1397: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1398: ,p_assignment_action_id => l_asg_act_id),0);
1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1400: ,p_assignment_action_id => l_asg_act_id),0);
1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id

Line 1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id

1395: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1396: ,p_assignment_action_id => l_asg_act_id);
1397: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1398: ,p_assignment_action_id => l_asg_act_id),0);
1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1400: ,p_assignment_action_id => l_asg_act_id),0);
1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1402: ,p_assignment_action_id => l_asg_act_id),0);
1403: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id

Line 1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id

1397: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1398: ,p_assignment_action_id => l_asg_act_id),0);
1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1400: ,p_assignment_action_id => l_asg_act_id),0);
1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1402: ,p_assignment_action_id => l_asg_act_id),0);
1403: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1404: ,p_assignment_action_id => l_asg_act_id),0);
1405: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id

Line 1403: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id

1399: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1400: ,p_assignment_action_id => l_asg_act_id),0);
1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1402: ,p_assignment_action_id => l_asg_act_id),0);
1403: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1404: ,p_assignment_action_id => l_asg_act_id),0);
1405: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id
1406: ,p_assignment_action_id => l_asg_act_id),0);
1407: -- Total of the Reimbursed bases for all the zones

Line 1405: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id

1401: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1402: ,p_assignment_action_id => l_asg_act_id),0);
1403: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1404: ,p_assignment_action_id => l_asg_act_id),0);
1405: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id
1406: ,p_assignment_action_id => l_asg_act_id),0);
1407: -- Total of the Reimbursed bases for all the zones
1408: l_tot_reimb_bse := nvl(l_tot_reimb_bse,0) + nvl(l_reimb_bse,0);
1409: --

Line 1412: l_pension_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_emp_pension_bse_defbal_id , p_assignment_action_id => l_asg_act_id);

1408: l_tot_reimb_bse := nvl(l_tot_reimb_bse,0) + nvl(l_reimb_bse,0);
1409: --
1410: -- Pension Base
1411: --
1412: l_pension_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_emp_pension_bse_defbal_id , p_assignment_action_id => l_asg_act_id);
1413:
1414: l_tot_pension_bse := nvl(l_tot_pension_bse,0) + nvl(l_pension_bse,0);
1415: --
1416: -- End 2007/2008 changes

Line 1454: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);

1450: -- Employer Contribution Over 62 Base_TU_MU_LU_YTD
1451: --
1452: -- and add them into correct NI Zone.
1453: --
1454: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);
1455: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) :=
1456: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) + l_bal_value;
1457: l_le_si_bal_table(l_le_si_count).emp_contr.total :=
1458: l_le_si_bal_table(l_le_si_count).emp_contr.total + l_bal_value;

Line 1460: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_eco62_defbal_id, p_assignment_action_id => l_asg_act_id);

1456: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) + l_bal_value;
1457: l_le_si_bal_table(l_le_si_count).emp_contr.total :=
1458: l_le_si_bal_table(l_le_si_count).emp_contr.total + l_bal_value;
1459: --
1460: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_eco62_defbal_id, p_assignment_action_id => l_asg_act_id);
1461: l_le_si_bal_table(l_le_si_count).emp_contr_over62.ni_zone(l_rec2.ni_zone) :=
1462: l_le_si_bal_table(l_le_si_count).emp_contr_over62.ni_zone(l_rec2.ni_zone) + l_bal_value;
1463: l_le_si_bal_table(l_le_si_count).emp_contr_over62.total :=
1464: l_le_si_bal_table(l_le_si_count).emp_contr_over62.total + l_bal_value;

Line 1725: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);

1721: OPEN csr_PER(l_asg_rec.person_id, l_asg_rec.effective_date);
1722: FETCH csr_PER INTO l_person_rec;
1723: CLOSE csr_PER;
1724: --
1725: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1726: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1727: --
1728: -- Seaman_PER_TU_YTD
1729: --

Line 1726: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1722: FETCH csr_PER INTO l_person_rec;
1723: CLOSE csr_PER;
1724: --
1725: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1726: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1727: --
1728: -- Seaman_PER_TU_YTD
1729: --
1730: l_bal_value := pay_balance_pkg.get_value

Line 1730: l_bal_value := pay_balance_pkg.get_value

1726: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1727: --
1728: -- Seaman_PER_TU_YTD
1729: --
1730: l_bal_value := pay_balance_pkg.get_value
1731: (p_defined_balance_id => l_seaman_defbal_id
1732: ,p_assignment_id => l_asg_rec.assignment_id
1733: ,p_virtual_date => least(g_report_date,l_asg_rec.effective_end_date));
1734: --

Line 2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);

2204: --
2205: --
2206: -- Setup balance contexts.
2207: --
2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);

Line 2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));

2205: --
2206: -- Setup balance contexts.
2207: --
2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2213: --

Line 2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);

2206: -- Setup balance contexts.
2207: --
2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2213: --
2214: --

Line 2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);

2207: --
2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2213: --
2214: --
2215: -- Loop through all balance based reporting codes.

Line 2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);

2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2213: --
2214: --
2215: -- Loop through all balance based reporting codes.
2216: --

Line 2226: pay_balance_pkg.set_context('SOURCE_TEXT', l_bal_rec.reporting_code);

2222: --
2223: --
2224: -- Setup balance contexts NB. This is used for reporting codes using BAL_CODE_CTX.
2225: --
2226: pay_balance_pkg.set_context('SOURCE_TEXT', l_bal_rec.reporting_code);
2227: --
2228: --
2229: -- Get balance value.
2230: --

Line 2232: l_amount := pay_balance_pkg.get_value

2228: --
2229: -- Get balance value.
2230: --
2231: IF l_bal_rec.defined_balance_id IS NOT NULL THEN
2232: l_amount := pay_balance_pkg.get_value
2233: (p_defined_balance_id => l_bal_rec.defined_balance_id
2234: ,p_assignment_id => l_asg_act_rec.assignment_id
2235: ,p_virtual_date => g_report_date);
2236: ELSE

Line 2512: l_amount := pay_balance_pkg.get_value

2508: --
2509: -- Get balance value.
2510: --
2511: IF l_bal_info_rec.defined_balance_id IS NOT NULL THEN
2512: l_amount := pay_balance_pkg.get_value
2513: (p_defined_balance_id => l_bal_info_rec.defined_balance_id
2514: ,p_assignment_id => l_asg_act_rec.assignment_id
2515: ,p_virtual_date => g_report_date);
2516: ELSE

Line 2942: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);

2938: --
2939: --
2940: -- Setup balance contexts.
2941: --
2942: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
2943: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
2944: --
2945: --
2946: -- Retrieve balance for:-

Line 2943: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

2939: --
2940: -- Setup balance contexts.
2941: --
2942: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
2943: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
2944: --
2945: --
2946: -- Retrieve balance for:-
2947: --

Line 2950: l_amount := pay_balance_pkg.get_value

2946: -- Retrieve balance for:-
2947: --
2948: -- Tax_PER_TU_YTD
2949: --
2950: l_amount := pay_balance_pkg.get_value
2951: (p_defined_balance_id => l_tax_defbal_id
2952: ,p_assignment_id => l_asg_act_rec.assignment_id
2953: ,p_virtual_date => g_report_date);
2954: --