APPS.CS_MULTIORG_PVT dependencies on CS_INCIDENTS_ALL_B

Line 68: FROM cs_incidents_all_b a,

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

Line 76: cs_incidents_all_b b

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

Line 82: FROM cs_incidents_all_b

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

Line 88: FROM cs_incidents_all_b

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