APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_PROCESSED_JE_HDRS

Line 555: and not exists (select 'x' from fv_facts1_processed_je_hdrs e

551: where gjh.period_name = gps.period_name
552: and gjh.ledger_id = gbl_sob_id
553: AND gjh.status = 'P'
554: AND gjh.actual_flag = 'A'
555: and not exists (select 'x' from fv_facts1_processed_je_hdrs e
556: where e.set_of_books_id = gjh.ledger_id
557: and e.je_header_id = gjh.je_header_id) ;
558:
559:

Line 1771: INSERT INTO fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)

1767:
1768: fv_utility.log_mesg('Inserting processed headers ' );
1769:
1770: IF gbl_called_from_main = 'Y' THEN
1771: INSERT INTO fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1772: SELECT DISTINCT je_header_id,set_of_books_id
1773: FROM fv_facts1_header_id_gt;
1774:
1775: ELSE

Line 1776: Insert into fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)

1772: SELECT DISTINCT je_header_id,set_of_books_id
1773: FROM fv_facts1_header_id_gt;
1774:
1775: ELSE
1776: Insert into fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1777: select je_header_id,set_of_books_id
1778: from fv_facts1_header_id_gt;
1779:
1780: END IF;