APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_PAYROLL_ACTIONS

Line 364: l_type pay_payroll_actions.action_type%TYPE;

360: l_flag varchar2(5);
361: l_insert_flag varchar2(5);
362: l_return_value number;
363: l_return_insert number;
364: l_type pay_payroll_actions.action_type%TYPE;
365: l_procedure VARCHAR2(22);
366:
367: /******************************************************************************
368: * Cursor to get the legislation code based on the Business Group Id.

Line 396: ,pay_payroll_actions pay

392:
393: CURSOR c_action_type_tu IS
394: SELECT pay.action_type
395: FROM pay_assignment_actions pac
396: ,pay_payroll_actions pay
397: WHERE pay.payroll_action_id = pac.payroll_action_id
398: AND pay.action_type IN ('Q','R','I')
399: AND pac.assignment_id = p_assignment_id
400: AND pac.action_status = 'C'

Line 420: ,pay_payroll_actions pay

416:
417: CURSOR c_action_type_bg IS
418: SELECT pay.action_type
419: FROM pay_assignment_actions pac
420: ,pay_payroll_actions pay
421: WHERE pay.payroll_action_id = pac.payroll_action_id
422: AND pay.business_group_id = p_business_group_id
423: AND pay.action_type IN ('Q','R','I')
424: AND pac.assignment_id = p_assignment_id