APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_CONTROL_ASSOCIATIONS_S

Line 1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;

1179:
1180: exception
1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);

Line 1782: select amw_control_associations_s.nextval into l_control_association_id from dual;

1778: and pk1=l_risk_association_id
1779: and control_id=l_aca_row.control_id;
1780:
1781: if row_count = 0 then
1782: select amw_control_associations_s.nextval into l_control_association_id from dual;
1783:
1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');
1785: ----------------------dbms_output.put_line('control_association_id: '||l_control_association_id);
1786: insert into amw_control_associations(control_association_id,last_update_date,