DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRX dependencies on FV_FACTS_PRC_DTL

Line 3442: FROM fv_facts_prc_dtl

3438:
3439: BEGIN
3440: SELECT reporting_code, reporting_desc
3441: INTO vl_prc_val, vl_prc_desc
3442: FROM fv_facts_prc_dtl
3443: WHERE prc_header_id = vl_prc_header_id
3444: AND program_value = vl_program_val
3445: AND set_of_books_id = vp_set_of_books_id;
3446:

Line 3463: FROM fv_facts_prc_dtl

3459: IF vl_prc_found = 'N' THEN
3460: BEGIN
3461: SELECT reporting_code, reporting_desc
3462: INTO vl_prc_val, vl_prc_desc
3463: FROM fv_facts_prc_dtl
3464: WHERE prc_header_id = vl_prc_header_id
3465: AND program_value = 'ALL'
3466: AND set_of_books_id = vp_set_of_books_id;
3467: