APPS.PAY_SA_GOSI_REPORTS dependencies on HR_LOOKUPS

Line 744: FROM HR_LOOKUPS H, FND_SESSIONS S

740: vXMLTable(vCtr).TagValue := null;
741: else
742: begin
743: SELECT meaning INTO l_nationality_mn
744: FROM HR_LOOKUPS H, FND_SESSIONS S
745: WHERE LOOKUP_TYPE = 'NATIONALITY'
746: AND ENABLED_FLAG = 'Y'
747: AND LOOKUP_CODE = l_nationality
748: AND SESSION_ID = USERENV('SESSIONID')

Line 968: FROM hr_lookups hl

964: if (get_pid_term %notfound or l_leaver_this_month_flag = 'N' ) then
965: vXMLTable(vCtr).TagValue := null;
966: else
967: /*SELECT meaning INTO l_term_reason_mn
968: FROM hr_lookups hl
969: WHERE hl.lookup_type = 'LEAV_REAS'
970: AND to_date(l_effective_date'DD-MM-YYYY')
971: between nvl(hl.start_date_active,to_date( and hl.end_date_active
972: AND hl.lookup_code = l_term_reason;*/

Line 975: FROM HR_LOOKUPS H, FND_SESSIONS S

971: between nvl(hl.start_date_active,to_date( and hl.end_date_active
972: AND hl.lookup_code = l_term_reason;*/
973: BEGIN
974: SELECT meaning INTO l_term_reason_mn
975: FROM HR_LOOKUPS H, FND_SESSIONS S
976: WHERE LOOKUP_TYPE = 'LEAV_REAS'
977: AND ENABLED_FLAG = 'Y'
978: AND LOOKUP_CODE = l_term_reason
979: AND SESSION_ID = USERENV('SESSIONID')

Line 1442: FROM hr_lookups

1438: l_prev2_term_date := last_day(l_prev2_mon_date);
1439: l_def_nationality_cd := UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')); --'AM'; -- UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY'));
1440: BEGIN
1441: SELECT meaning INTO l_def_nationality
1442: FROM hr_lookups
1443: WHERE lookup_type = 'NATIONALITY'
1444: AND lookup_code = l_def_nationality_cd;
1445: EXCEPTION
1446: WHEN NO_DATA_FOUND THEN

Line 2774: hr_lookups hlp,

2770: /*Cursor to pick up Employee's Work Location*/
2771: cursor get_work_location (l_assignment_id NUMBER) is
2772: select hlp.meaning --distinct TOWN_OR_CITY
2773: from hr_locations hl,
2774: hr_lookups hlp,
2775: per_all_assignments_f paa
2776: where hl.location_id = paa.location_id
2777: and paa.assignment_id = l_assignment_id
2778: and hlp.lookup_type = 'SA_CITY'

Line 3169: FROM hr_lookups hl

3165: If l_city is not null then
3166: BEGIN
3167: SELECT hl.meaning
3168: INTO l_city_mn
3169: FROM hr_lookups hl
3170: WHERE hl.lookup_type = 'SA_CITY'
3171: AND hl.lookup_code = l_city
3172: AND hl.enabled_flag = 'Y';
3173: END;

Line 3448: FROM hr_lookups hl

3444: l_nationality_mn := null;
3445: If l_nationality is not null then
3446: SELECT hl.meaning
3447: INTO l_nationality_mn
3448: FROM hr_lookups hl
3449: WHERE hl.lookup_type = 'NATIONALITY'
3450: and hl.lookup_code = l_nationality
3451: and hl.enabled_flag = 'Y';
3452: End If;