APPS.PER_PEOPLE3_PKG dependencies on FND_COMMON_LOOKUPS

Line 824: from fnd_common_lookups fcl

820: if (p_legislation_code = 'US') then
821: if (p_ethnic_code is not null) then
822: select fcl.meaning
823: into p_ethnic_meaning
824: from fnd_common_lookups fcl
825: where fcl.lookup_type = 'US_ETHNIC_GROUP'
826: and application_id = 800
827: and fcl.lookup_code = p_ethnic_code;
828: end if;

Line 832: from fnd_common_lookups fcl

828: end if;
829: if (p_visa_code is not null) then
830: select fcl.meaning
831: into p_visa_meaning
832: from fnd_common_lookups fcl
833: where fcl.lookup_type = 'US_VISA_TYPE'
834: and application_id = 800
835: and fcl.lookup_code = p_visa_code;
836: end if;

Line 840: from fnd_common_lookups fcl

836: end if;
837: if (p_veteran_code is not null) then
838: select fcl.meaning
839: into p_veteran_meaning
840: from fnd_common_lookups fcl
841: where fcl.lookup_type = 'US_VETERAN_STATUS'
842: and application_id = 800
843: and fcl.lookup_code = p_veteran_code;
844: end if;

Line 848: from fnd_common_lookups fcl

844: end if;
845: if (p_i9_code is not null) then
846: select fcl.meaning
847: into p_i9_meaning
848: from fnd_common_lookups fcl
849: where fcl.lookup_type = 'PER_US_I9_STATE'
850: and application_id = 800
851: and fcl.lookup_code = p_i9_code;
852: end if;

Line 856: from fnd_common_lookups fcl

852: end if;
853: if (p_new_hire_code is not null) then
854: select fcl.meaning
855: into p_new_hire_meaning
856: from fnd_common_lookups fcl
857: where fcl.lookup_type = 'US_NEW_HIRE_STATUS'
858: and application_id = 800
859: and fcl.lookup_code = p_new_hire_code;
860: end if;

Line 864: from fnd_common_lookups fcl

860: end if;
861: if (p_reason_for_code is not null) then
862: select fcl.meaning
863: into p_reason_for_meaning
864: from fnd_common_lookups fcl
865: where fcl.lookup_type = 'US_NEW_HIRE_EXCEPTIONS'
866: and application_id = 800
867: and fcl.lookup_code = p_reason_for_code;
868: end if;

Line 872: from fnd_common_lookups fcl

868: end if;
869: if (p_ethnic_disc_code is not null) then
870: select fcl.meaning
871: into p_ethnic_disc_meaning
872: from fnd_common_lookups fcl
873: where fcl.lookup_type = 'US_ETHNIC_DISCLOSURE'
874: and application_id = 800
875: and fcl.lookup_code = p_ethnic_disc_code;
876: end if;

Line 881: from fnd_common_lookups fcl

877: elsif (p_legislation_code = 'GB') then
878: if (p_ethnic_code is not null) then
879: select fcl.meaning
880: into p_ethnic_meaning
881: from fnd_common_lookups fcl
882: where fcl.lookup_type = 'ETH_TYPE'
883: and application_id = 800
884: and fcl.lookup_code = p_ethnic_code;
885: end if;