194: --
195: -- Tables for Relationship Plan Engine
196: --
197:
198: plan_id_plan_table csc_plan_assignment_pkg.csc_plan_id_tbl_type;
199: party_id_plan_table csc_plan_assignment_pkg.csc_party_id_tbl_type;
200: account_id_plan_table csc_plan_assignment_pkg.csc_cust_id_tbl_type;
201: --org_id_plan_table csc_plan_assignment_pkg.csc_cust_org_tbl_type;
202: check_id_plan_table csc_plan_assignment_pkg.csc_check_id_tbl_type;
195: -- Tables for Relationship Plan Engine
196: --
197:
198: plan_id_plan_table csc_plan_assignment_pkg.csc_plan_id_tbl_type;
199: party_id_plan_table csc_plan_assignment_pkg.csc_party_id_tbl_type;
200: account_id_plan_table csc_plan_assignment_pkg.csc_cust_id_tbl_type;
201: --org_id_plan_table csc_plan_assignment_pkg.csc_cust_org_tbl_type;
202: check_id_plan_table csc_plan_assignment_pkg.csc_check_id_tbl_type;
203:
196: --
197:
198: plan_id_plan_table csc_plan_assignment_pkg.csc_plan_id_tbl_type;
199: party_id_plan_table csc_plan_assignment_pkg.csc_party_id_tbl_type;
200: account_id_plan_table csc_plan_assignment_pkg.csc_cust_id_tbl_type;
201: --org_id_plan_table csc_plan_assignment_pkg.csc_cust_org_tbl_type;
202: check_id_plan_table csc_plan_assignment_pkg.csc_check_id_tbl_type;
203:
204: -- For Relationship party profile checks
197:
198: plan_id_plan_table csc_plan_assignment_pkg.csc_plan_id_tbl_type;
199: party_id_plan_table csc_plan_assignment_pkg.csc_party_id_tbl_type;
200: account_id_plan_table csc_plan_assignment_pkg.csc_cust_id_tbl_type;
201: --org_id_plan_table csc_plan_assignment_pkg.csc_cust_org_tbl_type;
202: check_id_plan_table csc_plan_assignment_pkg.csc_check_id_tbl_type;
203:
204: -- For Relationship party profile checks
205: g_dashboard_for_contact VARCHAR2(1) := NULL;
198: plan_id_plan_table csc_plan_assignment_pkg.csc_plan_id_tbl_type;
199: party_id_plan_table csc_plan_assignment_pkg.csc_party_id_tbl_type;
200: account_id_plan_table csc_plan_assignment_pkg.csc_cust_id_tbl_type;
201: --org_id_plan_table csc_plan_assignment_pkg.csc_cust_org_tbl_type;
202: check_id_plan_table csc_plan_assignment_pkg.csc_check_id_tbl_type;
203:
204: -- For Relationship party profile checks
205: g_dashboard_for_contact VARCHAR2(1) := NULL;
206: