APPS.PQP_PENSION_EXTRACTS dependencies on PAY_DEFINED_BALANCES

Line 78: FROM pay_defined_balances db

74: CURSOR csr_asg_balid (c_balance_type_id IN NUMBER
75: ,c_balance_dimension_id IN NUMBER
76: ,c_business_group_id IN NUMBER) IS
77: SELECT db.defined_balance_id
78: FROM pay_defined_balances db
79: WHERE db.balance_type_id = c_balance_type_id
80: AND db.balance_dimension_id = c_balance_dimension_id
81: AND (db.business_group_id = c_business_group_id OR
82: db.legislation_code = g_legislation_code);

Line 3473: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

3469: ,p_balance_name IN VARCHAR2
3470: ,p_error_message OUT NOCOPY VARCHAR2
3471: ) RETURN NUMBER IS
3472:
3473: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3474: l_balance_amount NUMBER :=0;
3475: l_bal_total_amt NUMBER :=0;
3476: l_dimension_name VARCHAR2(100);
3477: i per_all_assignments_f.business_group_id%TYPE;