DBA Data[Home] [Help]

APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_CHARGE_SCHEDULES_S

Line 125: ar_charge_schedules_s.NEXTVAL, -- schedule_id

121: last_update_date,
122: last_update_login
123: )
124: VALUES(
125: ar_charge_schedules_s.NEXTVAL, -- schedule_id
126: r_aging_bkts.name || '_' || r_aging_bkts.ccy_code, -- schedule_name
127: r_aging_bkts.name || '_' || r_aging_bkts.ccy_code, -- schedule_description
128: 1, -- object_version_number
129: -1, -- created_by

Line 392: ar_charge_schedules_s.NEXTVAL, -- schedule_id

388: last_update_date,
389: last_update_login
390: )
391: VALUES(
392: ar_charge_schedules_s.NEXTVAL, -- schedule_id
393: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id, -- schedule_name
394: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id, -- schedule_description
395: 1, -- object_version_number
396: -1, -- created_by

Line 565: ar_charge_schedules_s.NEXTVAL,

561: last_update_date,
562: last_update_login
563: )
564: VALUES(
565: ar_charge_schedules_s.NEXTVAL,
566: r_aging_bkts_uu.name || '_' || r_aging_bkts_uu.ccy_code || '_'
567: || decode(r_aging_bkts_uu.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'),
568: r_aging_bkts_uu.name || '_' || r_aging_bkts_uu.ccy_code|| '_'
569: || decode(r_aging_bkts_uu.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'),

Line 755: ar_charge_schedules_s.NEXTVAL, -- schedule_id

751: last_update_date,
752: last_update_login
753: )
754: VALUES(
755: ar_charge_schedules_s.NEXTVAL, -- schedule_id
756: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id || '_'
757: || decode(r_aging_bkt_lines_site.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'), -- schedule_name
758: l_name || '_' || l_ccy_code || '_' || r_aging_bkt_lines_site.customer_profile_id || '_'
759: || decode(r_aging_bkt_lines_site.charge_type, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'), -- schedule_description