APPS.PAY_FI_TELR dependencies on PER_PEOPLE_EXTRA_INFO

Line 22: l_EIT_PG_Action_Type per_people_extra_info.pei_information6%TYPE;

18:
19: L_TARGET_YEAR VARCHAR2(4);
20: l_TEL_Action_id varchar2(30);
21:
22: l_EIT_PG_Action_Type per_people_extra_info.pei_information6%TYPE;
23: l_SHIFT_FROM_TEL DATE;
24: l_EIT_PT_value per_people_extra_info.pei_information6%TYPE;
25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;
26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;

Line 24: l_EIT_PT_value per_people_extra_info.pei_information6%TYPE;

20: l_TEL_Action_id varchar2(30);
21:
22: l_EIT_PG_Action_Type per_people_extra_info.pei_information6%TYPE;
23: l_SHIFT_FROM_TEL DATE;
24: l_EIT_PT_value per_people_extra_info.pei_information6%TYPE;
25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;
26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;
27:
28:

Line 25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;

21:
22: l_EIT_PG_Action_Type per_people_extra_info.pei_information6%TYPE;
23: l_SHIFT_FROM_TEL DATE;
24: l_EIT_PT_value per_people_extra_info.pei_information6%TYPE;
25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;
26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;
27:
28:
29: l_EIT_Action_Type per_people_extra_info.pei_information6%TYPE;

Line 26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;

22: l_EIT_PG_Action_Type per_people_extra_info.pei_information6%TYPE;
23: l_SHIFT_FROM_TEL DATE;
24: l_EIT_PT_value per_people_extra_info.pei_information6%TYPE;
25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;
26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;
27:
28:
29: l_EIT_Action_Type per_people_extra_info.pei_information6%TYPE;
30: l_EIT_IsReported per_people_extra_info.pei_information5%TYPE;

Line 29: l_EIT_Action_Type per_people_extra_info.pei_information6%TYPE;

25: l_EIT_PT_Reported per_people_extra_info.pei_information5%TYPE;
26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;
27:
28:
29: l_EIT_Action_Type per_people_extra_info.pei_information6%TYPE;
30: l_EIT_IsReported per_people_extra_info.pei_information5%TYPE;
31: L_LEL_EMPLOYMENT_START_DATE DATE;
32:
33: l_TIME_RECORD_1 boolean :=false;

Line 30: l_EIT_IsReported per_people_extra_info.pei_information5%TYPE;

26: l_EIT_PG_Reported per_people_extra_info.pei_information5%TYPE;
27:
28:
29: l_EIT_Action_Type per_people_extra_info.pei_information6%TYPE;
30: l_EIT_IsReported per_people_extra_info.pei_information5%TYPE;
31: L_LEL_EMPLOYMENT_START_DATE DATE;
32:
33: l_TIME_RECORD_1 boolean :=false;
34: l_TIME_RECORD_2 boolean :=false;

Line 38: L_OVN per_people_extra_info.object_version_number%TYPE;

34: l_TIME_RECORD_2 boolean :=false;
35: l_TIME_RECORD_5 boolean :=false;
36:
37:
38: L_OVN per_people_extra_info.object_version_number%TYPE;
39: /* End of declaration*/
40: /* Cursors */
41:
42: Cursor csr_TEL_PERSON_DETAILS(

Line 105: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )

101:
102: CURSOR CSR_EIT_DETAILS (
103: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,
104: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,
105: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )
106: IS
107: SELECT *
108: FROM PAY_ACTION_INFORMATION
109: WHERE ACTION_CONTEXT_TYPE = 'AAP'

Line 121: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE

117: LR_EIT_DETAILS CSR_EIT_DETAILS%ROWTYPE;
118:
119: CURSOR CSR_PERSON_EIT (
120: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,
121: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE
122: )
123: IS
124: select PERSON_EXTRA_INFO_ID,
125: object_version_number,

Line 136: from per_people_extra_info

132: pei_information4,
133: pei_information5,
134: pei_information6,
135: pei_information7
136: from per_people_extra_info
137: where information_type='FI_PENSION'
138: AND PEI_INFORMATION_CATEGORY='FI_PENSION'
139: AND PEI_INFORMATION3=CSR_V_COLUMN_NAME
140: AND PERSON_ID = CSR_V_PERSON_ID;