APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EOY_RL2_TRANS_INFO_V

Line 261: lr_rl2_transrec PAY_CA_EOY_RL2_TRANS_INFO_V%ROWTYPE;

257: /* Initialize static variables from different level
258: lv_type = E Employee Level, lv_type = R Employer level */
259:
260: /* RL2 Employer and Employee records */
261: lr_rl2_transrec PAY_CA_EOY_RL2_TRANS_INFO_V%ROWTYPE;
262: lr_rl2_emprec PAY_CA_EOY_RL2_EMPLOYEE_INFO_V%ROWTYPE;
263:
264: procedure initialize_static_var ( lv_type in varchar2 ) is
265: begin

Line 3043: select * from PAY_CA_EOY_RL2_TRANS_INFO_V

3039:
3040: /* Cursor to get the RL2 Transmitter and Employer Info */
3041: CURSOR cur_rl2_transmitter(cp_bg_id number,
3042: cp_pact_id number) IS
3043: select * from PAY_CA_EOY_RL2_TRANS_INFO_V
3044: where business_group_id = cp_bg_id
3045: and payroll_action_id = cp_pact_id;
3046:
3047: /* Cursor to get the RL2 Employee Info */