DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_PRC_DTL

Line 5083: FROM fv_facts_prc_dtl

5079: BEGIN
5080:
5081: SELECT LPAD(TO_CHAR(reporting_code), 3, '0'), reporting_desc
5082: INTO vl_prc_val, vl_prc_desc
5083: FROM fv_facts_prc_dtl
5084: WHERE prc_header_id = vl_prc_header_id
5085: AND program_value = vl_program_val
5086: AND set_of_books_id = vp_set_of_books_id;
5087:

Line 5099: FROM fv_facts_prc_dtl

5095: BEGIN
5096:
5097: SELECT LPAD(TO_CHAR(reporting_code), 3, '0'), reporting_desc
5098: INTO vl_prc_val, vl_prc_desc
5099: FROM fv_facts_prc_dtl
5100: WHERE prc_header_id = vl_prc_header_id
5101: AND program_value = 'ALL'
5102: AND set_of_books_id = vp_set_of_books_id;
5103: