APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 262: lr_rl2_emprec PAY_CA_EOY_RL2_EMPLOYEE_INFO_V%ROWTYPE;

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
266: if lv_type = 'E' then

Line 3050: select * from PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

3046:
3047: /* Cursor to get the RL2 Employee Info */
3048: CURSOR cur_rl2_employee(cp_bg_id number,
3049: cp_asgact_id number) IS
3050: select * from PAY_CA_EOY_RL2_EMPLOYEE_INFO_V
3051: where business_group_id = cp_bg_id
3052: and assignment_action_id = cp_asgact_id;
3053:
3054: cursor cur_rl_nonbox_footnote(cp_asgact_id number) is