APPS.CSC_PLAN_ASSIGNMENT_PKG dependencies on CSC_PROF_CHECK_RESULTS

Line 348: csc_prof_check_results b

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'
352: and ( ( a.use_for_cust_account = 'N'

Line 454: csc_prof_check_results b

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'
458: and ( ( a.use_for_cust_account = 'N'

Line 556: csc_prof_check_results b

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
560: and b.cust_account_id is NULL

Line 655: csc_prof_check_results b

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
659: and a.use_for_cust_account = 'Y'

Line 757: csc_prof_check_results b

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'
761: and b.party_id = p_party_id

Line 868: csc_prof_check_results b

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'
872: and b.cust_account_id = p_cust_account_id

Line 975: csc_prof_check_results b

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'
979: and b.party_id = p_party_id

Line 1084: csc_prof_check_results b

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'
1088: and b.cust_account_id = p_cust_account_id

Line 1193: csc_prof_check_results b

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
1197: b.cust_account_id is null )