APPS.CSC_PLAN_ASSIGNMENT_PKG dependencies on CSC_PLAN_HEADERS_B

Line 120: csc_plan_headers_b.

116:
117: 1> Given a list of plan_id(s) this is what should be done:
118: - get the profile variables and plan levels (either party or account level)
119: associated with each of those plans from the plan headers table
120: csc_plan_headers_b.
121: - if the plan is at party level then
122: - for each of those profile variables (check_ids), get the result for all
123: parties (only, not accounts) from the results table.
124: - else if the plan is at account level then

Line 347: from csc_plan_headers_b a,

343: select a.plan_id, a.profile_check_id, a.relational_operator,
344: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
345: a.end_date_active, a.use_for_cust_account,
346: b.party_id, b.cust_account_id, b.value
347: from csc_plan_headers_b a,
348: csc_prof_check_results b
349: where a.profile_check_id = b.check_id
350: and a.plan_id = p_plan_id
351: and a.customized_plan = 'N'

Line 453: from csc_plan_headers_b a,

449: select a.plan_id, a.profile_check_id, a.relational_operator,
450: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
451: a.end_date_active, a.use_for_cust_account,
452: b.party_id, b.cust_account_id, b.value
453: from csc_plan_headers_b a,
454: csc_prof_check_results b
455: where a.profile_check_id = b.check_id
456: and a.profile_check_id = p_check_id
457: and a.customized_plan = 'N'

Line 555: from csc_plan_headers_b a,

551: select a.plan_id, a.profile_check_id, a.relational_operator,
552: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
553: a.end_date_active, a.use_for_cust_account,
554: b.party_id, b.cust_account_id, b.value
555: from csc_plan_headers_b a,
556: csc_prof_check_results b
557: where a.profile_check_id = b.check_id
558: and a.customized_plan = 'N'
559: and b.party_id = p_party_id

Line 654: from csc_plan_headers_b a,

650: select a.plan_id, a.profile_check_id, a.relational_operator,
651: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
652: a.end_date_active, a.use_for_cust_account,
653: b.party_id, b.cust_account_id, b.value
654: from csc_plan_headers_b a,
655: csc_prof_check_results b
656: where a.profile_check_id = b.check_id
657: and a.customized_plan = 'N'
658: and b.cust_account_id = p_cust_account_id

Line 756: from csc_plan_headers_b a,

752: select a.plan_id, a.profile_check_id, a.relational_operator,
753: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
754: a.end_date_active, a.use_for_cust_account,
755: b.party_id, b.cust_account_id, b.value
756: from csc_plan_headers_b a,
757: csc_prof_check_results b
758: where a.profile_check_id = b.check_id
759: and a.plan_id = p_plan_id
760: and a.customized_plan = 'N'

Line 867: from csc_plan_headers_b a,

863: select a.plan_id, a.profile_check_id, a.relational_operator,
864: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
865: a.end_date_active, a.use_for_cust_account,
866: b.party_id, b.cust_account_id, b.value
867: from csc_plan_headers_b a,
868: csc_prof_check_results b
869: where a.profile_check_id = b.check_id
870: and a.plan_id = p_plan_id
871: and a.customized_plan = 'N'

Line 974: from csc_plan_headers_b a,

970: select a.plan_id, a.profile_check_id, a.relational_operator,
971: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
972: a.end_date_active, a.use_for_cust_account,
973: b.party_id, b.cust_account_id, b.value
974: from csc_plan_headers_b a,
975: csc_prof_check_results b
976: where a.profile_check_id = b.check_id
977: and a.profile_check_id = p_check_id
978: and a.customized_plan = 'N'

Line 1083: from csc_plan_headers_b a,

1079: select a.plan_id, a.profile_check_id, a.relational_operator,
1080: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
1081: a.end_date_active, a.use_for_cust_account,
1082: b.party_id, b.cust_account_id, b.value
1083: from csc_plan_headers_b a,
1084: csc_prof_check_results b
1085: where a.profile_check_id = b.check_id
1086: and a.profile_check_id = p_check_id
1087: and a.customized_plan = 'N'

Line 1192: from csc_plan_headers_b a,

1188: select a.plan_id, a.profile_check_id, a.relational_operator,
1189: a.criteria_value_low, a.criteria_value_high, a.start_date_active,
1190: a.end_date_active, a.use_for_cust_account,
1191: b.party_id, b.cust_account_id, b.value
1192: from csc_plan_headers_b a,
1193: csc_prof_check_results b
1194: where a.profile_check_id = b.check_id
1195: and a.customized_plan = 'N'
1196: and ( ( a.use_for_cust_account = 'N' and