DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_RELATED_DEAL_LINES

Line 1805: , ozf_related_deal_lines b

1801: , decode(nvl(a.accrual_flag,'N'),'N',a.arithmetic_operator, c.arithmetic_operator) operator
1802: , decode(nvl(a.accrual_flag,'N'),'Y',a.arithmetic_operator, c.arithmetic_operator) accrual_operator
1803: FROM
1804: qp_list_lines a
1805: , ozf_related_deal_lines b
1806: , qp_list_lines c
1807: WHERE
1808: a.list_line_id = b.MODIFIER_ID
1809: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)

Line 1892: , ozf_related_deal_lines b

1888: , b.object_version_number
1889: , a.start_date_active
1890: FROM
1891: qp_list_lines a
1892: , ozf_related_deal_lines b
1893: , qp_list_lines c
1894: , qp_list_headers_b d
1895: WHERE
1896: a.list_line_id = b.modifier_id

Line 2267: FROM ozf_related_deal_lines

2263: RETURN NUMBER
2264: IS
2265: CURSOR c_getTdLine(cp_listLineId NUMBER) IS
2266: SELECT related_modifier_id
2267: FROM ozf_related_deal_lines
2268: WHERE modifier_id = cp_listLineId;
2269: l_relatedLineId NUMBER;
2270: BEGIN
2271: OPEN c_getTdLine(cp_listLineId => p_listLineId);