DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_RELATED_DEAL_LINES

Line 2056: , ozf_related_deal_lines b

2052: , decode(nvl(a.accrual_flag,'N'),'N',a.arithmetic_operator, c.arithmetic_operator) operator
2053: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
2054: FROM
2055: qp_list_lines a
2056: , ozf_related_deal_lines b
2057: , qp_list_lines c
2058: WHERE
2059: a.list_line_id = b.MODIFIER_ID
2060: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)

Line 2176: , ozf_related_deal_lines b

2172: , b.object_version_number
2173: , a.start_date_active
2174: FROM
2175: qp_list_lines a
2176: , ozf_related_deal_lines b
2177: , qp_list_lines c
2178: , qp_list_headers_b d
2179: WHERE
2180: a.list_line_id = b.modifier_id

Line 2551: FROM ozf_related_deal_lines

2547: RETURN NUMBER
2548: IS
2549: CURSOR c_getTdLine(cp_listLineId NUMBER) IS
2550: SELECT related_modifier_id
2551: FROM ozf_related_deal_lines
2552: WHERE modifier_id = cp_listLineId;
2553: l_relatedLineId NUMBER;
2554: BEGIN
2555: OPEN c_getTdLine(cp_listLineId => p_listLineId);