DBA Data[Home] [Help]

APPS.EAM_WO_COMP_DEFAULT_PVT dependencies on DUAL

Line 42: FROM DUAL;

38: i_open_past_period :=FALSE;
39:
40: SELECT eam_job_completion_txns_s.nextval
41: INTO x_eam_wo_comp_rec.transaction_id
42: FROM DUAL;
43:
44: IF x_eam_wo_comp_rec.transaction_date IS NULL THEN
45: SELECT sysdate
46: INTO x_eam_wo_comp_rec.transaction_date

Line 47: FROM DUAL;

43:
44: IF x_eam_wo_comp_rec.transaction_date IS NULL THEN
45: SELECT sysdate
46: INTO x_eam_wo_comp_rec.transaction_date
47: FROM DUAL;
48: END IF;
49:
50: IF p_eam_wo_comp_rec.qa_collection_id IS NULL THEN
51: SELECT qa_collection_id_s.nextval

Line 53: FROM DUAL;

49:
50: IF p_eam_wo_comp_rec.qa_collection_id IS NULL THEN
51: SELECT qa_collection_id_s.nextval
52: INTO x_eam_wo_comp_rec.qa_collection_id
53: FROM DUAL;
54: END IF;
55:
56: invttmtx.tdatechk(p_eam_wo_comp_rec.organization_id,x_eam_wo_comp_rec.transaction_date,
57: x_eam_wo_comp_rec.acct_period_id,i_open_past_period);