APPS.PO_GA_ORG_ASSIGN_DRAFT_PKG dependencies on PO_GA_ORG_ASSIGNMENTS

Line 183: FROM po_ga_org_assignments

179: creation_date,
180: created_by,
181: last_update_login,
182: purchasing_org_id
183: FROM po_ga_org_assignments
184: WHERE org_assignment_id = p_org_assignment_id_tbl(i)
185: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
187:

Line 341: DELETE FROM po_ga_org_assignments PGOA

337:
338: -- bug5187544
339: -- Delete only records that have not been rejected
340:
341: DELETE FROM po_ga_org_assignments PGOA
342: WHERE PGOA.org_assignment_id IN
343: ( SELECT PGOAD.org_assignment_id
344: FROM po_ga_org_assign_draft PGOAD
345: WHERE PGOAD.draft_id = p_draft_id

Line 354: MERGE INTO po_ga_org_assignments PGOA

350: -- For update case, the following columns will be skipped:
351: --PGOA.org_assignment_id
352: --PGOA.creation_date
353: --PGOA.created_by
354: MERGE INTO po_ga_org_assignments PGOA
355: USING (
356: SELECT
357: PGOAD.draft_id,
358: PGOAD.delete_flag,

Line 505: FROM po_ga_org_assignments

501: END IF;
502:
503: SELECT 1
504: INTO l_dummy
505: FROM po_ga_org_assignments
506: WHERE org_assignment_id = p_org_assignment_id
507: FOR UPDATE NOWAIT;
508:
509: IF (PO_LOG.d_proc) THEN