APPS.PAY_SA_GOSI_REPORTS dependencies on FND_PROFILE

Line 783: if (upper(l_nationality) = UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY'))) then

779: vCtr := vCtr + 1;
780: vXMLTable(vCtr).TagName := 'G5-B-04'||'-'||l_new_count||'x10';
781: /*Check for Civil Id for Saudi nationals and Passport Number for Non Saudis.*/
782: if (get_pid_new%found) then
783: if (upper(l_nationality) = UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY'))) then
784: l_civil_id := null;
785: open get_civil_id(l_person_id,l_effective_date_p);
786: fetch get_civil_id into l_civil_id;
787: close get_civil_id;

Line 1439: l_def_nationality_cd := UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')); --'AM'; -- UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY'));

1435: from dual;
1436: /* Following one line changed for enhancement 5283457
1437: l_prev2_term_date := to_date('28-'||to_char(l_prev2_mon_date,'MM-YYYY'),'DD-MM-YYYY');*/
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'

Line 2104: and upper(nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')

2100: select count(*)
2101: into l_loc_nat
2102: from per_all_people_f
2103: where person_id = rec_leav_assact.person_id
2104: and upper(nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')
2105: and trunc(l_prev_mon_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
2106: if l_loc_nat > 0 then
2107: l_sum_saudi_hazards_t := l_sum_saudi_hazards_t + l_assact_haz;
2108: end if;

Line 3486: IF upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') then

3482: vCtr := vCtr + 1;
3483: vXMLTable(vCtr).TagName := 'G3-N-09';
3484: vXMLTable(vCtr).TagValue := l_email_id;
3485: vCtr := vCtr + 1;
3486: IF upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') then
3487: open get_passport_number(l_person_id_new,l_effective_date);
3488: fetch get_passport_number into l_passport_number,l_passport_issue_date,l_passport_issue_place;
3489: close get_passport_number;
3490: vXMLTable(vCtr).TagName := 'G3-N-02-1';