DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on FND_PROFILE_OPTION_VALUES

Line 605: lValue fnd_profile_option_values.profile_option_value%type;

601: profile_val in number)
602: return integer
603: is
604:
605: lValue fnd_profile_option_values.profile_option_value%type;
606: loldvalue fnd_profile_option_values.profile_option_value%type;
607: lValidOrg number;
608:
609:

Line 606: loldvalue fnd_profile_option_values.profile_option_value%type;

602: return integer
603: is
604:
605: lValue fnd_profile_option_values.profile_option_value%type;
606: loldvalue fnd_profile_option_values.profile_option_value%type;
607: lValidOrg number;
608:
609:
610: cursor validation_org is

Line 613: fnd_profile_option_values POV,

609:
610: cursor validation_org is
611: select distinct POV.profile_option_value
612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2
617: where PO.profile_option_name = 'SO_ORGANIZATION_ID'

Line 616: fnd_profile_option_values POV2

612: from fnd_profile_options PO ,
613: fnd_profile_option_values POV,
614: fnd_responsibility FR,
615: fnd_profile_options PO2,
616: fnd_profile_option_values POV2
617: where PO.profile_option_name = 'SO_ORGANIZATION_ID'
618: and POV.application_id = PO.application_id
619: and POV.profile_option_id = PO.profile_option_id
620: and POV.level_id = 10003