DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1929: select pay_assignment_actions_s.nextval

1925: end if;
1926:
1927: /* 5676928 End */
1928: -- end loop;
1929: select pay_assignment_actions_s.nextval
1930: into l_assact_id
1931: from dual;
1932:
1933: hr_nonrun_asact.insact (

Line 2161: pay_assignment_actions assg,

2157: action_information19,
2158: fnd_date.canonical_to_date (action_information20)
2159: action_information20
2160: from pay_payroll_actions paa,
2161: pay_assignment_actions assg,
2162: pay_action_information pai
2163: where paa.payroll_action_id = p_payroll_action_id
2164: and assg.payroll_action_id = paa.payroll_action_id
2165: and pai.action_context_id = assg.assignment_action_id

Line 2181: pay_assignment_actions assg,

2177: p_local_unit_id varchar2
2178: ) is
2179: select count (*)
2180: from pay_payroll_actions paa,
2181: pay_assignment_actions assg,
2182: pay_action_information pai
2183: where paa.payroll_action_id = p_payroll_action_id
2184: and assg.payroll_action_id = paa.payroll_action_id
2185: and pai.action_context_id = assg.assignment_action_id