APPS.JAI_OPEN_API_PKG dependencies on DUAL

Line 486: FROM DUAL

482: CURSOR chk_ccid_cur
483: IS
484: SELECT
485: 'Y'
486: FROM DUAL
487: WHERE EXISTS
488: (
489: SELECT '1'
490: FROM GL_CODE_COMBINATIONS_V

Line 2707: FROM dual

2703: WHERE INTERNAL_TRX_ID = cn_trx_id;
2704:
2705: CURSOR get_vat_tax_exists_cur(cn_trx_id IN NUMBER) IS
2706: SELECT 'Y'
2707: FROM dual
2708: WHERE EXISTS (SELECT 1
2709: FROM jai_cmn_taxes_all jcta,
2710: jai_interface_tax_lines_all jitla,
2711: jai_interface_lines_all jila

Line 2725: FROM dual

2721: WHERE jrd.regime_code = jai_constants.vat_regime)));
2722:
2723: CURSOR get_excise_tax_exists_cur(cn_trx_id IN NUMBER) IS
2724: SELECT 'Y'
2725: FROM dual
2726: WHERE EXISTS (SELECT 1
2727: FROM jai_cmn_taxes_all jcta,
2728: jai_interface_tax_lines_all jitla,
2729: jai_interface_lines_all jila

Line 2824: FROM dual

2820: WHERE INTERNAL_TRX_ID = cn_trx_id;
2821:
2822: CURSOR get_service_tax_exists_cur(cn_trx_id IN NUMBER) IS
2823: SELECT 'Y'
2824: FROM dual
2825: WHERE EXISTS (SELECT 1
2826: FROM jai_cmn_taxes_all jcta,
2827: jai_interface_tax_lines_all jitla,
2828: jai_interface_lines_all jila

Line 3407: FROM dual

3403: BEGIN
3404: IF pv_import_module = 'AP' THEN
3405: SELECT 'Y'
3406: INTO lv_import_flag
3407: FROM dual
3408: WHERE EXISTS (SELECT 1
3409: FROM ap_invoice_lines_all
3410: WHERE invoice_id = pn_trx_id
3411: AND line_number = pn_trx_line_id

Line 3419: FROM dual

3415: ELSIF pv_import_module = 'AR' THEN
3416: /*--Commented by zhiwei for Bug#12565170 begin
3417: SELECT 'Y'
3418: INTO lv_import_flag
3419: FROM dual
3420: WHERE EXISTS (SELECT 1
3421: FROM ra_customer_trx_lines_all
3422: WHERE customer_trx_id = pn_trx_id
3423: AND customer_trx_line_id = pn_trx_line_id

Line 3433: FROM dual

3429: --Added by zhiwei for Bug#12565170 begin
3430: ---------------------------------------------------------------
3431: SELECT 'Y'
3432: INTO lv_import_flag
3433: FROM dual
3434: WHERE EXISTS (SELECT 1
3435: FROM ra_customer_trx_all head, ra_customer_trx_lines_all line
3436: WHERE line.customer_trx_id = pn_trx_id
3437: AND line.customer_trx_line_id = pn_trx_line_id

Line 8044: FROM dual

8040: WHERE INTERFACE_LINE_ID = pn_interface_line_id;
8041:
8042: CURSOR get_vat_tax_exists_cur IS
8043: SELECT 'Y'
8044: FROM dual
8045: WHERE EXISTS (SELECT 1
8046: FROM jai_cmn_taxes_all jcta,
8047: jai_interface_tax_lines_all jitla,
8048: jai_interface_lines_all jila

Line 8072: FROM dual

8068: WHERE jrd.regime_code = jai_constants.vat_regime)));
8069:
8070: CURSOR get_excise_tax_exists_cur IS
8071: SELECT 'Y'
8072: FROM dual
8073: WHERE EXISTS (SELECT 1
8074: FROM jai_cmn_taxes_all jcta,
8075: jai_interface_tax_lines_all jitla,
8076: jai_interface_lines_all jila

Line 8133: FROM dual

8129:
8130: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 Begin*/
8131: CURSOR get_service_tax_exists_cur IS
8132: SELECT 'Y'
8133: FROM dual
8134: WHERE EXISTS (SELECT 1
8135: FROM jai_cmn_taxes_all jcta,
8136: jai_interface_tax_lines_all jitla,
8137: jai_interface_lines_all jila