APPS.PQP_VRE_BUS dependencies on HR_LOOKUPS

Line 900: FROM hr_lookups

896: ,p_meaning OUT NOCOPY VARCHAR2
897: ) IS
898: CURSOR fiscal_cursor IS
899: SELECT meaning
900: FROM hr_lookups
901: WHERE lookup_type = 'PQP_FISCAL_RATINGS_UOM'
902: AND enabled_flag = 'Y';
903:
904: --Local variables

Line 905: l_meaning hr_lookups.meaning%TYPE;

901: WHERE lookup_type = 'PQP_FISCAL_RATINGS_UOM'
902: AND enabled_flag = 'Y';
903:
904: --Local variables
905: l_meaning hr_lookups.meaning%TYPE;
906: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
907: Begin
908:
909: --Getting the legislationId for business groupId

Line 939: -- Check if the argument value exists in hr_lookups

935: ) RETURN NUMBER IS
936: BEGIN
937: --
938: -- If argument value is not null then
939: -- Check if the argument value exists in hr_lookups
940: -- where the lookup_type is passed lookuptype
941: --
942: IF p_lookup_code IS NOT NULL then
943: IF hr_api.not_exists_in_dt_hrstanlookups

Line 958: FROM hr_lookups hrl

954: END;
955:
956: /* CURSOR csr_lookup(cp_argument_value VARCHAR2,cp_lookup_type VARCHAR2) IS
957: SELECT lookup_code
958: FROM hr_lookups hrl
959: WHERE hrl.lookup_type = cp_lookup_type
960: AND hrl.lookup_code = cp_argument_value
961: AND enabled_flag = 'Y';
962: BEGIN

Line 990: FROM hr_lookups hrl

986: ) RETURN NUMBER IS
987:
988: CURSOR csr_lookup(cp_argument_value VARCHAR2,cp_lookup_type VARCHAR2) IS
989: SELECT COUNT(rowid)
990: FROM hr_lookups hrl
991: WHERE hrl.lookup_type = cp_lookup_type
992: AND hrl.lookup_code = cp_argument_value
993: AND enabled_flag = 'Y';
994:

Line 995: l_lookup_code hr_lookups.lookup_code%TYPE;

991: WHERE hrl.lookup_type = cp_lookup_type
992: AND hrl.lookup_code = cp_argument_value
993: AND enabled_flag = 'Y';
994:
995: l_lookup_code hr_lookups.lookup_code%TYPE;
996: l_lookup_count NUMBER;
997: BEGIN
998: --
999: -- Validation of the lookup value based on the lookup type

Line 1336: ,hr_lookups hl

1332: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1333: FROM pqp_vehicle_allocations_f pva
1334: ,per_all_assignments_f paa
1335: ,per_people_f papf
1336: ,hr_lookups hl
1337: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1338: AND paa.assignment_id=pva.assignment_id
1339: AND papf.person_id=paa.person_id
1340: and hl.lookup_code=papf.title

Line 1394: ,hr_lookups hl

1390: SELECT distinct hl.meaning ||' '||papf.first_name ||' '|| papf.last_name
1391: FROM pqp_vehicle_allocations_f pva
1392: ,per_all_assignments_f paa
1393: ,per_people_f papf
1394: ,hr_lookups hl
1395: WHERE pva.vehicle_repository_id=p_rec.vehicle_repository_id
1396: AND paa.assignment_id=pva.assignment_id
1397: AND papf.person_id=paa.person_id
1398: and hl.lookup_code=papf.title