DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on FND_PROFILE_OPTION_VALUES

Line 680: lValue fnd_profile_option_values.profile_option_value%type;

676: profile_val in number)
677: return integer
678: is
679:
680: lValue fnd_profile_option_values.profile_option_value%type;
681: loldvalue fnd_profile_option_values.profile_option_value%type;
682: lValidOrg number;
683:
684:

Line 681: loldvalue fnd_profile_option_values.profile_option_value%type;

677: return integer
678: is
679:
680: lValue fnd_profile_option_values.profile_option_value%type;
681: loldvalue fnd_profile_option_values.profile_option_value%type;
682: lValidOrg number;
683:
684:
685: cursor validation_org is

Line 688: fnd_profile_option_values POV,

684:
685: cursor validation_org is
686: select distinct POV.profile_option_value
687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2
692: where PO.profile_option_name = 'SO_ORGANIZATION_ID'

Line 691: fnd_profile_option_values POV2

687: from fnd_profile_options PO ,
688: fnd_profile_option_values POV,
689: fnd_responsibility FR,
690: fnd_profile_options PO2,
691: fnd_profile_option_values POV2
692: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
693: and POV.application_id = PO.application_id
694: and POV.profile_option_id = PO.profile_option_id
695: and POV.level_id = 10003