APPS.QPR_DEAL_ETL dependencies on QPR_POLICY_LINES

Line 389: from qpr_pn_policies p , qpr_pn_prices pr, qpr_policy_lines pl

385: cursor c_pol_det is
386: select p.policy_line_id, p.policy_id, pl.policy_type_code, pl.policy_measure_type_code,
387: pl.limit_value_type_code,
388: pl.ref_limit_value, null, null
389: from qpr_pn_policies p , qpr_pn_prices pr, qpr_policy_lines pl
390: where p.pn_price_id = pr.pn_price_id
391: and pr.pn_line_id = p_pol_ref_line_id
392: and p.policy_id = pl.policy_id
393: and p.policy_line_id = pl.policy_line_id;