APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_DEFINED_BALANCES

Line 101: ,pay_defined_balances db

97: ,c_dimension_name IN VARCHAR2
98: ,c_business_group_id IN NUMBER) IS
99: SELECT db.defined_balance_id
100: FROM pay_balance_types pbt
101: ,pay_defined_balances db
102: ,pay_balance_dimensions bd
103: WHERE pbt.balance_name = c_balance_name
104: AND pbt.balance_type_id = db.balance_type_id
105: AND bd.balance_dimension_id = db.balance_dimension_id

Line 118: FROM pay_defined_balances db

114: CURSOR csr_asg_balid (c_balance_type_id IN NUMBER
115: ,c_balance_dimension_id IN NUMBER
116: ,c_business_group_id IN NUMBER) IS
117: SELECT db.defined_balance_id
118: FROM pay_defined_balances db
119: WHERE db.balance_type_id = c_balance_type_id
120: AND db.balance_dimension_id = c_balance_dimension_id
121: AND (db.business_group_id = c_business_group_id OR
122: db.legislation_code = g_legislation_code);

Line 4144: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

4140: ) RETURN NUMBER IS
4141:
4142: l_bal_total_amt NUMBER;
4143: l_balance_amount NUMBER;
4144: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4145: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4146: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4147: l_legislation_code per_business_groups.legislation_code%TYPE;
4148: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

Line 4420: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

4416: ,p_dimension_name IN VARCHAR2
4417: ,p_error_message OUT NOCOPY VARCHAR2
4418: ) RETURN NUMBER IS
4419:
4420: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4421: l_balance_amount NUMBER :=0;
4422: l_bal_total_amt NUMBER :=0;
4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;

Line 4671: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

4667: ,p_balance_name IN VARCHAR2
4668: ,p_error_message OUT NOCOPY VARCHAR2
4669: ) RETURN NUMBER IS
4670:
4671: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4672: l_balance_amount NUMBER :=0;
4673: l_bal_total_amt NUMBER :=0;
4674: l_dimension_name VARCHAR2(100);
4675: i per_all_assignments_f.business_group_id%TYPE;