DBA Data[Home] [Help]

APPS.RLM_REPLACE_SV dependencies on RLM_DP_SV

Line 160: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)

156: CURSOR c_eligible_schedule IS
157: SELECT header_id
158: FROM rlm_schedule_headers
159: WHERE schedule_type = x_sched_rec.schedule_type
160: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)
161: AND schedule_source <> RLM_DP_SV.k_MANUAL
162: -- AND customer_id = x_sched_rec.customer_id
163: AND ece_tp_translator_code = x_sched_rec.ece_tp_translator_code
164: AND ece_tp_location_code_ext = x_sched_rec.ece_tp_location_code_ext

Line 161: AND schedule_source <> RLM_DP_SV.k_MANUAL

157: SELECT header_id
158: FROM rlm_schedule_headers
159: WHERE schedule_type = x_sched_rec.schedule_type
160: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)
161: AND schedule_source <> RLM_DP_SV.k_MANUAL
162: -- AND customer_id = x_sched_rec.customer_id
163: AND ece_tp_translator_code = x_sched_rec.ece_tp_translator_code
164: AND ece_tp_location_code_ext = x_sched_rec.ece_tp_location_code_ext
165: AND NVL(edi_test_indicator,'P') = NVL(x_sched_rec.edi_test_indicator,'P')