DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PUB dependencies on FND_APPLICATION

Line 66: FROM fnd_product_installations inst, fnd_application app

62: --l_count NUMBER;
63:
64: /*CURSOR c_product_check (cp_app_short_name IN VARCHAR2) IS
65: SELECT inst.status
66: FROM fnd_product_installations inst, fnd_application app
67: WHERE inst.application_id = app.application_id
68: AND app.application_short_name = cp_app_short_name
69: AND inst.status <> 'N';*/
70:

Line 815: FROM fnd_product_installations inst, fnd_application app

811: l_approval_status VARCHAR2(1);
812:
813: CURSOR c_product_check (cp_app_short_name IN VARCHAR2) IS
814: SELECT inst.status
815: FROM fnd_product_installations inst, fnd_application app
816: WHERE inst.application_id = app.application_id
817: AND app.application_short_name = cp_app_short_name
818: AND inst.status <> 'N';
819:

Line 1069: FROM fnd_product_installations inst, fnd_application app

1065: l_null VARCHAR2(1) := NULL;
1066:
1067: CURSOR c_product_check (cp_app_short_name IN VARCHAR2) IS
1068: SELECT inst.status
1069: FROM fnd_product_installations inst, fnd_application app
1070: WHERE inst.application_id = app.application_id
1071: AND app.application_short_name = cp_app_short_name
1072: AND inst.status <> 'N';
1073: