APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 18: ,pay_balance_dimensions bd

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
21: AND bd.balance_dimension_id = db.balance_dimension_id
22: AND bd.dimension_name = c_dimension_name

Line 2122: ,pay_balance_dimensions bd

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
2125: AND bd.balance_dimension_id = db.balance_dimension_id
2126: AND bd.dimension_name = c_dimension_name

Line 3158: l_dimension_name pay_balance_dimensions.dimension_name%TYPE := 'Assignment Period To Date';

3154: l_time_period_id number;
3155: l_is_abp_pt number := 0;
3156: l_participation_st_dt date;
3157: l_ret_val number;
3158: l_dimension_name pay_balance_dimensions.dimension_name%TYPE := 'Assignment Period To Date';
3159: l_error_status CHAR:='0';
3160: -- Cursor to get the hire date of the person
3161: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
3162: SELECT max(date_start)

Line 3171: CURSOR c_def_bal_cur(c_dim_name IN pay_balance_dimensions.dimension_name%TYPE) IS

3167: AND pps.business_group_id = p_business_group_id
3168: AND date_start <= p_date_earned;
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

Line 3174: ,pay_balance_dimensions pbd

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
3178: and pdb.balance_type_id = pbt.balance_type_id

Line 4571: FROM pay_balance_dimensions pbd

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'
4574: AND pdb.balance_type_id = c_balance_type_id
4575: AND pbd.balance_dimension_id = pdb.balance_dimension_id