DBA Data[Home] [Help]

APPS.QP_AGRUPGRADE dependencies on OE_AGREEMENTS_B

Line 135: from oe_agreements_b

131: ATTRIBUTE14,
132: ATTRIBUTE15
133: from so_agreements_b a
134: where NOT EXISTS (select 'x'
135: from oe_agreements_b
136: where agreement_id = a.agreement_id)
137: AND a.agreement_id BETWEEN p_min_line AND p_max_line;
138:
139: BEGIN

Line 159: INSERT INTO OE_AGREEMENTS_B (

155: FOR agreement_rec IN so_agreements_cur(v_min_line, v_max_line) LOOP
156: --dbms_output.put_line('processing agr = '||agreement_rec.agreement_id);
157:
158: BEGIN
159: INSERT INTO OE_AGREEMENTS_B (
160: AGREEMENT_ID
161: ,CREATION_DATE
162: ,CREATED_BY
163: ,LAST_UPDATE_DATE