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 2057: ,pay_balance_dimensions bd

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

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

3057: l_time_period_id number;
3058: l_is_abp_pt number := 0;
3059: l_participation_st_dt date;
3060: l_ret_val number;
3061: l_dimension_name pay_balance_dimensions.dimension_name%TYPE := 'Assignment Period To Date';
3062: l_error_status CHAR:='0';
3063: -- Cursor to get the hire date of the person
3064: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
3065: SELECT max(date_start)

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

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

Line 3077: ,pay_balance_dimensions pbd

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

Line 4474: FROM pay_balance_dimensions pbd

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