DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_APPLICATION

Line 85: FROM fnd_application a, fnd_application_tl t, fnd_product_installations p

81: RETURN VARCHAR2 IS
82: l_product_release VARCHAR2(50);
83: BEGIN
84: SELECT substr(p.product_version,1,2) INTO l_product_release
85: FROM fnd_application a, fnd_application_tl t, fnd_product_installations p
86: WHERE a.application_id = p.application_id
87: AND a.application_id = t.application_id
88: AND t.language = Userenv ('LANG')
89: AND Substr (a.application_short_name, 1, 5) = 'PAY';