DBA Data[Home] [Help]

APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on FND_PROFILE

Line 697: and jtb.scheduled_start_date > (sysdate - NVL(fnd_profile.value_specific('CSF_M_HISTORY'),100))

693: AND ciab.incident_status_id = cisb.incident_status_id
694: AND cisb.close_flag = 'Y'
695: AND ciab.incident_id = jtb.source_object_id
696: AND jtb.source_object_type_code = 'SR'
697: and jtb.scheduled_start_date > (sysdate - NVL(fnd_profile.value_specific('CSF_M_HISTORY'),100))
698: AND ciia.user_id IN ( SELECT cpa.user_id
699: FROM csm_party_assignment cpa
700: WHERE cpa.deleted_flag ='N'
701: )

Line 732: l_sr_profile_value := fnd_profile.value_specific('CSM_SR_HIST_DWLD_PARTY');

728: 'CSM_SERVICE_HISTORY_EVENT_PKG.PROCESS_OWNER_HISTORY',FND_LOG.LEVEL_PROCEDURE);
729:
730: l_parent_incident_id := 1;
731:
732: l_sr_profile_value := fnd_profile.value_specific('CSM_SR_HIST_DWLD_PARTY');
733:
734: IF l_sr_profile_value = 'Y' THEN
735:
736: