APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 334: lr_rl2_emprec PAY_CA_EOY_RL2_EMPLOYEE_INFO_V%ROWTYPE;

330: lv_type = E Employee Level, lv_type = R Employer level */
331:
332: /* RL2 Employer and Employee records */
333: lr_rl2_transrec PAY_CA_EOY_RL2_TRANS_INFO_V%ROWTYPE;
334: lr_rl2_emprec PAY_CA_EOY_RL2_EMPLOYEE_INFO_V%ROWTYPE;
335:
336: /* Bug 15908332 */
337: further_info_count number;
338: TYPE FURTHER_CODES IS VARRAY(80) OF VARCHAR2(50);

Line 3419: select * from PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

3415:
3416: /* Cursor to get the RL2 Employee Info */
3417: CURSOR cur_rl2_employee(cp_bg_id number,
3418: cp_asgact_id number) IS
3419: select * from PAY_CA_EOY_RL2_EMPLOYEE_INFO_V
3420: where business_group_id = cp_bg_id
3421: and assignment_action_id = cp_asgact_id;
3422:
3423: cursor cur_rl_nonbox_footnote(cp_asgact_id number) is