APPS.CS_MULTIORG_PVT dependencies on CS_INCIDENTS_ALL_B

Line 67: FROM cs_incidents_all_b a,

63: order by multi_org_rule_order;
64:
65: CURSOR l_RC_csr IS
66: SELECT b.authoring_org_id
67: FROM cs_incidents_all_b a,
68: okc_k_headers_all_b b
69: WHERE a.incident_id = p_incident_id
70: and a.contract_id = b.id;
71:

Line 75: cs_incidents_all_b b

71:
72: CURSOR l_RIB_csr IS
73: SELECT a.org_id
74: FROM cs_customer_products_all a,
75: cs_incidents_all_b b
76: WHERE b.incident_id = p_incident_id
77: AND a.customer_product_id = b.customer_product_id;
78:
79: CURSOR l_RSR_csr IS

Line 81: FROM cs_incidents_all_b

77: AND a.customer_product_id = b.customer_product_id;
78:
79: CURSOR l_RSR_csr IS
80: SELECT org_id
81: FROM cs_incidents_all_b
82: WHERE incident_id = p_incident_id;
83:
84: CURSOR l_get_tca_id IS
85: SELECT bill_to_site_id

Line 87: FROM cs_incidents_all_b

83:
84: CURSOR l_get_tca_id IS
85: SELECT bill_to_site_id
86: ,bill_to_account_id
87: FROM cs_incidents_all_b
88: WHERE incident_id = p_incident_id;
89:
90: CURSOR l_get_org_from_prime_accsite(p_party_site_id IN NUMBER
91: ,p_account_id IN NUMBER) IS