DBA Data[Home] [Help]

APPS.PV_BENFT_STATUS_CHANGE dependencies on FND_LOOKUP_VALUES_VL

Line 1901: select b.meaning from pv_referrals_b a, FND_LOOKUP_VALUES_VL b

1897: document in out nocopy varchar2,
1898: document_type in out nocopy varchar2) IS
1899:
1900: cursor lc_get_reason (pc_entity_id number) is
1901: select b.meaning from pv_referrals_b a, FND_LOOKUP_VALUES_VL b
1902: where a.referral_id = pc_entity_id
1903: and a.decline_reason_code = b.lookup_code
1904: and b.lookup_type = 'PV_REFERRAL_DECLINE_REASON';
1905: