APPS.FV_PO_VALIDATE_GRP dependencies on FV_FUND_PARAMETERS

Line 48: l_fund_category fv_fund_parameters.fund_category%TYPE;

44: l_stmt VARCHAR2(500);
45: l_profile_value VARCHAR2(1);
46: l_warning VARCHAR2(1);
47: l_ccid NUMBER(15);
48: l_fund_category fv_fund_parameters.fund_category%TYPE;
49: l_start_dt VARCHAR2(150);
50: l_end_dt VARCHAR2(150);
51: l_bal_seg_name VARCHAR2(30);
52: l_expiration_date DATE;

Line 125: FROM fv_fund_parameters fp,

121:
122: BEGIN
123: SELECT fund_category, fts.expiration_date
124: INTO l_fund_category , l_expiration_date
125: FROM fv_fund_parameters fp,
126: fv_treasury_symbols fts
127: WHERE fp.fund_value = l_fund_value
128: and fts.treasury_symbol_id = fp.treasury_symbol_id
129: AND fts.set_of_books_id = x_ledger_id ;