DBA Data[Home] [Help]

APPS.PO_GA_ORG_ASSIGN_PVT dependencies on PO_GA_ORG_ASSIGNMENTS_S

Line 62: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval

58:
59: --
60: -- SQL What:retrieve the value of org_assignment_id
61: -- SQL Why: to insert into po_ga_org_assignments
62: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval
63: INTO l_org_assignment_id
64: FROM dual;
65: --
66:

Line 384: -- Used PO_GA_ORG_ASSIGNMENTS_S.nextval directly inside insert statement

380: x_return_status := FND_API.g_ret_sts_success;
381: -- End standard API initialization
382:
383: --
384: -- Used PO_GA_ORG_ASSIGNMENTS_S.nextval directly inside insert statement
385: --
386:
387: INSERT INTO PO_GA_ORG_ASSIGNMENTS
388: (

Line 401: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval ,--Bug#4623941

397: created_by,
398: last_update_login,
399: purchasing_org_id
400: )
401: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval ,--Bug#4623941
402: p_to_po_header_id,
403: pgoa.organization_id,
404: pgoa.enabled_flag,
405: pgoa.vendor_site_id,