APPS.PQP_PENSION_TYPES_API dependencies on PAY_BALANCE_DIMENSIONS

Line 37: from pay_balance_dimensions

33: and business_group_id = p_business_group_id;
34:
35: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
36: Select balance_dimension_id
37: from pay_balance_dimensions
38: where legislation_code = c_legislation_code
39: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
40: '_ASG_MONTH', '_ASG_PTD',
41: '_ASG_YTD', '_ASG_RUN',

Line 64: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%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
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 218: from pay_balance_dimensions

214: and business_group_id = p_business_group_id;
215:
216: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
217: Select balance_dimension_id
218: from pay_balance_dimensions
219: where legislation_code = c_legislation_code
220: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
221: '_ASG_MONTH', '_ASG_PTD',
222: '_ASG_YTD', '_ASG_RUN',

Line 245: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%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
249: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 399: from pay_balance_dimensions

395: and business_group_id = p_business_group_id;
396:
397: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
398: Select balance_dimension_id
399: from pay_balance_dimensions
400: where legislation_code = c_legislation_code
401: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
402: '_ASG_MONTH', '_ASG_PTD',
403: '_ASG_YTD', '_ASG_RUN',

Line 426: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%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
430: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 608: from pay_balance_dimensions

604: and business_group_id = p_business_group_id;
605:
606: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
607: Select balance_dimension_id
608: from pay_balance_dimensions
609: where legislation_code = c_legislation_code
610: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
611: '_ASG_MONTH', '_ASG_PTD',
612: '_ASG_YTD', '_ASG_RUN',

Line 625: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%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:
629: Begin