APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_DEFINED_BALANCES

Line 134: ,pay_defined_balances db

130: ,c_dimension_name IN Varchar2
131: ,c_business_group_id IN Number) IS
132: SELECT db.defined_balance_id
133: FROM pay_balance_types pbt
134: ,pay_defined_balances db
135: ,pay_balance_dimensions bd
136: WHERE pbt.balance_name = c_balance_name
137: AND pbt.balance_type_id = db.balance_type_id
138: AND bd.balance_dimension_id = db.balance_dimension_id

Line 152: FROM pay_defined_balances db

148: CURSOR csr_defined_bal1 (c_balance_type_id IN Number
149: ,c_dimension_name IN Varchar2
150: ,c_business_group_id IN Number) IS
151: SELECT db.defined_balance_id
152: FROM pay_defined_balances db
153: ,pay_balance_dimensions bd
154: WHERE db.balance_type_id = c_balance_type_id
155: AND bd.balance_dimension_id = db.balance_dimension_id
156: AND bd.dimension_name = c_dimension_name

Line 167: FROM pay_defined_balances db

163: CURSOR csr_asg_balid (c_balance_type_id IN Number
164: ,c_balance_dimension_id IN Number
165: ,c_business_group_id IN Number) IS
166: SELECT db.defined_balance_id
167: FROM pay_defined_balances db
168: WHERE db.balance_type_id = c_balance_type_id
169: AND db.balance_dimension_id = c_balance_dimension_id
170: AND (db.business_group_id = c_business_group_id OR
171: db.legislation_code = g_legislation_code);

Line 2101: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2097: ,p_start_date IN DATE
2098: ,p_end_date IN DATE)
2099: RETURN NUMBER IS
2100:
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2102: l_balance_amount NUMBER :=0;
2103: l_bal_total_amt NUMBER :=0;
2104: l_dimension_name VARCHAR2(100);
2105: i per_all_assignments_f.business_group_id%TYPE;