APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_BALANCE_FEEDS_F

Line 541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
542: l_row_id rowid;
543: l_request_id Number;
544: l_er_request_id Number;
545: l_dbi_user_name ff_database_items.user_name%TYPE;

Line 1065: Pay_Balance_Feeds_f_pkg.Insert_Row(

1061: (c_ele_typeid => l_base_element_type_id
1062: ,c_effective_date => p_effective_start_date )
1063: loop
1064:
1065: Pay_Balance_Feeds_f_pkg.Insert_Row(
1066: X_Rowid => l_row_id,
1067: X_Balance_Feed_Id => l_Balance_Feed_Id,
1068: X_Effective_Start_Date => p_effective_start_date,
1069: X_Effective_End_Date => hr_api.g_eot,

Line 1088: Pay_Balance_Feeds_f_pkg.Insert_Row(

1084: ,c_ipv_name => 'EE Pension Deduction'
1085: ,c_effective_date => p_effective_start_date )
1086: loop
1087:
1088: Pay_Balance_Feeds_f_pkg.Insert_Row(
1089: X_Rowid => l_row_id,
1090: X_Balance_Feed_Id => l_Balance_Feed_Id,
1091: X_Effective_Start_Date => p_effective_start_date,
1092: X_Effective_End_Date => hr_api.g_eot,

Line 1117: Pay_Balance_Feeds_f_pkg.Insert_Row(

1113: for ipv_rec in csr_ipv
1114: (c_ele_typeid => l_er_base_element_type_id
1115: ,c_effective_date => p_effective_start_date )
1116: loop
1117: Pay_Balance_Feeds_f_pkg.Insert_Row(
1118: X_Rowid => l_row_id,
1119: X_Balance_Feed_Id => l_Balance_Feed_Id,
1120: X_Effective_Start_Date => p_effective_start_date,
1121: X_Effective_End_Date => hr_api.g_eot,

Line 1139: Pay_Balance_Feeds_f_pkg.Insert_Row(

1135: (c_ele_typeid => l_setup_element_type_id
1136: ,c_ipv_name => 'ER Contribution'
1137: ,c_effective_date => p_effective_start_date )
1138: loop
1139: Pay_Balance_Feeds_f_pkg.Insert_Row(
1140: X_Rowid => l_row_id,
1141: X_Balance_Feed_Id => l_Balance_Feed_Id,
1142: X_Effective_Start_Date => p_effective_start_date,
1143: X_Effective_End_Date => hr_api.g_eot,