APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_BALANCE_FEEDS_F

Line 410: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

406: l_configuration_information20 VARCHAR2(10) := 'N' ;
407:
408: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
409: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
410: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
411: l_row_id rowid;
412: l_request_id Number;
413: l_er_request_id Number;
414: l_formula_text varchar2(32767);

Line 563: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

559: -- ---------------------------------------------------------------------
560: procedure Create_Pen_Sal_Bal_Feeds is
561: --
562: l_row_id rowid;
563: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
564: l_proc_name Varchar2(80) := g_proc_name ||
565: 'Create_Pen_Sal_Bal_Feeds ';
566: --
567: cursor c1_get_reg_earn_feeds is

Line 593: Pay_Balance_Feeds_f_pkg.Insert_Row

589: begin
590: hr_utility.set_location('Entering: '||l_proc_name, 10);
591: for c1_rec in c1_get_reg_earn_feeds loop
592: for c2_rec in c2_balance_type loop
593: Pay_Balance_Feeds_f_pkg.Insert_Row
594: (X_Rowid => l_row_id,
595: X_Balance_Feed_Id => l_Balance_Feed_Id,
596: X_Effective_Start_Date => p_effective_start_date,
597: X_Effective_End_Date => hr_api.g_eot,

Line 1644: Pay_Balance_Feeds_f_pkg.Insert_Row(

1640: fnd_message.raise_error;
1641: close csr_pty;
1642: end if;
1643: close csr_pty;
1644: Pay_Balance_Feeds_f_pkg.Insert_Row(
1645: X_Rowid => l_row_id,
1646: X_Balance_Feed_Id => l_Balance_Feed_Id,
1647: X_Effective_Start_Date => p_effective_start_date,
1648: X_Effective_End_Date => hr_api.g_eot,

Line 1686: Pay_Balance_Feeds_f_pkg.Insert_Row(

1682: fnd_message.raise_error;
1683: close csr_pty2;
1684: end if;
1685: close csr_pty2;
1686: Pay_Balance_Feeds_f_pkg.Insert_Row(
1687: X_Rowid => l_row_id,
1688: X_Balance_Feed_Id => l_Balance_Feed_Id,
1689: X_Effective_Start_Date => p_effective_start_date,
1690: X_Effective_End_Date => hr_api.g_eot,