APPS.FV_1219_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 37: l_je_header_id gl_je_headers.je_header_id%TYPE;

33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;
35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:
37: l_je_header_id gl_je_headers.je_header_id%TYPE;
38: l_je_line_num gl_je_lines.je_line_num%TYPE;
39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;
40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;

Line 616: gl_je_headers glh,

612: gll.je_header_id,
613: gll.je_line_num,
614: glh.je_from_sla_flag
615: FROM gl_je_batches glb,
616: gl_je_headers glh,
617: gl_je_lines gll,
618: gl_code_combinations gcc,
619: fv_sf1219_definitions_accts fda,
620: fv_fund_parameters ffp,

Line 771: gl_je_headers glh,

767: gll.je_header_id,
768: gll.je_line_num,
769: glh.je_from_sla_flag
770: FROM gl_je_batches glb,
771: gl_je_headers glh,
772: gl_je_lines gll,
773: gl_code_combinations gcc,
774: fv_sf1219_definitions_accts fda,
775: fv_fund_parameters ffp,

Line 950: gl_je_headers glh,

946: gll.je_header_id,
947: gll.je_line_num,
948: glh.je_from_sla_flag
949: FROM gl_je_batches glb,
950: gl_je_headers glh,
951: gl_je_lines gll,
952: gl_code_combinations gcc,
953: fv_sf1219_definitions_accts fda,
954: fv_fund_parameters ffp,

Line 1130: gl_je_headers glh,

1126: gll.je_header_id,
1127: gll.je_line_num,
1128: glh.je_from_sla_flag
1129: FROM gl_je_batches glb,
1130: gl_je_headers glh,
1131: gl_je_lines gll,
1132: gl_code_combinations gcc,
1133: fv_sf1219_definitions_accts fda,
1134: fv_fund_parameters ffp,

Line 1307: gl_je_headers glh,

1303: gll.je_header_id,
1304: gll.je_line_num,
1305: glh.je_from_sla_flag
1306: FROM gl_je_batches glb,
1307: gl_je_headers glh,
1308: gl_je_lines gll,
1309: gl_code_combinations gcc,
1310: fv_sf1219_definitions_accts fda,
1311: fv_fund_parameters ffp,

Line 1483: gl_je_headers glh,

1479: gll.je_header_id,
1480: gll.je_line_num,
1481: glh.je_from_sla_flag
1482: FROM gl_je_batches glb,
1483: gl_je_headers glh,
1484: gl_je_lines gll,
1485: gl_code_combinations gcc,
1486: fv_sf1219_definitions_accts fda,
1487: fv_fund_parameters ffp,

Line 1664: gl_je_headers glh,

1660: gll.je_header_id,
1661: gll.je_line_num,
1662: glh.je_from_sla_flag
1663: FROM gl_je_batches glb,
1664: gl_je_headers glh,
1665: gl_je_lines gll,
1666: gl_code_combinations gcc,
1667: fv_sf1219_definitions_accts fda,
1668: fv_fund_parameters ffp,

Line 1844: gl_je_headers glh,

1840: gll.je_header_id,
1841: gll.je_line_num,
1842: glh.je_from_sla_flag
1843: FROM gl_je_batches glb,
1844: gl_je_headers glh,
1845: gl_je_lines gll,
1846: gl_code_combinations gcc,
1847: fv_sf1219_definitions_accts fda,
1848: fv_fund_parameters ffp,

Line 2025: v_je_source gl_je_headers.je_source%TYPE;

2021: PROCEDURE PROCESS_1219_TRANSACTIONS IS
2022: l_module_name VARCHAR2(200);
2023: l_reference NUMBER;
2024: l_org_amount NUMBER;
2025: v_je_source gl_je_headers.je_source%TYPE;
2026: v_je_category gl_je_headers.je_category%TYPE;
2027: l_rev_cash_recpt_id gl_je_lines.reference_2%TYPE;
2028: l_exists VARCHAR2(1);
2029: vl_misc_cd_flag VARCHAR2(1) := 'N';

Line 2026: v_je_category gl_je_headers.je_category%TYPE;

2022: l_module_name VARCHAR2(200);
2023: l_reference NUMBER;
2024: l_org_amount NUMBER;
2025: v_je_source gl_je_headers.je_source%TYPE;
2026: v_je_category gl_je_headers.je_category%TYPE;
2027: l_rev_cash_recpt_id gl_je_lines.reference_2%TYPE;
2028: l_exists VARCHAR2(1);
2029: vl_misc_cd_flag VARCHAR2(1) := 'N';
2030: p_def_p_ia_paygroup VARCHAR2(30);

Line 2262: FROM gl_je_headers

2258: -- Get journal source and category
2259: BEGIN
2260: SELECT je_source, je_category
2261: INTO v_je_source, v_je_category
2262: FROM gl_je_headers
2263: WHERE je_header_id = l_je_header_id;
2264: EXCEPTION
2265: WHEN OTHERS THEN
2266: p_error_code := -1;