APPS.FV_FACTS1_GL_PKG dependencies on GL_JE_HEADERS

Line 21: gbl_header_id gl_je_headers.je_header_id%type := 0;

17: gbl_period_num_high gl_period_statuses.period_num%TYPE;
18: gbl_period_year gl_period_statuses.period_year%TYPE;
19: gbl_exception_rec_count NUMBER;
20: gbl_called_from_main VARCHAR2(1);
21: gbl_header_id gl_je_headers.je_header_id%type := 0;
22: gbl_trading_partner_att fv_be_trx_dtls.attribute1%TYPE;
23: gbl_manual_source_flag VARCHAR2(1) := 'N';
24: TYPE party_info_rec
25: IS

Line 371: TABLE OF gl_je_headers.je_header_id%TYPE;

367: CURSOR ;
368: l_gl_lines_cur t_ref_cur ;
369: TYPE je_header_id_t
370: IS
371: TABLE OF gl_je_headers.je_header_id%TYPE;
372: TYPE je_category_t
373: IS
374: TABLE OF gl_je_headers.je_category%TYPE;
375: TYPE je_source_t

Line 374: TABLE OF gl_je_headers.je_category%TYPE;

370: IS
371: TABLE OF gl_je_headers.je_header_id%TYPE;
372: TYPE je_category_t
373: IS
374: TABLE OF gl_je_headers.je_category%TYPE;
375: TYPE je_source_t
376: IS
377: TABLE OF gl_je_headers.je_source%TYPE;
378: TYPE je_line_num_t

Line 377: TABLE OF gl_je_headers.je_source%TYPE;

373: IS
374: TABLE OF gl_je_headers.je_category%TYPE;
375: TYPE je_source_t
376: IS
377: TABLE OF gl_je_headers.je_source%TYPE;
378: TYPE je_line_num_t
379: IS
380: TABLE OF gl_je_lines.je_line_num%TYPE;
381: TYPE sob_id_t

Line 443: TABLE OF gl_je_headers.je_batch_id%TYPE;

439: IS
440: TABLE OF VARCHAR2(1);
441: TYPE je_batch_id_t
442: IS
443: TABLE OF gl_je_headers.je_batch_id%TYPE;
444: je_header_id_list_new je_header_id_t;
445: je_header_id_list je_header_id_t;
446: je_category_list je_category_t;
447: je_source_list je_source_t;

Line 519: gl_je_headers gjh

515: AND ledger_id = gbl_sob_id
516: AND period_num BETWEEN gbl_period_num_low AND gbl_period_num_high
517: AND period_year = gbl_period_year
518: ) gps,
519: gl_je_headers gjh
520: WHERE gjh.period_name = gps.period_name
521: AND gjh.ledger_id = gbl_sob_id
522: AND gjh.status = 'P'
523: AND gjh.actual_flag = 'A'

Line 577: gl_je_headers gjh

573: AND ledger_id = :gbl_sob_id
574: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
575: AND period_year = :gbl_period_year ) gps,
576: gl_je_lines gjl,
577: gl_je_headers gjh
578: WHERE fff.jc_flag = ''N''
579: AND fff.set_of_books_id = :gbl_sob_id
580: AND fff.fiscal_year = :gbl_period_year
581: AND glcc.'||gbl_acc_segment ||

Line 604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt

600: gbl_sob_id;
601: fv_utility.log_mesg('Running in full mode');
602: fv_utility.log_mesg(l_select_stmt);
603: ELSE
604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt

Line 609: , gl_je_headers gjh

605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt
609: , gl_je_headers gjh
610: , gl_je_lines gjl
611: , (SELECT period_num
612: , period_name
613: FROM gl_period_statuses ps

Line 1003: gl_je_headers jh ,

999: )
1000: IS
1001: SELECT e.vendor_id ven_id
1002: FROM gl_je_lines je ,
1003: gl_je_headers jh ,
1004: pa_cost_distribution_lines_all cdl,
1005: pa_expenditure_items_all ei ,
1006: pa_expenditures_all e
1007: WHERE je.je_header_id = jh.je_header_id

Line 1614: gl_je_headers h,

1610: substr(rpad(h.je_category, 15, '' ''),1,15) || '' '' ||
1611: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||
1612: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1613: to_char( amount,''99,999,999,999,999,999.99'') ' || ' FROM fv_facts1_header_id_gt f ,
1614: gl_je_headers h,
1615: fv_facts1_line_balances l,
1616: gl_je_batches b
1617: where h.je_header_id = f.je_header_id
1618: and l.je_header_id = h.je_header_id