DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;

90: l_alc_code VARCHAR2(12);
91: flex_num NUMBER ;
92: x_name VARCHAR2(100);
93:
94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;
95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;
97: l_document_number VARCHAR2(100);
98:

Line 95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

91: flex_num NUMBER ;
92: x_name VARCHAR2(100);
93:
94: l_je_source GL_JE_HEADERS.JE_SOURCE%TYPE;
95: l_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
96: l_je_from_sla_flag FV_SF224_TEMP.JE_FROM_SLA_FLAG%TYPE;
97: l_document_number VARCHAR2(100);
98:
99: --Define variable to store the end date for the transaction period

Line 1866: gl_je_headers glh,

1862: glh.je_source,
1863: glh.je_category,
1864: glh.je_from_sla_flag
1865: FROM gl_je_batches glb,
1866: gl_je_headers glh,
1867: gl_je_lines gll,
1868: gl_code_combinations gcc,
1869: fv_report_definitions frd,
1870: fv_fund_parameters ffp,

Line 1952: gl_je_headers glh,

1948: glh.je_source,
1949: glh.je_category,
1950: glh.je_from_sla_flag
1951: FROM gl_je_batches glb,
1952: gl_je_headers glh,
1953: gl_je_lines gll,
1954: gl_code_combinations gcc,
1955: fv_report_definitions frd,
1956: fv_fund_parameters ffp,

Line 2065: gl_je_headers glh,

2061: glh.je_source,
2062: glh.je_category,
2063: glh.je_from_sla_flag
2064: FROM gl_je_batches glb,
2065: gl_je_headers glh,
2066: gl_je_lines gll,
2067: gl_code_combinations gcc,
2068: fv_report_definitions frd,
2069: fv_fund_parameters ffp,

Line 2175: gl_je_headers glh,

2171: glh.je_source,
2172: glh.je_category,
2173: glh.je_from_sla_flag
2174: FROM gl_je_batches glb,
2175: gl_je_headers glh,
2176: gl_je_lines gll,
2177: gl_code_combinations gcc,
2178: fv_report_definitions frd,
2179: fv_fund_parameters ffp,

Line 2287: gl_je_headers glh,

2283: glh.je_category,
2284: glh.je_from_sla_flag
2285:
2286: FROM gl_je_batches glb,
2287: gl_je_headers glh,
2288: gl_je_lines gll,
2289: gl_code_combinations gcc,
2290: fv_report_definitions frd,
2291: fv_fund_parameters ffp,

Line 2394: gl_je_headers glh,

2390: glh.je_source,
2391: glh.je_category,
2392: glh.je_from_sla_flag
2393: FROM gl_je_batches glb,
2394: gl_je_headers glh,
2395: gl_je_lines gll,
2396: gl_code_combinations gcc,
2397: fv_report_definitions frd,
2398: fv_fund_parameters ffp,

Line 2506: gl_je_headers glh,

2502: glh.je_source,
2503: glh.je_category,
2504: glh.je_from_sla_flag
2505: FROM gl_je_batches glb,
2506: gl_je_headers glh,
2507: gl_je_lines gll,
2508: gl_code_combinations gcc,
2509: fv_report_definitions frd,
2510: fv_fund_parameters ffp,

Line 2619: gl_je_headers glh,

2615: glh.je_source,
2616: glh.je_category,
2617: glh.je_from_sla_flag
2618: FROM gl_je_batches glb,
2619: gl_je_headers glh,
2620: gl_je_lines gll,
2621: gl_code_combinations gcc,
2622: fv_report_definitions frd,
2623: fv_fund_parameters ffp,

Line 3033: FROM gl_je_headers

3029: WHERE check_id = TO_NUMBER(l_reference_3);
3030: EXCEPTION WHEN NO_DATA_FOUND THEN
3031: SELECT SUBSTR(name,1,50)
3032: INTO l_document_number
3033: FROM gl_je_headers
3034: WHERE je_header_id = l_je_header_id;
3035: END;
3036: IF l_reference_1 IS NULL AND l_reference_6 IS NULL Then -- ref1
3037: x_name := 'Blank Treasury confirmation Id' ;

Line 3075: FROM gl_je_headers

3071: COMMIT;
3072: -- Get document number
3073: SELECT SUBSTR(name,1,50)
3074: INTO l_document_number
3075: FROM gl_je_headers
3076: WHERE je_header_id = l_je_header_id;
3077: l_cursor_id := dbms_sql.open_cursor;
3078: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3079: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

Line 3127: FROM gl_je_headers

3123: COMMIT;
3124: -- Get document number
3125: SELECT SUBSTR(name,1,50)
3126: INTO l_document_number
3127: FROM gl_je_headers
3128: WHERE je_header_id = l_je_header_id;
3129: l_cursor_id := dbms_sql.open_cursor;
3130: dbms_sql.parse(l_cursor_id, l_select, dbms_sql.v7);
3131: dbms_sql.bind_variable(l_cursor_id,':b_reference_1',l_reference_1);

Line 3177: FROM gl_je_headers

3173: WHERE invoice_id = TO_NUMBER(l_reference_2);
3174: EXCEPTION WHEN NO_DATA_FOUND THEN
3175: SELECT SUBSTR(name,1,50)
3176: INTO l_document_number
3177: FROM gl_je_headers
3178: WHERE je_header_id = l_je_header_id;
3179: END;
3180: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Document_Num => ' || l_document_number);

Line 3399: FROM gl_je_headers

3395: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3396: EXCEPTION WHEN NO_DATA_FOUND THEN
3397: SELECT SUBSTR(name,1,50)
3398: INTO l_document_number
3399: FROM gl_je_headers
3400: WHERE je_header_id = l_je_header_id;
3401: END;
3402:
3403: ELSIF(l_je_category = 'Treasury Confirmation' AND

Line 3415: FROM gl_je_headers

3411: EXCEPTION
3412: WHEN NO_DATA_FOUND THEN
3413: SELECT SUBSTR(name,1,50)
3414: INTO l_document_number
3415: FROM gl_je_headers
3416: WHERE je_header_id = l_je_header_id;
3417: END;
3418: IF l_reference_3 IS NULL then
3419: x_name := 'Blank Check Id ' ;

Line 3460: FROM gl_je_headers

3456: x_name := l_name;
3457: l_name := 'MANUAL';
3458: SELECT SUBSTR(name,1,50)
3459: INTO l_document_number
3460: FROM gl_je_headers
3461: WHERE je_header_id = l_je_header_id;
3462: END IF; -- source1
3463:
3464: ---------------------------------------------------------------------------

Line 5485: gl_je_headers gljh,

5481: ( SELECT 1 FROM fv_refunds_voids_all
5482: WHERE invoice_payment_id = apip.invoice_payment_id)
5483: AND EXISTS (SELECT 1
5484: FROM gl_je_lines gljl,
5485: gl_je_headers gljh,
5486: ap_invoice_distributions_all apid
5487: WHERE gljl.ledger_id = apid.set_of_books_id
5488: AND gljl.status = 'P'
5489: AND gljh.je_header_id = gljl.je_header_id

Line 5497: gl_je_headers gljh,

5493: AND gljl.reference_2 = TO_CHAR(api.invoice_id)
5494: UNION
5495: SELECT 1
5496: FROM gl_je_lines gljl,
5497: gl_je_headers gljh,
5498: gl_import_references glir,
5499: xla_ae_lines xal,
5500: xla_distribution_links xdl,
5501: ap_invoice_distributions_all apid