DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EOY_RL2_TRANS_INFO_V

Line 333: lr_rl2_transrec PAY_CA_EOY_RL2_TRANS_INFO_V%ROWTYPE;

329: /* Initialize static variables from different level
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;

Line 3412: select * from PAY_CA_EOY_RL2_TRANS_INFO_V

3408:
3409: /* Cursor to get the RL2 Transmitter and Employer Info */
3410: CURSOR cur_rl2_transmitter(cp_bg_id number,
3411: cp_pact_id number) IS
3412: select * from PAY_CA_EOY_RL2_TRANS_INFO_V
3413: where business_group_id = cp_bg_id
3414: and payroll_action_id = cp_pact_id;
3415:
3416: /* Cursor to get the RL2 Employee Info */