DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_CLEAR1 dependencies on DUAL

Line 118: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;

114: AND pgroup_id is null ; -- FOR SEPA ER 6700007
115: --AND a.application_id = 261;
116: --AND NVL(a.reconciled_status_flag, 'N') = 'N';
117:
118: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
119:
120: FUNCTION body_revision RETURN VARCHAR2 IS
121: BEGIN
122:

Line 1320: from dual;

1316: --set this in the form mo_global.set_policy_context('S',x_org_id);
1317:
1318: select mo_global.GET_CURRENT_ORG_ID
1319: into current_org_id
1320: from dual;
1321:
1322: IF l_DEBUG in ('Y', 'C') THEN
1323: cep_standard.debug('current_org_id =' ||current_org_id );
1324:

Line 2798: from dual;

2794:
2795: IF (org_id is not null) THEN
2796: select mo_global.GET_CURRENT_ORG_ID
2797: into current_org_id
2798: from dual;
2799:
2800: IF l_DEBUG in ('Y', 'C') THEN
2801: cep_standard.debug('current_org_id =' ||current_org_id );
2802: END IF;

Line 2814: from dual;

2810: END IF;
2811:
2812: select mo_global.GET_CURRENT_ORG_ID
2813: into current_org_id
2814: from dual;
2815:
2816: IF l_DEBUG in ('Y', 'C') THEN
2817: cep_standard.debug('current_org_id =' ||current_org_id );
2818: END IF;