APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_CUSTOMER_SPEC_VRS

Line 3381: INSERT INTO gmd_customer_spec_vrs

3377: );
3378:
3379: ELSIF sd.qc_rec_type = 'C' THEN
3380: /* Create an customer spec validity rule */
3381: INSERT INTO gmd_customer_spec_vrs
3382: (
3383: spec_vr_id,
3384: spec_id,
3385: orgn_code,

Line 6049: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',

6045: and SPEC_VR_STATUS = 700;
6046:
6047: GMA_MIGRATION.gma_insert_message (
6048: p_run_id => p_migration_id,
6049: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
6050: p_DB_ERROR => '',
6051: p_param1 => 'Nulling out end date on customer vrs ',
6052: p_param2 => 'Where end date is SY$MAX_DATE ',
6053: p_param3 => '',

Line 6062: update gmd_customer_spec_vrs

6058: p_line_no => '',
6059: p_position => '',
6060: p_base_message => '');
6061:
6062: update gmd_customer_spec_vrs
6063: set end_date = NULL
6064: where trunc(end_date + 1) >= l_max_date
6065: and SPEC_VR_STATUS = 700;
6066: