APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_BALANCE_FEEDS_F

Line 359: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

355:
356: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
357: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
358: l_pen_sal_bal_type_id pqp_pension_types_f.pension_salary_balance%type := -1;
359: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
360: l_row_id rowid;
361: l_request_id Number;
362: l_er_request_id Number;
363: l_formula_text varchar2(32767);

Line 541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

537: -- ---------------------------------------------------------------------
538: procedure Create_Pen_Sal_Bal_Feeds is
539: --
540: l_row_id rowid;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
542: l_proc_name Varchar2(80) := g_proc_name ||
543: 'Create_Pen_Sal_Bal_Feeds ';
544: --
545: cursor c1_get_reg_earn_feeds is

Line 578: Pay_Balance_Feeds_f_pkg.Insert_Row

574: begin
575: hr_utility.set_location('Entering: '||l_proc_name, 10);
576: for c1_rec in c1_get_reg_earn_feeds loop
577: for c2_rec in c2_balance_type loop
578: Pay_Balance_Feeds_f_pkg.Insert_Row
579: (X_Rowid => l_row_id,
580: X_Balance_Feed_Id => l_Balance_Feed_Id,
581: X_Effective_Start_Date => p_effective_start_date,
582: X_Effective_End_Date => hr_api.g_eot,

Line 1508: Pay_Balance_Feeds_f_pkg.Insert_Row(

1504: fnd_message.raise_error;
1505: close csr_pty;
1506: end if;
1507: close csr_pty;
1508: Pay_Balance_Feeds_f_pkg.Insert_Row(
1509: X_Rowid => l_row_id,
1510: X_Balance_Feed_Id => l_Balance_Feed_Id,
1511: X_Effective_Start_Date => p_effective_start_date,
1512: X_Effective_End_Date => hr_api.g_eot,

Line 1550: Pay_Balance_Feeds_f_pkg.Insert_Row(

1546: fnd_message.raise_error;
1547: close csr_pty2;
1548: end if;
1549: close csr_pty2;
1550: Pay_Balance_Feeds_f_pkg.Insert_Row(
1551: X_Rowid => l_row_id,
1552: X_Balance_Feed_Id => l_Balance_Feed_Id,
1553: X_Effective_Start_Date => p_effective_start_date,
1554: X_Effective_End_Date => hr_api.g_eot,