DBA Data[Home] [Help]

APPS.EAM_OP_COMP_DEFAULT_PVT dependencies on DUAL

Line 38: FROM DUAL;

34:
35: IF p_eam_op_comp_rec.transaction_id IS NULL THEN
36: SELECT eam_op_completion_txns_s.nextval
37: INTO x_eam_op_comp_rec.transaction_id
38: FROM DUAL;
39: END IF;
40:
41: IF p_eam_op_comp_rec.qa_collection_id IS NULL THEN
42: SELECT qa_collection_id_s.nextval

Line 44: FROM DUAL;

40:
41: IF p_eam_op_comp_rec.qa_collection_id IS NULL THEN
42: SELECT qa_collection_id_s.nextval
43: INTO x_eam_op_comp_rec.qa_collection_id
44: FROM DUAL;
45: END IF;
46:
47: IF p_eam_op_comp_rec.transaction_date IS NULL THEN
48: SELECT sysdate

Line 50: FROM DUAL;

46:
47: IF p_eam_op_comp_rec.transaction_date IS NULL THEN
48: SELECT sysdate
49: INTO x_eam_op_comp_rec.transaction_date
50: FROM DUAL;
51: END IF;
52:
53: IF p_eam_op_comp_rec.actual_start_date IS NOT NULL AND
54: p_eam_op_comp_rec.actual_end_date IS NOT NULL AND