eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on DUAL

Line 1182: FROM DUAL;

1178: END;
1179:
1180: SELECT DECODE(l_acct_code, 'A', '01', 'L','02', 'O','03', 'E','04', 'R','04',null)
1181: INTO l_acct_code_value
1182: FROM DUAL;
1183:
1184: ELSE
1185:
1186: SELECT DECODE (l_sped_code, 'C', '05', 'T','09',null)

Line 1188: FROM DUAL;

1184: ELSE
1185:
1186: SELECT DECODE (l_sped_code, 'C', '05', 'T','09',null)
1187: INTO l_sped_code_value
1188: FROM DUAL;
1189:
1190: END IF;
1191:
1192: RETURN NVL(l_sped_code_value,l_acct_code_value);

Line 1269: FROM dual

1265:
1266: BEGIN
1267: SELECT 1 --if no data found means, no active relation in the report period.
1268: INTO l_partic_active_flag
1269: FROM dual
1270: WHERE EXISTS ( SELECT 1 FROM jl_br_sped_partic_rel rel
1271: WHERE rel.LEGAL_ENTITY_ID = g_legal_entity_id
1272: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1273: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify

Line 1597: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

1593: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
1594: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
1595: AND rownum=1;
1596:
1597: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');

Line 1749: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

1745: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
1746: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
1747: AND rownum=1;
1748:
1749: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');

Line 2218: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

2214: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
2215: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
2216: AND rownum=1;
2217:
2218: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
2219:
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of LE');

Line 2561: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

2557: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
2558: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
2559: AND rownum=1;
2560:
2561: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
2562:
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of ESTB');

Line 3443: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

3439: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
3440: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
3441: AND rownum=1;
3442:
3443: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
3444:
3445: EXCEPTION
3446: WHEN OTHERS THEN
3447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');

Line 3603: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;

3599: AND nvl(reg.effective_from,to_date('01-01-1950','DD-MM-YYYY')) <= g_start_date
3600: AND (reg.effective_to IS NULL OR reg.effective_to >= g_end_date)
3601: AND rownum=1;
3602:
3603: SELECT decode(length(l_cnpj),15,substr(l_cnpj,2,14),l_cnpj) into l_cnpj from dual;
3604:
3605: EXCEPTION
3606: WHEN OTHERS THEN
3607: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');

Line 8747: FROM DUAL;

8743:
8744: IF substrb(g_bookkeeping_type,1,1) <> 'G' THEN
8745:
8746: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8747: FROM DUAL;
8748:
8749: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I015 for Integrated Receiving system');
8750: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);
8751:

Line 8775: FROM DUAL;

8771: ,g_bookkeeping_type
8772: ,g_concurrent_request_id);
8773:
8774: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8775: FROM DUAL;
8776:
8777: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8778: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8779: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Ending Sequence Value :'||l_sequence_value);

Line 8857: FROM DUAL;

8853:
8854: IF substrb(g_bookkeeping_type,1,1) <> 'B' THEN
8855:
8856: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8857: FROM DUAL;
8858:
8859: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I200 and I250 for Integrated Receiving system');
8860: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);
8861:

Line 8885: FROM DUAL;

8881: ,g_bookkeeping_type
8882: ,g_concurrent_request_id);
8883:
8884: SELECT jl_br_sped_extr_data_t_s.CURRVAL INTO l_sequence_value
8885: FROM DUAL;
8886:
8887: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8888: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8889: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Ending Sequence Value :'||l_sequence_value);