eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_TYPES_API dependencies on PAY_BALANCE_CATEGORIES_F

Line 51: from pay_balance_categories_f

47: Cursor csr_get_balance_cat_id(c_category_name in varchar2
48: ,c_legislation_code in varchar2
49: ,c_effective_date in date) Is
50: Select balance_category_id
51: from pay_balance_categories_f
52: where category_name = c_category_name
53: and legislation_code = c_legislation_code
54: and c_effective_date between effective_start_date and effective_end_date;
55:

Line 66: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

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
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 67: l_category_name pay_balance_categories_f.category_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
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --

Line 246: from pay_balance_categories_f

242: Cursor csr_get_balance_cat_id(c_category_name in varchar2
243: ,c_legislation_code in varchar2
244: ,c_effective_date in date) Is
245: Select balance_category_id
246: from pay_balance_categories_f
247: where category_name = c_category_name
248: and legislation_code = c_legislation_code
249: and c_effective_date between effective_start_date and effective_end_date;
250:

Line 261: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

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
265: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 262: l_category_name pay_balance_categories_f.category_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
265: hr_utility.set_location('Entering:'|| l_proc, 10);
266: --

Line 441: from pay_balance_categories_f

437: Cursor csr_get_balance_cat_id(c_category_name in varchar2
438: ,c_legislation_code in varchar2
439: ,c_effective_date in date) Is
440: Select balance_category_id
441: from pay_balance_categories_f
442: where category_name = c_category_name
443: and legislation_code = c_legislation_code
444: and c_effective_date between effective_start_date and effective_end_date;
445:

Line 456: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

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
460: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 457: l_category_name pay_balance_categories_f.category_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
460: hr_utility.set_location('Entering:'|| l_proc, 10);
461: --

Line 674: FROM pay_balance_categories_f

670: CURSOR csr_get_balance_cat_id(c_category_name IN varchar2
671: ,c_legislation_code IN varchar2
672: ,c_effective_date IN DATE) IS
673: SELECT balance_category_id
674: FROM pay_balance_categories_f
675: WHERE category_name = c_category_name
676: AND legislation_code = c_legislation_code
677: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
678:

Line 689: l_balance_cat_id pay_balance_categories_f.balance_category_id%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
692: hr_utility.set_location('Entering:'|| l_proc, 10);
693: