APPS.PQP_PENSION_TYPES_API dependencies on PAY_BALANCE_DIMENSIONS

Line 38: from pay_balance_dimensions

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

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

Line 233: from pay_balance_dimensions

229: and business_group_id = p_business_group_id;
230:
231: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
232: Select balance_dimension_id
233: from pay_balance_dimensions
234: where legislation_code = c_legislation_code
235: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
236: '_ASG_MONTH', '_ASG_PTD',
237: '_ASG_YTD', '_ASG_RUN',

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

Line 428: from pay_balance_dimensions

424: and business_group_id = p_business_group_id;
425:
426: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
427: Select balance_dimension_id
428: from pay_balance_dimensions
429: where legislation_code = c_legislation_code
430: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
431: '_ASG_MONTH', '_ASG_PTD',
432: '_ASG_YTD', '_ASG_RUN',

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

Line 661: from pay_balance_dimensions

657: and business_group_id = p_business_group_id;
658:
659: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is
660: Select balance_dimension_id
661: from pay_balance_dimensions
662: where legislation_code = c_legislation_code
663: and database_item_suffix in ('_ASG_ITD', '_ASG_QTD',
664: '_ASG_MONTH', '_ASG_PTD',
665: '_ASG_YTD', '_ASG_RUN',

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