APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on FND_LANGUAGES

Line 542: FND_LANGUAGES L

538: AWTL.TERMS_AND_CONDITIONS,
539: AWTL.REACTION_AND_RESOL_TIME,
540: AWTL.SERVICE_LEVEL_AGREEMENT
541: FROM AHL_WARRANTY_TEMPLATES_TL AWTL,
542: FND_LANGUAGES L
543: WHERE AWTL.WARRANTY_TEMPLATE_ID (+) = P_WARRANTY_TEMPLATE_ID
544: AND AWTL.LANGUAGE (+) = L.LANGUAGE_CODE
545: AND L.INSTALLED_FLAG IN ('I', 'B')
546: AND NOT EXISTS

Line 653: FND_LANGUAGES L

649: SYSDATE,
650: Fnd_Global.USER_ID,
651: Fnd_Global.LOGIN_ID
652: FROM AHL_WARRANTY_TMPL_CTR_TL AWTCL,
653: FND_LANGUAGES L
654: WHERE AWTCL.WARRANTY_TMPL_COUNTER_ID (+) = warranty_contract_counter_rec.warranty_tmpl_counter_id
655: AND AWTCL.LANGUAGE (+) = L.LANGUAGE_CODE
656: AND L.INSTALLED_FLAG IN ('I', 'B')
657: AND NOT EXISTS

Line 943: from AHL_WARRANTY_CONTRACTS_TL B, FND_LANGUAGES L

939: B.REACTION_AND_RESOL_TIME,
940: B.SERVICE_LEVEL_AGREEMENT,
941: L.LANGUAGE_CODE,
942: B.SOURCE_LANG
943: from AHL_WARRANTY_CONTRACTS_TL B, FND_LANGUAGES L
944: where L.INSTALLED_FLAG in ('I', 'B')
945: and B.LANGUAGE = userenv('LANG')
946: and not exists
947: (select NULL

Line 1022: from AHL_WARRANTY_CONT_CTR_TL B, FND_LANGUAGES L

1018: B.REACTION_AND_RESOL_TIME,
1019: B.SERVICE_LEVEL_AGREEMENT,
1020: L.LANGUAGE_CODE,
1021: B.SOURCE_LANG
1022: from AHL_WARRANTY_CONT_CTR_TL B, FND_LANGUAGES L
1023: where L.INSTALLED_FLAG in ('I', 'B')
1024: and B.LANGUAGE = userenv('LANG')
1025: and not exists
1026: (select NULL