DBA Data[Home] [Help]

APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_PEOPLE_EXTRA_INFO

Line 33: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;

29: (p_person_extra_info_id IN NUMBER
30: ,p_object_version_number IN NUMBER
31: )
32: IS
33: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
34: l_procedure VARCHAR2(80);
35: l_org_information_type per_people_extra_info.information_type%TYPE;
36: l_departure_date VARCHAR2(20);
37: l_visa_number VARCHAR2(80);

Line 35: l_org_information_type per_people_extra_info.information_type%TYPE;

31: )
32: IS
33: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
34: l_procedure VARCHAR2(80);
35: l_org_information_type per_people_extra_info.information_type%TYPE;
36: l_departure_date VARCHAR2(20);
37: l_visa_number VARCHAR2(80);
38:
39: CURSOR csr_get_org_information_type IS

Line 41: FROM per_people_extra_info

37: l_visa_number VARCHAR2(80);
38:
39: CURSOR csr_get_org_information_type IS
40: SELECT information_type
41: FROM per_people_extra_info
42: WHERE person_extra_info_id = p_person_extra_info_id;
43:
44: CURSOR csr_check_detail_info_exists IS
45: SELECT detail.person_extra_info_id

Line 46: FROM per_people_extra_info detail

42: WHERE person_extra_info_id = p_person_extra_info_id;
43:
44: CURSOR csr_check_detail_info_exists IS
45: SELECT detail.person_extra_info_id
46: FROM per_people_extra_info detail
47: WHERE detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
48: AND p_person_extra_info_id=detail.pei_information1;
49:
50: CURSOR csr_check_visa_info_used IS

Line 52: FROM per_people_extra_info detail,per_people_extra_info visa

48: AND p_person_extra_info_id=detail.pei_information1;
49:
50: CURSOR csr_check_visa_info_used IS
51: SELECT detail.person_extra_info_id
52: FROM per_people_extra_info detail,per_people_extra_info visa
53: WHERE detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
54: AND detail.pei_information5 = visa.pei_information1
55: AND visa.person_extra_info_id = p_person_extra_info_id;
56:

Line 59: FROM per_people_extra_info

55: AND visa.person_extra_info_id = p_person_extra_info_id;
56:
57: CURSOR csr_get_departure_date IS
58: SELECT pei_information1
59: FROM per_people_extra_info
60: WHERE information_type = 'PER_ABROAD_MASTER_INFO_CN'
61: AND person_extra_info_id = p_person_extra_info_id;
62:
63: CURSOR csr_get_visa_number IS

Line 65: FROM per_people_extra_info

61: AND person_extra_info_id = p_person_extra_info_id;
62:
63: CURSOR csr_get_visa_number IS
64: SELECT pei_information1
65: FROM per_people_extra_info
66: WHERE information_type = 'PER_VISA_INFO_CN'
67: AND person_extra_info_id = p_person_extra_info_id;
68:
69: BEGIN