APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_BALANCE_FEEDS_F

Line 105: pay_balance_feeds_f.balance_feed_id%TYPE;

101: l_er_retro_bal_id pay_balance_types.balance_type_id%TYPE;
102: l_pen_sal_bal_type_id
103: pqp_pension_types_f.pension_salary_balance%TYPE := -1;
104: l_balance_feed_Id
105: pay_balance_feeds_f.balance_feed_id%TYPE;
106: l_row_id ROWID;
107: l_request_id NUMBER;
108: l_er_request_id NUMBER;
109: l_formula_text VARCHAR2(32767);

Line 512: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%TYPE;

508: -- ---------------------------------------------------------------------
509: PROCEDURE Create_Pen_Sal_Bal_Feeds IS
510: --
511: l_row_id ROWID;
512: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%TYPE;
513: l_proc_name VARCHAR2(80) := g_proc_name ||
514: 'Create_Pen_Sal_Bal_Feeds ';
515: --
516: cursor c1_get_reg_earn_feeds is

Line 548: Pay_Balance_Feeds_f_pkg.Insert_Row

544: BEGIN
545: hr_utility.set_location('Entering: '||l_proc_name, 10);
546: FOR c1_rec IN c1_get_reg_earn_feeds LOOP
547: FOR c2_rec IN c2_balance_type LOOP
548: Pay_Balance_Feeds_f_pkg.Insert_Row
549: (X_Rowid => l_row_id,
550: X_Balance_Feed_Id => l_Balance_Feed_Id,
551: X_Effective_Start_Date => p_effective_start_date,
552: X_Effective_End_Date => hr_api.g_eot,

Line 1545: Pay_Balance_Feeds_f_pkg.Insert_Row(

1541: l_ee_contribution_bal_type_id := r_pty_rec.ee_contribution_bal_type_id;
1542:
1543: IF l_ee_contribution_bal_type_id IS NOT NULL THEN
1544:
1545: Pay_Balance_Feeds_f_pkg.Insert_Row(
1546: X_Rowid => l_row_id,
1547: X_Balance_Feed_Id => l_Balance_Feed_Id,
1548: X_Effective_Start_Date => p_effective_start_date,
1549: X_Effective_End_Date => hr_api.g_eot,

Line 1596: Pay_Balance_Feeds_f_pkg.Insert_Row(

1592:
1593:
1594: IF l_ee_retro_bal_id IS NOT NULL THEN
1595:
1596: Pay_Balance_Feeds_f_pkg.Insert_Row(
1597: X_Rowid => l_row_id,
1598: X_Balance_Feed_Id => l_Balance_Feed_Id,
1599: X_Effective_Start_Date => p_effective_start_date,
1600: X_Effective_End_Date => hr_api.g_eot,

Line 1629: Pay_Balance_Feeds_f_pkg.Insert_Row(

1625:
1626:
1627: IF l_ee_retro_bal_id IS NOT NULL THEN
1628:
1629: Pay_Balance_Feeds_f_pkg.Insert_Row(
1630: X_Rowid => l_row_id,
1631: X_Balance_Feed_Id => l_Balance_Feed_Id,
1632: X_Effective_Start_Date => p_effective_start_date,
1633: X_Effective_End_Date => hr_api.g_eot,

Line 1667: Pay_Balance_Feeds_f_pkg.Insert_Row(

1663: l_er_contribution_bal_type_id := r_pty_rec.er_contribution_bal_type_id;
1664:
1665: IF l_er_contribution_bal_type_id IS NOT NULL THEN
1666:
1667: Pay_Balance_Feeds_f_pkg.Insert_Row(
1668: X_Rowid => l_row_id,
1669: X_Balance_Feed_Id => l_Balance_Feed_Id,
1670: X_Effective_Start_Date => p_effective_start_date,
1671: X_Effective_End_Date => hr_api.g_eot,

Line 1700: Pay_Balance_Feeds_f_pkg.Insert_Row(

1696: (c_ele_typeid => l_cy_er_retro_element_type_id
1697: ,c_effective_date => p_effective_start_date )
1698: LOOP
1699: IF l_er_retro_bal_id IS NOT NULL THEN
1700: Pay_Balance_Feeds_f_pkg.Insert_Row(
1701: X_Rowid => l_row_id,
1702: X_Balance_Feed_Id => l_Balance_Feed_Id,
1703: X_Effective_Start_Date => p_effective_start_date,
1704: X_Effective_End_Date => hr_api.g_eot,

Line 1729: Pay_Balance_Feeds_f_pkg.Insert_Row(

1725: (c_ele_typeid => l_py_er_retro_element_type_id
1726: ,c_effective_date => p_effective_start_date )
1727: LOOP
1728: IF l_er_retro_bal_id IS NOT NULL THEN
1729: Pay_Balance_Feeds_f_pkg.Insert_Row(
1730: X_Rowid => l_row_id,
1731: X_Balance_Feed_Id => l_Balance_Feed_Id,
1732: X_Effective_Start_Date => p_effective_start_date,
1733: X_Effective_End_Date => hr_api.g_eot,