DBA Data[Home] [Help]

APPS.AMW_CONTROLS_PAGE_PKG dependencies on DUAL

Line 417: select amw_control_objectives_s.nextval into l_control_objective_id from dual;

413: l_last_update_date := SYSDATE;
414: l_last_updated_by := FND_GLOBAL.USER_ID;
415: l_last_update_login := FND_GLOBAL.USER_ID;
416:
417: select amw_control_objectives_s.nextval into l_control_objective_id from dual;
418:
419: insert into amw_control_objectives (control_objective_id,
420: control_rev_id,
421: objective_code,

Line 511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;

507: l_last_update_date := SYSDATE;
508: l_last_updated_by := FND_GLOBAL.USER_ID;
509: l_last_update_login := FND_GLOBAL.USER_ID;
510:
511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;
512:
513: insert into amw_control_assertions (control_assertion_id,
514: control_rev_id,
515: assertion_code,

Line 606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;

602: l_last_update_date := SYSDATE;
603: l_last_updated_by := FND_GLOBAL.USER_ID;
604: l_last_update_login := FND_GLOBAL.USER_ID;
605:
606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
607:
608: insert into amw_assessment_components (assessment_component_id,
609: component_code,
610: object_type,