APPS.CS_STD dependencies on CSC_PROF_CHECK_RESULTS

Line 1059: FROM csc_prof_check_results

1055: -- PARTY,CONTACT AND EMPLOYEE UPDATE
1056: CURSOR party_last_date_crs(p_party_id IN NUMBER)
1057: IS
1058: SELECT MAX(last_update_date)
1059: FROM csc_prof_check_results
1060: WHERE party_id = p_party_id
1061: AND cust_account_id IS NULL;
1062: -- ACCOUNT UPDATE
1063: CURSOR acct_last_date_crs(p_party_id IN NUMBER, p_cust_account_id IN NUMBER)

Line 1066: FROM csc_prof_check_results

1062: -- ACCOUNT UPDATE
1063: CURSOR acct_last_date_crs(p_party_id IN NUMBER, p_cust_account_id IN NUMBER)
1064: IS
1065: SELECT MAX(last_update_date)
1066: FROM csc_prof_check_results
1067: WHERE party_id = p_party_id
1068: AND cust_account_id = p_account_id;
1069: -- SITE UPDATE
1070: CURSOR site_last_date_crs(p_party_id IN NUMBER, p_party_site_id IN NUMBER)

Line 1073: FROM csc_prof_check_results

1069: -- SITE UPDATE
1070: CURSOR site_last_date_crs(p_party_id IN NUMBER, p_party_site_id IN NUMBER)
1071: IS
1072: SELECT MAX(last_update_date)
1073: FROM csc_prof_check_results
1074: WHERE party_site_id = p_party_site_id
1075: AND party_id = p_party_id
1076: AND cust_account_id IS NULL;
1077: BEGIN