APPS.PQP_PENSION_TYPES_API dependencies on PAY_DEFINED_BALANCES

Line 63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;
63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
64: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
65: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
66:
67: Begin

Line 171: Pay_Defined_Balances_pkg.Insert_Row

167:
168: For csr_dim in csr_bal_dim
169: (c_legislation_code => l_legislation_code )
170: Loop
171: Pay_Defined_Balances_pkg.Insert_Row
172: (x_rowid => l_row_id
173: ,x_defined_balance_id => l_defined_balance_id
174: ,x_business_group_id => p_business_group_id
175: ,x_legislation_code => p_legislation_code

Line 244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;
244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
245: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
246: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
247:
248: Begin

Line 352: Pay_Defined_Balances_pkg.Insert_Row

348:
349: For csr_dim in csr_bal_dim
350: (c_legislation_code => l_legislation_code )
351: Loop
352: Pay_Defined_Balances_pkg.Insert_Row
353: (x_rowid => l_row_id
354: ,x_defined_balance_id => l_defined_balance_id
355: ,x_business_group_id => p_business_group_id
356: ,x_legislation_code => p_legislation_code

Line 425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;
425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
426: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
427: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
428:
429: Begin

Line 560: Pay_Defined_Balances_pkg.Insert_Row

556: End if;
557: For csr_dim in csr_bal_dim
558: (c_legislation_code => l_legislation_code )
559: Loop
560: Pay_Defined_Balances_pkg.Insert_Row
561: (x_rowid => l_row_id
562: ,x_defined_balance_id => l_defined_balance_id
563: ,x_business_group_id => p_business_group_id
564: ,x_legislation_code => p_legislation_code

Line 624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;
624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
625: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
626: l_pension_sub_cat varchar2(80) := '';
627: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE;
628:

Line 773: Pay_Defined_Balances_pkg.Insert_Row

769: End if;
770: For csr_dim in csr_bal_dim
771: (c_legislation_code => l_legislation_code )
772: Loop
773: Pay_Defined_Balances_pkg.Insert_Row
774: (x_rowid => l_row_id
775: ,x_defined_balance_id => l_defined_balance_id
776: ,x_business_group_id => p_business_group_id
777: ,x_legislation_code => p_legislation_code