APPS.JTF_AE_SQLUTIL_API dependencies on JTF_SUBSCRIBED_PROFILES

Line 461: p_appID IN JTF_SUBSCRIBED_PROFILES.application_id%TYPE,

457: END getAttrName;
458:
459: PROCEDURE getAppProfileID(
460: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
461: p_appID IN JTF_SUBSCRIBED_PROFILES.application_id%TYPE,
462: p_PMAPID OUT NOCOPY /* file.sql.39 change */ NUMBER,
463: p_SUBID OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
464:
465: BEGIN

Line 469: FROM JTF_SUBSCRIBED_PROFILES s, JTF_PROFILE_MAPPINGS_TL t

465: BEGIN
466:
467: SELECT s.profile_mappings_id,s.subscribed_profiles_id
468: INTO p_PMAPID, p_SUBID
469: FROM JTF_SUBSCRIBED_PROFILES s, JTF_PROFILE_MAPPINGS_TL t
470: WHERE s.application_id = p_appID
471: AND s.profile_mappings_id = t.profile_mappings_id
472: AND t.profileName = p_ProfileName AND t.language = userenv('LANG');
473: