APPS.PAY_CN_EXT dependencies on PAY_DEFINED_BALANCES

Line 2583: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2579: l_proc_name VARCHAR2(150);
2580: l_date_earned DATE;
2581: l_prev_month DATE;
2582: l_no_of_runs NUMBER;
2583: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2585:
2586: l_phf_si_type VARCHAR2(50);
2587: l_start_date DATE;

Line 2607: , pay_defined_balances defined

2603: --
2604: SELECT defined.defined_balance_id
2605: FROM pay_balance_types bal
2606: , pay_balance_dimensions dim
2607: , pay_defined_balances defined
2608: WHERE bal.legislation_code = 'CN'
2609: AND bal.balance_name = p_balance_name
2610: AND dim.legislation_code = 'CN'
2611: AND dim.dimension_name = p_balance_dimension