APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2106: select pay_assignment_actions_s.nextval

2102: end if;
2103:
2104: /* 5676928 End */
2105: -- end loop;
2106: select pay_assignment_actions_s.nextval
2107: into l_assact_id
2108: from dual;
2109:
2110: hr_nonrun_asact.insact (

Line 2338: pay_assignment_actions assg,

2334: action_information19,
2335: fnd_date.canonical_to_date (action_information20)
2336: action_information20
2337: from pay_payroll_actions paa,
2338: pay_assignment_actions assg,
2339: pay_action_information pai
2340: where paa.payroll_action_id = p_payroll_action_id
2341: and assg.payroll_action_id = paa.payroll_action_id
2342: and pai.action_context_id = assg.assignment_action_id

Line 2358: pay_assignment_actions assg,

2354: p_local_unit_id varchar2
2355: ) is
2356: select count (*)
2357: from pay_payroll_actions paa,
2358: pay_assignment_actions assg,
2359: pay_action_information pai
2360: where paa.payroll_action_id = p_payroll_action_id
2361: and assg.payroll_action_id = paa.payroll_action_id
2362: and pai.action_context_id = assg.assignment_action_id