APPS.PER_PEOPLE3_PKG dependencies on FND_COMMON_LOOKUPS

Line 971: from fnd_common_lookups fcl

967: if (p_legislation_code = 'US') then
968: if (p_ethnic_code is not null) then
969: select fcl.meaning
970: into p_ethnic_meaning
971: from fnd_common_lookups fcl
972: where fcl.lookup_type = 'US_ETHNIC_GROUP'
973: and application_id = 800
974: and fcl.lookup_code = p_ethnic_code;
975: end if;

Line 979: from fnd_common_lookups fcl

975: end if;
976: if (p_visa_code is not null) then
977: select fcl.meaning
978: into p_visa_meaning
979: from fnd_common_lookups fcl
980: where fcl.lookup_type = 'US_VISA_TYPE'
981: and application_id = 800
982: and fcl.lookup_code = p_visa_code;
983: end if;

Line 987: from fnd_common_lookups fcl

983: end if;
984: if (p_veteran_code is not null) then
985: select fcl.meaning
986: into p_veteran_meaning
987: from fnd_common_lookups fcl
988: where fcl.lookup_type = 'US_VETERAN_STATUS'
989: and application_id = 800
990: and fcl.lookup_code = p_veteran_code;
991: end if;

Line 995: from fnd_common_lookups fcl

991: end if;
992: if (p_i9_code is not null) then
993: select fcl.meaning
994: into p_i9_meaning
995: from fnd_common_lookups fcl
996: where fcl.lookup_type = 'PER_US_I9_STATE'
997: and application_id = 800
998: and fcl.lookup_code = p_i9_code;
999: end if;

Line 1003: from fnd_common_lookups fcl

999: end if;
1000: if (p_new_hire_code is not null) then
1001: select fcl.meaning
1002: into p_new_hire_meaning
1003: from fnd_common_lookups fcl
1004: where fcl.lookup_type = 'US_NEW_HIRE_STATUS'
1005: and application_id = 800
1006: and fcl.lookup_code = p_new_hire_code;
1007: end if;

Line 1011: from fnd_common_lookups fcl

1007: end if;
1008: if (p_reason_for_code is not null) then
1009: select fcl.meaning
1010: into p_reason_for_meaning
1011: from fnd_common_lookups fcl
1012: where fcl.lookup_type = 'US_NEW_HIRE_EXCEPTIONS'
1013: and application_id = 800
1014: and fcl.lookup_code = p_reason_for_code;
1015: end if;

Line 1019: from fnd_common_lookups fcl

1015: end if;
1016: if (p_ethnic_disc_code is not null) then
1017: select fcl.meaning
1018: into p_ethnic_disc_meaning
1019: from fnd_common_lookups fcl
1020: where fcl.lookup_type = 'US_ETHNIC_DISCLOSURE'
1021: and application_id = 800
1022: and fcl.lookup_code = p_ethnic_disc_code;
1023: end if;

Line 1027: from fnd_common_lookups fcl

1023: end if;
1024: if (p_vets100A_code is not null) then
1025: select fcl.meaning
1026: into p_vets100A_meaning
1027: from fnd_common_lookups fcl
1028: where fcl.lookup_type = 'US_VETERAN_STATUS_VETS100A'
1029: and application_id = 800
1030: and fcl.lookup_code = p_vets100A_code;
1031: end if;

Line 1036: from fnd_common_lookups fcl

1032: elsif (p_legislation_code = 'GB') then
1033: if (p_ethnic_code is not null) then
1034: select fcl.meaning
1035: into p_ethnic_meaning
1036: from fnd_common_lookups fcl
1037: where fcl.lookup_type = 'ETH_TYPE'
1038: and application_id = 800
1039: and fcl.lookup_code = p_ethnic_code;
1040: end if;