APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_PERSON_NAME

Line 620: hr_person_name.get_person_name

616:
617: /*Cursor for fetching employee name*/
618: /*CURSOR csr_get_emp_name(p_person_id NUMBER) IS
619: SELECT --SUBSTR(full_name,1,30)
620: hr_person_name.get_person_name
621: (p_person_id
622: ,l_effective_date
623: ,'DISPLAY_NAME'
624: ,l_user_format)

Line 779: l_full_name := hr_person_name.get_person_name

775: l_full_name := NULL;
776: /*OPEN csr_get_emp_name(rec_get_emp.person_id);
777: FETCH csr_get_emp_name INTO l_full_name;
778: CLOSE csr_get_emp_name;*/
779: l_full_name := hr_person_name.get_person_name
780: (p_person_id => rec_get_emp.person_id
781: ,p_effective_date => l_effective_date
782: ,p_format_name => 'DISPLAY_NAME'
783: ,p_user_format_choice => l_user_format);

Line 1030: hr_person_name.get_person_name

1026:
1027: /*Cursor for fetching employee name*/
1028: /*CURSOR csr_get_emp_name(p_person_id NUMBER) IS
1029: SELECT --SUBSTR(full_name,1,30)
1030: hr_person_name.get_person_name
1031: (p_person_id
1032: ,l_effective_date
1033: ,'DISPLAY_NAME'
1034: ,l_user_format)

Line 1334: l_full_name := hr_person_name.get_person_name

1330: l_full_name := NULL;
1331: /*OPEN csr_get_emp_name(rec_get_emp.person_id);
1332: FETCH csr_get_emp_name INTO l_full_name;
1333: CLOSE csr_get_emp_name;*/
1334: l_full_name := hr_person_name.get_person_name
1335: (p_person_id => rec_get_emp.person_id
1336: ,p_effective_date => l_effective_date
1337: ,p_format_name => 'DISPLAY_NAME'
1338: ,p_user_format_choice => l_user_format);

Line 1747: hr_person_name.get_person_name

1743:
1744: /*Cursor for fetching employee name*/
1745: CURSOR csr_get_emp_name(p_person_id NUMBER) IS
1746: SELECT /*full_name
1747: hr_person_name.get_person_name
1748: (p_person_id
1749: ,l_effective_date
1750: ,'DISPLAY_NAME'
1751: ,l_user_format)*/

Line 1980: l_full_name := hr_person_name.get_person_name

1976: OPEN csr_get_emp_name(t_new_store_assact(j).person_id);
1977: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
1978: CLOSE csr_get_emp_name;
1979:
1980: l_full_name := hr_person_name.get_person_name
1981: (p_person_id => t_new_store_assact(j).person_id
1982: ,p_effective_date => l_effective_date
1983: ,p_format_name => 'DISPLAY_NAME'
1984: ,p_user_format_choice => l_user_format);

Line 2033: l_full_name := hr_person_name.get_person_name

2029: l_full_name := NULL;
2030: OPEN csr_get_emp_name(t_ter_store_assact(l).person_id);
2031: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2032: CLOSE csr_get_emp_name;
2033: l_full_name := hr_person_name.get_person_name
2034: (p_person_id => t_ter_store_assact(l).person_id
2035: ,p_effective_date => l_effective_date
2036: ,p_format_name => 'DISPLAY_NAME'
2037: ,p_user_format_choice => l_user_format);

Line 2103: l_full_name := hr_person_name.get_person_name

2099: l_full_name := NULL;
2100: OPEN csr_get_emp_name(t_cha_store_assact(n).person_id);
2101: FETCH csr_get_emp_name INTO /*l_full_name,*/ l_civil_id;
2102: CLOSE csr_get_emp_name;
2103: l_full_name := hr_person_name.get_person_name
2104: (p_person_id => t_cha_store_assact(n).person_id
2105: ,p_effective_date => l_effective_date
2106: ,p_format_name => 'DISPLAY_NAME'
2107: ,p_user_format_choice => l_user_format);