APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_BALANCE_FEEDS_F

Line 357: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

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

Line 539: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

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

Line 576: Pay_Balance_Feeds_f_pkg.Insert_Row

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

Line 1506: Pay_Balance_Feeds_f_pkg.Insert_Row(

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

Line 1548: Pay_Balance_Feeds_f_pkg.Insert_Row(

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