DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on CS_SR_PROB_CODE_MAPPING_DETAIL

Line 2096: FROM CS_SR_PROB_CODE_MAPPING_DETAIL

2092: (
2093: NOT EXISTS
2094: (
2095: SELECT 1
2096: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
2097: WHERE
2098: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
2099: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
2100: )

Line 2107: FROM CS_SR_PROB_CODE_MAPPING_DETAIL

2103: (
2104: EXISTS
2105: (
2106: SELECT 1
2107: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
2108: WHERE
2109: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
2110: PROBLEM_CODE = p_problem_code AND
2111: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))