DBA Data[Home] [Help]

APPS.GMS_CMERGE dependencies on GMS_AWARDS_ALL

Line 7: var_award_id gms_awards_all.award_id%TYPE;

3:
4: -- Package to perform customer merge for Grants accounting
5:
6:
7: var_award_id gms_awards_all.award_id%TYPE;
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;

Line 8: var_customer_id gms_awards_all.funding_source_id%TYPE;

4: -- Package to perform customer merge for Grants accounting
5:
6:
7: var_award_id gms_awards_all.award_id%TYPE;
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;

Line 9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;

5:
6:
7: var_award_id gms_awards_all.award_id%TYPE;
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;
13: new_loc_customer_id ra_customer_merges.customer_id%TYPE;