APPS.PV_PARTNER_MIGRATIONS_PUB dependencies on FND_LOOKUP_VALUES

Line 241: fnd_lookup_values

237: select
238: lookup_code,
239: tag
240: from
241: fnd_lookup_values
242: where
243: lookup_type = 'PV_PARTNER_TYPE_RANKING' and
244: enabled_flag = 'Y' AND
245: language = userenv('LANG') and

Line 386: fnd_lookup_values lkp where

382: LATEST_FLAG = 'Y'
383:
384:
385: ) attr,
386: fnd_lookup_values lkp where
387: ENTITY_ID NOT IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ENTITY_ID = attr.entity_id and ATTR_VALUE = 'VAD') and
388: attr.attr_value = lkp.lookup_code and
389: lkp.language = userenv('LANG') and
390: lkp.lookup_type = 'PV_PARTNER_TYPE_RANKING'

Line 394: fnd_lookup_values match,

390: lkp.lookup_type = 'PV_PARTNER_TYPE_RANKING'
391: group by entity_id
392: ) sorted,
393: pv_enty_attr_values details,
394: fnd_lookup_values match,
395: pv_partner_profiles ppp
396: where
397: details.attr_value = lookup_code and
398: match.lookup_type = 'PV_PARTNER_TYPE_RANKING' and

Line 437: fnd_lookup_values lkp,

433: SELECT distinct
434: attr_value,
435: entity_id
436: FROM pv_enty_attr_values attr,
437: fnd_lookup_values lkp,
438: pv_partner_profiles ppp
439: WHERE
440: attribute_id = 3
441: AND latest_flag = 'Y'

Line 458: from fnd_lookup_values

454: AND lkp.language = userenv('LANG')
455: AND attr.entity_id = ppp.partner_id
456: AND ppp.status IN ('A' , 'I')
457: AND to_number(tag) = (select min(to_number(tag))
458: from fnd_lookup_values
459: where
460: lookup_code in (select attr_value
461: from pv_enty_attr_values
462: where attribute_id=3

Line 492: from fnd_lookup_values

488: --Validating the PV_PARTNER_TYPE_RNKING lookup setup.
489: -- If setup is not available then Exit the program.
490: select count(*)
491: into l_count
492: from fnd_lookup_values
493: where lookup_type = 'PV_PARTNER_TYPE_RANKING'
494: and language = userenv('LANG')
495: and enabled_flag = 'Y';
496:

Line 518: FND_LOOKUP_VALUES

514: (
515: SELECT
516: LOOKUP_CODE
517: FROM
518: FND_LOOKUP_VALUES
519: WHERE
520: LOOKUP_CODE<> 'VAD' AND
521: language = userenv('LANG') and
522: lookup_type = 'PV_PARTNER_TYPE_RANKING'and

Line 536: FND_LOOKUP_VALUES

532: --Validate that all partner types have been ranked, if yes check if they are numbers
533: select
534: count(*) into l_count
535: from
536: FND_LOOKUP_VALUES
537: where
538: LOOKUP_CODE <> 'VAD' AND
539: lookup_type = 'PV_PARTNER_TYPE_RANKING' AND
540: language = userenv('LANG') and

Line 556: FND_LOOKUP_VALUES

552: begin
553: select
554: count(to_number(TAG)) into l_count
555: from
556: FND_LOOKUP_VALUES
557: where
558: LOOKUP_CODE <> 'VAD' AND
559: lookup_type = 'PV_PARTNER_TYPE_RANKING' AND
560: enabled_flag = 'Y' and

Line 577: FND_LOOKUP_VALUES

573:
574: select
575: count(distinct tag) into l_distinct_count
576: from
577: FND_LOOKUP_VALUES
578: where
579: LOOKUP_CODE <> 'VAD' AND
580: lookup_type = 'PV_PARTNER_TYPE_RANKING' AND
581: language = userenv('LANG') and

Line 587: FND_LOOKUP_VALUES

583:
584: select
585: count(tag) into l_count
586: from
587: FND_LOOKUP_VALUES
588: where
589: LOOKUP_CODE <> 'VAD' AND
590: lookup_type = 'PV_PARTNER_TYPE_RANKING' AND
591: language = userenv('LANG') and