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:
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
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'
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