Line 43: l_policy_id := fnd_profile.value('QPR_DEFAULT_POLICY');
39: begin
40:
41: if i_policy_id is null then
42: if i_psg_id = qpr_sr_util.get_null_pk then 43: l_policy_id := fnd_profile.value('QPR_DEFAULT_POLICY'); 44: else
45: select DEFAULT_POLICY_ID into l_policy_id
46: from qpr_pr_segments_b
47: where PR_SEGMENT_ID = i_psg_id;