APPS.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on AR_CMGT_GUARANTOR_DATA

Line 544: FROM ar_cmgt_guarantor_data gd,

540: pr.source_security_group_id,
541: pr.source_name parent_source_name,
542: pr.application_date parent_application_date,
543: pr.requestor_type, pr.requestor_id
544: FROM ar_cmgt_guarantor_data gd,
545: ar_cmgt_credit_requests pr
546: WHERE gd.credit_request_id = cp_credit_request_id
547: AND gd.credit_request_id = pr.credit_request_id
548: AND gd.guarantor_credit_request_id IS NULL; -- prevents duplics

Line 691: so we can stamp them on ar_cmgt_guarantor_data afterwards */

687: RETURN;
688: END IF;
689:
690: /* Store datapoint_id and guarantor_credit_request_id
691: so we can stamp them on ar_cmgt_guarantor_data afterwards */
692: datapoint_t(i) := c_guar.datapoint_id;
693: guarcredreq_t(i) := l_guar_credit_request_id;
694: i := i + 1;
695: END LOOP;

Line 697: /* Now update ar_cmgt_guarantor_data to set

693: guarcredreq_t(i) := l_guar_credit_request_id;
694: i := i + 1;
695: END LOOP;
696:
697: /* Now update ar_cmgt_guarantor_data to set
698: guarantor_credit_request_id */
699: IF i > 0
700: THEN
701: /* 6956789 - Only execute update if there are rows

Line 704: UPDATE ar_cmgt_guarantor_data

700: THEN
701: /* 6956789 - Only execute update if there are rows
702: to process */
703: FORALL x in datapoint_t.FIRST..datapoint_t.LAST
704: UPDATE ar_cmgt_guarantor_data
705: SET guarantor_credit_request_id = guarcredreq_t(x)
706: WHERE datapoint_id = datapoint_t(x);
707: END IF;
708: