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 2055: FROM pay_balance_types pbt

2051: CURSOR csr_defined_bal (c_balance_name IN Varchar2
2052: ,c_dimension_name IN Varchar2
2053: ,c_business_group_id IN Number) IS
2054: SELECT db.defined_balance_id
2055: FROM pay_balance_types pbt
2056: ,pay_defined_balances db
2057: ,pay_balance_dimensions bd
2058: WHERE pbt.balance_name = c_balance_name
2059: AND pbt.balance_type_id = db.balance_type_id

Line 3076: from pay_balance_types pbt

3072:
3073: -- Cursor to get the defined_balance_id
3074: CURSOR c_def_bal_cur(c_dim_name IN pay_balance_dimensions.dimension_name%TYPE) IS
3075: select pdb.defined_balance_id
3076: from pay_balance_types pbt
3077: ,pay_balance_dimensions pbd
3078: ,pay_defined_balances pdb
3079: where balance_name = p_salary_balance_name
3080: and pbd.dimension_name = c_dim_name

Line 4437: l_recur_bonus_balance pay_balance_types.balance_type_id%type;

4433: l_pension_salary NUMBER;
4434: l_pension_salary_yr NUMBER;
4435: l_recur_bonus_percent NUMBER;
4436: l_non_recur_bonus_percent NUMBER;
4437: l_recur_bonus_balance pay_balance_types.balance_type_id%type;
4438: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;
4439: l_prev_bonus_include varchar2(1);
4440: l_recur_bonus number := 0;
4441: l_non_recur_bonus number := 0;

Line 4438: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;

4434: l_pension_salary_yr NUMBER;
4435: l_recur_bonus_percent NUMBER;
4436: l_non_recur_bonus_percent NUMBER;
4437: l_recur_bonus_balance pay_balance_types.balance_type_id%type;
4438: l_non_recur_bonus_balance pay_balance_types.balance_type_id%type;
4439: l_prev_bonus_include varchar2(1);
4440: l_recur_bonus number := 0;
4441: l_non_recur_bonus number := 0;
4442: l_prev_recur_bonus number := 0;

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

4468: effective_start_date AND effective_end_date
4469: AND business_group_id = p_business_group_id;
4470:
4471: CURSOR c_get_defined_bal_id
4472: (c_balance_type_id IN pay_balance_types.balance_type_id%TYPE) IS
4473: SELECT pdb.defined_balance_id
4474: FROM pay_balance_dimensions pbd
4475: ,pay_defined_balances pdb
4476: WHERE pbd.dimension_name = 'Assignment Year To Date'