DBA Data[Home] [Help]

APPS.PA_CC_UTILS dependencies on PA_CC_ORG_RELATIONSHIPS

Line 30: FROM pa_cc_org_relationships

26: cursor c1 is
27: SELECT 1
28: FROM sys.dual
29: where exists (SELECT NULL
30: FROM pa_cc_org_relationships
31: where prvdr_org_id = x_provider_org_id
32: and recvr_org_id = x_receiver_org_id
33: and vendor_site_id is not null);
34:

Line 68: FROM pa_cc_org_relationships

64: cursor c1 is
65: SELECT 1
66: FROM sys.dual
67: where exists (SELECT NULL
68: FROM pa_cc_org_relationships
69: where prvdr_project_id = x_project_id);
70:
71: c1_rec c1%rowtype;
72: begin