APPS.PAY_FI_TELR dependencies on PER_ALL_PEOPLE_F

Line 59: ,CSR_V_PERSON_ID per_all_people_f.person_id%TYPE

55: --lr_TEL_PERSON_DETAILS csr_TEL_PERSON_DETAILS%rowtype;
56:
57: Cursor csr_TEL_PER1_DETAILS(
58: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
59: ,CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
60: )
61: IS
62: SELECT ACTION_INFORMATION4 FIRST_CODE,
63: decode(ACTION_INFORMATION6,null,

Line 104: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,

100: LR_REPORT_DETAILS CSR_REPORT_DETAILS%rowtype;
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

Line 120: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,

116:
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,

Line 147: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE

143:
144: -- for searching record 2 type
145: CURSOR CSR_RECORD_TWO_TYPE (
146: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,
147: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
148: )IS
149: SELECT DISTINCT(ACTION_INFORMATION3) "FOUND"
150: FROM PAY_ACTION_INFORMATION pai
151: WHERE pai.ACTION_CONTEXT_TYPE = 'AAP'