APPS.PAY_MX_YREND_ARCH dependencies on PAY_BALANCE_PKG

Line 407: pay_balance_pkg.get_value(fue_live.creator_id,

403: -- Get balances for archival
404: CURSOR c_get_balances IS
405: SELECT DISTINCT
406: fue_live.user_entity_name,
407: pay_balance_pkg.get_value(fue_live.creator_id,
408: p_ytd_action_id)
409: FROM pay_bal_attribute_definitions pbad,
410: pay_balance_attributes pba,
411: pay_defined_balances pdb_attr,

Line 431: pay_balance_pkg.get_value(fue_live.creator_id,

427: -- Get Profit Sharing balances for archival
428: CURSOR c_get_PTU_balances IS
429: SELECT DISTINCT
430: fue_live.user_entity_name,
431: pay_balance_pkg.get_value(fue_live.creator_id,
432: p_ytd_action_id)
433: FROM pay_defined_balances pdb_call,
434: pay_balance_dimensions pbd,
435: pay_balance_types pbt,

Line 464: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

460: --
461: lv_procedure_name := '.populate_balances';
462: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
463:
464: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
465:
466: -- Create the Archive DBI routes if they don't exist
467: --
468: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 1488: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,

1484: -- Get the creditable and non-creditable subsidy for the person under
1485: -- the current employer
1486: /*CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1487: ) IS
1488: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1489: cp_ytd_action_id),
1490: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1491: cp_ytd_action_id)
1492: FROM pay_defined_balances pdb_cr,

Line 1490: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,

1486: /*CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1487: ) IS
1488: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1489: cp_ytd_action_id),
1490: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1491: cp_ytd_action_id)
1492: FROM pay_defined_balances pdb_cr,
1493: pay_defined_balances pdb_ncr,
1494: pay_balance_types pbt_cr,

Line 1512: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,

1508: -- Get the ISR Calculated, creditable and non-creditable subsidy
1509: -- for the person under the current employer
1510: CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1511: ) IS
1512: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1513: cp_ytd_action_id)
1514: FROM pay_defined_balances pdb_cr,
1515: pay_balance_types pbt_cr,
1516: pay_balance_dimensions pbd

Line 1525: select pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,

1521: AND pbt_cr.legislation_code = 'MX';
1522:
1523: CURSOR c_get_nonsubsidy(cp_ytd_action_id NUMBER
1524: ) IS
1525: select pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1526: cp_ytd_action_id)
1527: FROM pay_defined_balances pdb_ncr,
1528: pay_balance_types pbt_ncr,
1529: pay_balance_dimensions pbd

Line 1539: select pay_balance_pkg.get_value(pdb_calc.defined_balance_id,

1535: AND pbd.legislation_code = pbt_ncr.legislation_code;
1536:
1537: CURSOR c_get_calc(cp_ytd_action_id NUMBER
1538: ) IS
1539: select pay_balance_pkg.get_value(pdb_calc.defined_balance_id,
1540: cp_ytd_action_id)
1541: FROM pay_defined_balances pdb_calc,
1542: pay_balance_types pbt_calc,
1543: pay_balance_dimensions pbd

Line 1813: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

1809: END IF;
1810:
1811: CLOSE c_get_ytd_aaid;
1812:
1813: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
1814:
1815: ln_step := 5;
1816: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1817: