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 1299: from dual;

1295: --set this in the form mo_global.set_policy_context('S',x_org_id);
1296:
1297: select mo_global.GET_CURRENT_ORG_ID
1298: into current_org_id
1299: from dual;
1300:
1301: IF l_DEBUG in ('Y', 'C') THEN
1302: cep_standard.debug('current_org_id =' ||current_org_id );
1303:

Line 2711: from dual;

2707:
2708: IF (org_id is not null) THEN
2709: select mo_global.GET_CURRENT_ORG_ID
2710: into current_org_id
2711: from dual;
2712:
2713: IF l_DEBUG in ('Y', 'C') THEN
2714: cep_standard.debug('current_org_id =' ||current_org_id );
2715: END IF;

Line 2727: from dual;

2723: END IF;
2724:
2725: select mo_global.GET_CURRENT_ORG_ID
2726: into current_org_id
2727: from dual;
2728:
2729: IF l_DEBUG in ('Y', 'C') THEN
2730: cep_standard.debug('current_org_id =' ||current_org_id );
2731: END IF;