APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on DUAL

Line 2576: select P_CERTIFICATION_ID, P_PROCESS_ID, -2, P_ORGANIZATION_ID, 1, sysdate, 1, sysdate, 1, null, 1 from dual);

2572: and start_date is not null and end_date is null
2573: CONNECT BY PRIOR CHILD_ID = PARENT_ID AND ORGANIZATION_ID = P_ORGANIZATION_ID
2574: and start_date is not null and end_date is null
2575: UNION
2576: select P_CERTIFICATION_ID, P_PROCESS_ID, -2, P_ORGANIZATION_ID, 1, sysdate, 1, sysdate, 1, null, 1 from dual);
2577: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
2578: /*
2579: select P_CERTIFICATION_ID, process_id, parent_child_id, organization_id, 1, sysdate, 1, sysdate, 1, null, 1
2580: from amw_org_hierarchy_denorm

Line 2637: SELECT P_CERTIFICATION_ID, P_PROCESS_ID, -1, P_ORGANIZATION_ID FROM DUAL);

2633: AND organization_id = P_ORGANIZATION_ID
2634: CONNECT BY prior child_id = parent_id
2635: AND prior organization_id = organization_id
2636: UNION ALL
2637: SELECT P_CERTIFICATION_ID, P_PROCESS_ID, -1, P_ORGANIZATION_ID FROM DUAL);
2638: -- sub processes of the process which directly links to the account
2639: ELSE
2640: INSERT INTO AMW_FIN_PROCESS_FLAT
2641: (CERTIFICATION_ID,

Line 6182: FROM DUAL;

6178: l_lob_code,
6179: l_cert_opinion_id,
6180: l_eval_opinion_log_id,
6181: l_cert_opinion_log_id
6182: FROM DUAL;
6183: END IF;
6184:
6185: end if; /***05.25.2006 npanandi: end of if clause for bug 5250100 testing***/
6186:

Line 7113: FROM DUAL;

7109: SYSDATE,
7110: SYSDATE,
7111: FND_GLOBAL.USER_ID,
7112: FND_GLOBAL.USER_ID
7113: FROM DUAL;
7114: END IF;
7115:
7116: if(p_commit <> FND_API.g_false)
7117: then commit;