APPS.PER_PL_AEI_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 35: from per_assignment_extra_info

31:
32:
33: cursor csr_payment_condition_ins is
34: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
35: from per_assignment_extra_info
36: where information_type='PL_PAYMENT_CONDITIONS'
37: and ASSIGNMENT_ID=p_assignment_id
38: and aei_information_category='PL_PAYMENT_CONDITIONS'
39: and AEI_INFORMATION3=p_AEI_INFORMATION3

Line 126: from per_assignment_extra_info

122: l_assignment_id number;
123:
124: cursor csr_assignment_id is
125: select assignment_id
126: from per_assignment_extra_info
127: where information_type='PL_PAYMENT_CONDITIONS'
128: and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
129:
130: cursor csr_payment_condition_upd(r_assignment_id in number) is

Line 132: from per_assignment_extra_info

128: and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
129:
130: cursor csr_payment_condition_upd(r_assignment_id in number) is
131: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
132: from per_assignment_extra_info
133: where information_type='PL_PAYMENT_CONDITIONS'
134: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
135: and aei_information_category='PL_PAYMENT_CONDITIONS'
136: and AEI_INFORMATION3=p_AEI_INFORMATION3

Line 134: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id

130: cursor csr_payment_condition_upd(r_assignment_id in number) is
131: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
132: from per_assignment_extra_info
133: where information_type='PL_PAYMENT_CONDITIONS'
134: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
135: and aei_information_category='PL_PAYMENT_CONDITIONS'
136: and AEI_INFORMATION3=p_AEI_INFORMATION3
137: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
138: and (

Line 228: from per_assignment_extra_info

224:
225:
226: cursor csr_work_condition_date_ins is
227: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
228: from per_assignment_extra_info
229: where information_type='PL_OTHER_WORK_CONDITIONS'
230: and ASSIGNMENT_ID=p_assignment_id
231: and aei_information_category=p_aei_information_category
232: and AEI_INFORMATION3=p_AEI_INFORMATION3

Line 362: from per_assignment_extra_info

358:
359:
360: cursor csr_assignment_id is
361: select assignment_id
362: from per_assignment_extra_info
363: where information_type='PL_OTHER_WORK_CONDITIONS'
364: and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
365:
366: cursor csr_work_condition_date_upd(r_assignment_id in number) is

Line 368: from per_assignment_extra_info

364: and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
365:
366: cursor csr_work_condition_date_upd(r_assignment_id in number) is
367: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
368: from per_assignment_extra_info
369: where information_type='PL_OTHER_WORK_CONDITIONS'
370: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
371: and aei_information_category=p_aei_information_category
372: and AEI_INFORMATION3=p_AEI_INFORMATION3

Line 370: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id

366: cursor csr_work_condition_date_upd(r_assignment_id in number) is
367: select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
368: from per_assignment_extra_info
369: where information_type='PL_OTHER_WORK_CONDITIONS'
370: and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
371: and aei_information_category=p_aei_information_category
372: and AEI_INFORMATION3=p_AEI_INFORMATION3
373: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374: and (