APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_PERSON_NAME

Line 771: hr_person_name.get_person_name

767:
768: /*Cursor for fetching employee name*/
769: /*CURSOR csr_get_emp_name(p_person_id NUMBER) IS
770: SELECT --SUBSTR(full_name,1,30)
771: hr_person_name.get_person_name
772: (p_person_id
773: ,l_effective_date
774: ,'DISPLAY_NAME'
775: ,l_user_format)

Line 930: l_full_name := hr_person_name.get_person_name

926: l_full_name := NULL;
927: /*OPEN csr_get_emp_name(rec_get_emp.person_id);
928: FETCH csr_get_emp_name INTO l_full_name;
929: CLOSE csr_get_emp_name;*/
930: l_full_name := hr_person_name.get_person_name
931: (p_person_id => rec_get_emp.person_id
932: ,p_effective_date => l_effective_date
933: ,p_format_name => 'DISPLAY_NAME'
934: ,p_user_format_choice => l_user_format);

Line 1181: hr_person_name.get_person_name

1177:
1178: /*Cursor for fetching employee name*/
1179: /*CURSOR csr_get_emp_name(p_person_id NUMBER) IS
1180: SELECT --SUBSTR(full_name,1,30)
1181: hr_person_name.get_person_name
1182: (p_person_id
1183: ,l_effective_date
1184: ,'DISPLAY_NAME'
1185: ,l_user_format)

Line 1485: l_full_name := hr_person_name.get_person_name

1481: l_full_name := NULL;
1482: /*OPEN csr_get_emp_name(rec_get_emp.person_id);
1483: FETCH csr_get_emp_name INTO l_full_name;
1484: CLOSE csr_get_emp_name;*/
1485: l_full_name := hr_person_name.get_person_name
1486: (p_person_id => rec_get_emp.person_id
1487: ,p_effective_date => l_effective_date
1488: ,p_format_name => 'DISPLAY_NAME'
1489: ,p_user_format_choice => l_user_format);

Line 1906: hr_person_name.get_person_name

1902:
1903: /*Cursor for fetching employee name*/
1904: CURSOR csr_get_emp_name(p_person_id NUMBER) IS
1905: SELECT /*full_name
1906: hr_person_name.get_person_name
1907: (p_person_id
1908: ,l_effective_date
1909: ,'DISPLAY_NAME'
1910: ,l_user_format)*/

Line 2218: l_full_name := hr_person_name.get_person_name

2214: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
2215: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2216: CLOSE csr_get_emp_name;
2217:
2218: l_full_name := hr_person_name.get_person_name
2219: (p_person_id => t_new_store_assact(j).person_id
2220: ,p_effective_date => l_effective_date
2221: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2222: ,p_user_format_choice => l_user_format);

Line 2273: l_full_name := hr_person_name.get_person_name

2269: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2270:
2271:
2272: CLOSE csr_get_emp_name;
2273: l_full_name := hr_person_name.get_person_name
2274: (p_person_id => t_ter_store_assact(l).person_id
2275: ,p_effective_date => l_effective_date
2276: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2277: ,p_user_format_choice => l_user_format);

Line 2343: l_full_name := hr_person_name.get_person_name

2339: l_full_name := NULL;
2340: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2341: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2342: CLOSE csr_get_emp_name;
2343: l_full_name := hr_person_name.get_person_name
2344: (p_person_id => t_cha_store_assact(n).person_id
2345: ,p_effective_date => l_effective_date
2346: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2347: ,p_user_format_choice => l_user_format);

Line 2402: l_full_name := hr_person_name.get_person_name

2398: CLOSE csr_get_emp_name;
2399:
2400: hr_utility.set_location('l_civil_id'|| l_civil_id,30);
2401:
2402: l_full_name := hr_person_name.get_person_name
2403: (p_person_id => t_new_store_assact(j).person_id
2404: ,p_effective_date => l_effective_date
2405: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2406: ,p_user_format_choice => l_user_format);

Line 2467: l_full_name := hr_person_name.get_person_name

2463: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2464: CLOSE csr_get_emp_name;
2465:
2466: hr_utility.set_location('l_civil_id'|| l_civil_id,30);
2467: l_full_name := hr_person_name.get_person_name
2468: (p_person_id => t_ter_store_assact(l).person_id
2469: ,p_effective_date => l_effective_date
2470: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2471: ,p_user_format_choice => l_user_format);

Line 2555: l_full_name := hr_person_name.get_person_name

2551:
2552: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2553: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2554: CLOSE csr_get_emp_name;
2555: l_full_name := hr_person_name.get_person_name
2556: (p_person_id => t_cha_store_assact(n).person_id
2557: ,p_effective_date => l_effective_date
2558: ,p_format_name => 'FULL_NAME' --'DISPLAY_NAME'
2559: ,p_user_format_choice => l_user_format);