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_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 16: FROM pay_balance_types pbt

12: CURSOR csr_defined_bal (c_balance_name IN Varchar2
13: ,c_dimension_name IN Varchar2
14: ,c_business_group_id IN Number) IS
15: SELECT db.defined_balance_id
16: FROM pay_balance_types pbt
17: ,pay_defined_balances db
18: ,pay_balance_dimensions bd
19: WHERE pbt.balance_name = c_balance_name
20: AND pbt.balance_type_id = db.balance_type_id

Line 2120: FROM pay_balance_types pbt

2116: CURSOR csr_defined_bal (c_balance_name IN Varchar2
2117: ,c_dimension_name IN Varchar2
2118: ,c_business_group_id IN Number) IS
2119: SELECT db.defined_balance_id
2120: FROM pay_balance_types pbt
2121: ,pay_defined_balances db
2122: ,pay_balance_dimensions bd
2123: WHERE pbt.balance_name = c_balance_name
2124: AND pbt.balance_type_id = db.balance_type_id

Line 3173: from pay_balance_types pbt

3169:
3170: -- Cursor to get the defined_balance_id
3171: CURSOR c_def_bal_cur(c_dim_name IN pay_balance_dimensions.dimension_name%TYPE) IS
3172: select pdb.defined_balance_id
3173: from pay_balance_types pbt
3174: ,pay_balance_dimensions pbd
3175: ,pay_defined_balances pdb
3176: where balance_name = p_salary_balance_name
3177: and pbd.dimension_name = c_dim_name

Line 4534: l_recur_bonus_balance pay_balance_types.balance_type_id%type;

4530: l_pension_salary NUMBER;
4531: l_pension_salary_yr NUMBER;
4532: l_recur_bonus_percent NUMBER;
4533: l_non_recur_bonus_percent NUMBER;
4534: l_recur_bonus_balance pay_balance_types.balance_type_id%type;
4535: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;
4536: l_prev_bonus_include varchar2(1);
4537: l_recur_bonus number := 0;
4538: l_non_recur_bonus number := 0;

Line 4535: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;

4531: l_pension_salary_yr NUMBER;
4532: l_recur_bonus_percent NUMBER;
4533: l_non_recur_bonus_percent NUMBER;
4534: l_recur_bonus_balance pay_balance_types.balance_type_id%type;
4535: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;
4536: l_prev_bonus_include varchar2(1);
4537: l_recur_bonus number := 0;
4538: l_non_recur_bonus number := 0;
4539: l_prev_recur_bonus number := 0;

Line 4569: (c_balance_type_id IN pay_balance_types.balance_type_id%TYPE) IS

4565: effective_start_date AND effective_end_date
4566: AND business_group_id = p_business_group_id;
4567:
4568: CURSOR c_get_defined_bal_id
4569: (c_balance_type_id IN pay_balance_types.balance_type_id%TYPE) IS
4570: SELECT pdb.defined_balance_id
4571: FROM pay_balance_dimensions pbd
4572: ,pay_defined_balances pdb
4573: WHERE pbd.dimension_name = 'Assignment Year To Date'