APPS.IGIRCBID dependencies on IGI_AR_REC_APPLICATIONS_ALL

Line 49: from igi_ar_rec_applications_all igi

45: FUNCTION IsRecordCopiedBefore ( fp_app_id in number) return boolean
46: IS
47: CURSOR c_app is
48: select 'x'
49: from igi_ar_rec_applications_all igi
50: where igi.receivable_application_id = fp_app_id
51: ;
52: BEGIN
53: FOR l_app IN c_app LOOP

Line 73: INSERT INTO igi_ar_rec_applications_all

69: FOR LRA in CRa LOOP
70: IF (NOT IsRecordCopiedBefore( LRA.receivable_application_id ))
71: THEN
72: --
73: INSERT INTO igi_ar_rec_applications_all
74: ( receivable_application_id
75: , arc_posting_control_id
76: , last_update_date
77: , last_updated_by

Line 152: from igi_ar_rec_applications_all igi

148: FUNCTION IsRecordCopiedBefore ( fp_app_id in number) return boolean
149: IS
150: CURSOR c_app is
151: select 'x'
152: from igi_ar_rec_applications_all igi
153: where igi.receivable_application_id = fp_app_id
154: ;
155: BEGIN
156: FOR l_app IN c_app LOOP

Line 174: INSERT INTO igi_ar_rec_applications_all

170: FOR LRA in CRa LOOP
171: IF (LRA.CmPsIdFlag <> 'Y') AND (NOT IsRecordCopiedBefore( LRA.receivable_application_id ))
172: THEN
173:
174: INSERT INTO igi_ar_rec_applications_all
175: ( receivable_application_id
176: , arc_posting_control_id
177: , last_update_date
178: , last_updated_by