APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES_ALL

Line 1170: FROM ozf_resale_lines_all orl,

1166: CURSOR dup_line_direct_resale_csr ( p_resale_line_int_id IN NUMBER )
1167: IS
1168: SELECT orl.resale_line_id
1169: -- Bug 4670154 (+)
1170: FROM ozf_resale_lines_all orl,
1171: ozf_resale_lines_int_all orli
1172: /*
1173: FROM ozf_resale_lines orl,
1174: ozf_resale_lines_int orli

Line 1200: FROM ozf_resale_lines_all orl,

1196: CURSOR dup_line_indirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1197: IS
1198: SELECT orl.resale_line_id
1199: -- Bug 4670154 (+)
1200: FROM ozf_resale_lines_all orl,
1201: ozf_resale_lines_int_all orli
1202: /*
1203: FROM ozf_resale_lines orl,
1204: ozf_resale_lines_int orli

Line 1325: FROM ozf_resale_lines_all orl,

1321:
1322: CURSOR dup_line_nondirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1323: IS
1324: SELECT orl.resale_line_id
1325: FROM ozf_resale_lines_all orl,
1326: ozf_resale_lines_int_all orli
1327: -- Bug 4670154 (+)
1328: /*
1329: FROM ozf_resale_lines orl,

Line 1484: FROM ozf_resale_lines_all orl,

1480:
1481: -- Start RSATYAVA Bug#10085365 fix
1482:
1483: l_dup_resl_csr_stmt VARCHAR2(4000) := ' SELECT orl.resale_line_id
1484: FROM ozf_resale_lines_all orl,
1485: ozf_resale_lines_int_all orli ';
1486:
1487: l_dup_resl_exclus_whr_cls_stmt VARCHAR2(4000) := ' WHERE orli.resale_line_int_id = :resale_line_int_id ';
1488:

Line 6793: from ozf_resale_lines_all orl,

6789: object_type = 'TP_ORDER' AND
6790: utilization_type = 'ACCRUAL' -- nepanda : Fix for 12747322 and 12660466 adjustments were getting added to obj_fundsum table twice
6791: AND object_id IN
6792: (select orl.resale_line_id
6793: from ozf_resale_lines_all orl,
6794: OZF_RESALE_BATCH_LINE_MAPS_ALL orblm
6795: where orl.resale_line_id = orblm.resale_line_id
6796: and orblm.resale_batch_id = p_batch_id)
6797: AND EXISTS (SELECT 1 FROM ozf_act_budgets_int where request_id = fut.request_id)