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 50: from pay_balance_categories_f

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

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

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);
69: --

Line 231: from pay_balance_categories_f

227: Cursor csr_get_balance_cat_id(c_category_name in varchar2
228: ,c_legislation_code in varchar2
229: ,c_effective_date in date) Is
230: Select balance_category_id
231: from pay_balance_categories_f
232: where category_name = c_category_name
233: and legislation_code = c_legislation_code
234: and c_effective_date between effective_start_date and effective_end_date;
235:

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

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);
250: --

Line 412: from pay_balance_categories_f

408: Cursor csr_get_balance_cat_id(c_category_name in varchar2
409: ,c_legislation_code in varchar2
410: ,c_effective_date in date) Is
411: Select balance_category_id
412: from pay_balance_categories_f
413: where category_name = c_category_name
414: and legislation_code = c_legislation_code
415: and c_effective_date between effective_start_date and effective_end_date;
416:

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

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);
431: --

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