APPS.PQP_PENSION_TYPES_API dependencies on PAY_DEFINED_BALANCES

Line 64: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 185: Pay_Defined_Balances_pkg.Insert_Row

181:
182: For csr_dim in csr_bal_dim
183: (c_legislation_code => l_legislation_code )
184: Loop
185: Pay_Defined_Balances_pkg.Insert_Row
186: (x_rowid => l_row_id
187: ,x_defined_balance_id => l_defined_balance_id
188: ,x_business_group_id => p_business_group_id
189: ,x_legislation_code => p_legislation_code

Line 259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;
259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
260: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
261: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
262: l_category_name pay_balance_categories_f.category_name%TYPE;
263:

Line 380: Pay_Defined_Balances_pkg.Insert_Row

376:
377: For csr_dim in csr_bal_dim
378: (c_legislation_code => l_legislation_code )
379: Loop
380: Pay_Defined_Balances_pkg.Insert_Row
381: (x_rowid => l_row_id
382: ,x_defined_balance_id => l_defined_balance_id
383: ,x_business_group_id => p_business_group_id
384: ,x_legislation_code => p_legislation_code

Line 454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;
454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
455: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
456: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
457: l_category_name pay_balance_categories_f.category_name%TYPE;
458:

Line 613: Pay_Defined_Balances_pkg.Insert_Row

609: End if;
610: For csr_dim in csr_bal_dim
611: (c_legislation_code => l_legislation_code )
612: Loop
613: Pay_Defined_Balances_pkg.Insert_Row
614: (x_rowid => l_row_id
615: ,x_defined_balance_id => l_defined_balance_id
616: ,x_business_group_id => p_business_group_id
617: ,x_legislation_code => p_legislation_code

Line 686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;
686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
687: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
688: l_pension_sub_cat varchar2(80) := '';
689: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE;
690:

Line 842: Pay_Defined_Balances_pkg.Insert_Row

838: End if;
839: For csr_dim in csr_bal_dim
840: (c_legislation_code => l_legislation_code )
841: Loop
842: Pay_Defined_Balances_pkg.Insert_Row
843: (x_rowid => l_row_id
844: ,x_defined_balance_id => l_defined_balance_id
845: ,x_business_group_id => p_business_group_id
846: ,x_legislation_code => p_legislation_code