APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_PROCESSED_JE_HDRS

Line 526: FROM fv_facts1_processed_je_hdrs e

522: AND gjh.status = 'P'
523: AND gjh.actual_flag = 'A'
524: AND NOT EXISTS
525: (SELECT 'x'
526: FROM fv_facts1_processed_je_hdrs e
527: WHERE e.set_of_books_id = gjh.ledger_id
528: AND e.je_header_id = gjh.je_header_id
529: ) ;
530:

Line 1680: INSERT INTO fv_facts1_processed_je_hdrs

1676: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
1677: FV_UTILITY.LOG_MESG('In '||l_module_name);
1678: fv_utility.log_mesg('Inserting processed headers ' );
1679: IF gbl_called_from_main = 'Y' THEN
1680: INSERT INTO fv_facts1_processed_je_hdrs
1681: (je_header_id,set_of_books_id
1682: )
1683: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1684: ELSE

Line 1685: INSERT INTO fv_facts1_processed_je_hdrs

1681: (je_header_id,set_of_books_id
1682: )
1683: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1684: ELSE
1685: INSERT INTO fv_facts1_processed_je_hdrs
1686: (je_header_id,set_of_books_id
1687: )
1688: SELECT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1689: END IF;