APPS.HZ_PAYMENT_METHOD_PKG dependencies on RA_CUST_RECEIPT_METHODS_S

Line 75: ra_cust_receipt_methods_s.NEXTVAL,

71: program_id,
72: program_update_date
73: ) VALUES (
74: DECODE(x_cust_receipt_method_id, fnd_api.g_miss_num,
75: ra_cust_receipt_methods_s.NEXTVAL,
76: NULL, ra_cust_receipt_methods_s.NEXTVAL, x_cust_receipt_method_id),
77: DECODE(x_customer_id, fnd_api.g_miss_num, NULL, x_customer_id),
78: DECODE(x_receipt_method_id, fnd_api.g_miss_num, NULL, x_receipt_method_id),
79: DECODE(x_primary_flag, fnd_api.g_miss_char, NULL, x_primary_flag),

Line 76: NULL, ra_cust_receipt_methods_s.NEXTVAL, x_cust_receipt_method_id),

72: program_update_date
73: ) VALUES (
74: DECODE(x_cust_receipt_method_id, fnd_api.g_miss_num,
75: ra_cust_receipt_methods_s.NEXTVAL,
76: NULL, ra_cust_receipt_methods_s.NEXTVAL, x_cust_receipt_method_id),
77: DECODE(x_customer_id, fnd_api.g_miss_num, NULL, x_customer_id),
78: DECODE(x_receipt_method_id, fnd_api.g_miss_num, NULL, x_receipt_method_id),
79: DECODE(x_primary_flag, fnd_api.g_miss_char, NULL, x_primary_flag),
80: DECODE(x_site_use_id, fnd_api.g_miss_num, NULL, x_site_use_id),

Line 135: SELECT RA_CUST_RECEIPT_METHODS_S.NEXTVAL

131: l_temp_crm_id := 0;
132: SELECT max(cust_receipt_method_id) INTO l_max_crm_id
133: FROM RA_CUST_RECEIPT_METHODS;
134: WHILE l_temp_crm_id <= l_max_crm_id LOOP
135: SELECT RA_CUST_RECEIPT_METHODS_S.NEXTVAL
136: INTO l_temp_crm_id FROM dual;
137: END LOOP;
138: END;
139: ELSE