APPS.PQH_EFC dependencies on PQH_RATE_MATRIX_RATES_F

Line 140: pqh_rate_matrix_rates_f rmr

136: --
137: CURSOR csr_rmr IS
138: SELECT currency_code
139: FROM pqh_criteria_rate_defn crd,
140: pqh_rate_matrix_rates_f rmr
141: WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
142: AND rmr.rate_matrix_rate_id = p_primary_key
143: and rmr.effective_start_date = (
144: Select min(rmr1.effective_start_date)

Line 145: From pqh_rate_matrix_rates_f rmr1

141: WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
142: AND rmr.rate_matrix_rate_id = p_primary_key
143: and rmr.effective_start_date = (
144: Select min(rmr1.effective_start_date)
145: From pqh_rate_matrix_rates_f rmr1
146: Where rmr1.rate_matrix_rate_id = p_primary_key );
147: --
148: CURSOR csr_ssl IS
149: SELECT currency_code

Line 213: -- pqh_rate_matrix_rates_f RMR

209: FETCH csr_bre INTO l_currency_cd;
210: CLOSE csr_bre;
211: --
212: ELSIF p_entity_cd = 'RMR' THEN
213: -- pqh_rate_matrix_rates_f RMR
214: OPEN csr_rmr;
215: FETCH csr_rmr INTO l_currency_cd;
216: CLOSE csr_rmr;
217: --

Line 423: pqh_rate_matrix_rates_f rmr

419: --
420: CURSOR csr_rmr IS
421: SELECT crd.uom
422: FROM pqh_criteria_rate_defn crd,
423: pqh_rate_matrix_rates_f rmr
424: WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
425: AND rmr.rate_matrix_rate_id = p_primary_key
426: and rmr.effective_start_date = (
427: Select min(rmr1.effective_start_date)

Line 428: From pqh_rate_matrix_rates_f rmr1

424: WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
425: AND rmr.rate_matrix_rate_id = p_primary_key
426: and rmr.effective_start_date = (
427: Select min(rmr1.effective_start_date)
428: From pqh_rate_matrix_rates_f rmr1
429: Where rmr1.rate_matrix_rate_id = p_primary_key );
430: --
431: Cursor csr_ssl is
432: Select stock_display_type