APPS.ZX_PTP_MIGRATE_PKG dependencies on FND_LOOKUP_VALUES

Line 1521: insert into fnd_lookup_values(

1517:
1518: -- Code to migrate the lookup code for the Lookup Type
1519: -- JLZZ_AP_VAT_REG_STAT_CODE into
1520: -- ZX_REGISTRATIONS_STATUS lookup type
1521: insert into fnd_lookup_values(
1522: LOOKUP_TYPE,
1523: LANGUAGE,
1524: LOOKUP_CODE,
1525: MEANING,

Line 1590: FND_LOOKUP_VALUES fnd

1586: ATTRIBUTE13,
1587: ATTRIBUTE14,
1588: ATTRIBUTE15
1589: FROM
1590: FND_LOOKUP_VALUES fnd
1591: WHERE
1592: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
1593: AND NOT EXISTS
1594: ( select 1 from FND_LOOKUP_VALUES

Line 1594: ( select 1 from FND_LOOKUP_VALUES

1590: FND_LOOKUP_VALUES fnd
1591: WHERE
1592: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
1593: AND NOT EXISTS
1594: ( select 1 from FND_LOOKUP_VALUES
1595: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
1596: lookup_code = fnd.lookup_code) );
1597:
1598: END IF;

Line 3180: insert into fnd_lookup_values(

3176:
3177: -- Code to migrate the lookup code for the Lookup Type
3178: -- JLZZ_AP_VAT_REG_STAT_CODE into
3179: -- ZX_REGISTRATIONS_STATUS lookup type
3180: insert into fnd_lookup_values(
3181: LOOKUP_TYPE,
3182: LANGUAGE,
3183: LOOKUP_CODE,
3184: MEANING,

Line 3249: FND_LOOKUP_VALUES fnd

3245: ATTRIBUTE13,
3246: ATTRIBUTE14,
3247: ATTRIBUTE15
3248: FROM
3249: FND_LOOKUP_VALUES fnd
3250: WHERE
3251: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
3252: AND NOT EXISTS
3253: ( select 1 from FND_LOOKUP_VALUES

Line 3253: ( select 1 from FND_LOOKUP_VALUES

3249: FND_LOOKUP_VALUES fnd
3250: WHERE
3251: fnd.LOOKUP_TYPE = 'JLZZ_AP_VAT_REG_STAT_CODE'
3252: AND NOT EXISTS
3253: ( select 1 from FND_LOOKUP_VALUES
3254: where lookup_type = 'JLZZ_AP_VAT_REG_STAT_CODE' and
3255: lookup_code = fnd.lookup_code) );
3256:
3257: END IF;