APPS.ZX_PTP_MIGRATE_PKG dependencies on FND_LOOKUP_VALUES

Line 1401: insert into fnd_lookup_values(

1397:
1398: -- Code to migrate the lookup code for the Lookup Type
1399: -- JLZZ_AP_VAT_REG_STAT_CODE into
1400: -- ZX_REGISTRATIONS_STATUS lookup type
1401: insert into fnd_lookup_values(
1402: LOOKUP_TYPE,
1403: LANGUAGE,
1404: LOOKUP_CODE,
1405: MEANING,

Line 1470: FND_LOOKUP_VALUES fnd

1466: ATTRIBUTE13,
1467: ATTRIBUTE14,
1468: ATTRIBUTE15
1469: FROM
1470: FND_LOOKUP_VALUES fnd
1471: WHERE
1472: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
1473: AND NOT EXISTS
1474: ( select 1 from FND_LOOKUP_VALUES

Line 1474: ( select 1 from FND_LOOKUP_VALUES

1470: FND_LOOKUP_VALUES fnd
1471: WHERE
1472: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
1473: AND NOT EXISTS
1474: ( select 1 from FND_LOOKUP_VALUES
1475: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
1476: lookup_code = fnd.lookup_code) );
1477:
1478: END IF;

Line 3060: insert into fnd_lookup_values(

3056:
3057: -- Code to migrate the lookup code for the Lookup Type
3058: -- JLZZ_AP_VAT_REG_STAT_CODE into
3059: -- ZX_REGISTRATIONS_STATUS lookup type
3060: insert into fnd_lookup_values(
3061: LOOKUP_TYPE,
3062: LANGUAGE,
3063: LOOKUP_CODE,
3064: MEANING,

Line 3129: FND_LOOKUP_VALUES fnd

3125: ATTRIBUTE13,
3126: ATTRIBUTE14,
3127: ATTRIBUTE15
3128: FROM
3129: FND_LOOKUP_VALUES fnd
3130: WHERE
3131: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
3132: AND NOT EXISTS
3133: ( select 1 from FND_LOOKUP_VALUES

Line 3133: ( select 1 from FND_LOOKUP_VALUES

3129: FND_LOOKUP_VALUES fnd
3130: WHERE
3131: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
3132: AND NOT EXISTS
3133: ( select 1 from FND_LOOKUP_VALUES
3134: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
3135: lookup_code = fnd.lookup_code) );
3136:
3137: END IF;