DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_PRC_DTL

Line 5159: FROM fv_facts_prc_dtl

5155: BEGIN
5156:
5157: SELECT LPAD(TO_CHAR(reporting_code), 3, '0'), reporting_desc
5158: INTO vl_prc_val, vl_prc_desc
5159: FROM fv_facts_prc_dtl
5160: WHERE prc_header_id = vl_prc_header_id
5161: AND program_value = vl_program_val
5162: AND set_of_books_id = vp_set_of_books_id;
5163:

Line 5175: FROM fv_facts_prc_dtl

5171: BEGIN
5172:
5173: SELECT LPAD(TO_CHAR(reporting_code), 3, '0'), reporting_desc
5174: INTO vl_prc_val, vl_prc_desc
5175: FROM fv_facts_prc_dtl
5176: WHERE prc_header_id = vl_prc_header_id
5177: AND program_value = 'ALL'
5178: AND set_of_books_id = vp_set_of_books_id;
5179: