APPS.PAY_IN_MED_WEB_ADI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 165: FROM per_assignment_extra_info pae

161:
162: CURSOR c_get_prev_amts
163: IS
164: SELECT pae.aei_information7, pae.aei_information11
165: FROM per_assignment_extra_info pae
166: WHERE pae.assignment_extra_info_id = p_assignment_extra_info_id;
167:
168: CURSOR c_element(p_element_type_id NUMBER)
169: IS

Line 206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

202: l_start_date DATE ;
203: l_end_date DATE ;
204: l_effective_start_date DATE ;
205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

Line 207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;

203: l_end_date DATE ;
204: l_effective_start_date DATE ;
205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;

Line 747: UPDATE per_assignment_extra_info

743:
744:
745:
746:
747: UPDATE per_assignment_extra_info
748: SET AEI_INFORMATION7 = p_approved_bill_amount
749: ,AEI_INFORMATION9 = p_employer_remarks
750: ,AEI_INFORMATION10 = nvl(l_bill_entry_id,l_element_entry_id)
751: ,AEI_INFORMATION11 = l_ben_entry_id

Line 832: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

828: l_count NUMBER;
829: l_element_type_id NUMBER;
830: l_start_date DATE ;
831: l_end_date DATE ;
832: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
833:
834:
835:
836: BEGIN

Line 1067: FROM per_assignment_extra_info pae

1063: CURSOR c_get_prev_amts
1064: IS
1065: SELECT pae.aei_information9,
1066: pae.aei_information10
1067: FROM per_assignment_extra_info pae
1068: WHERE pae.assignment_extra_info_id = p_assignment_extra_info_id;
1069:
1070: CURSOR c_element(p_element_type_id NUMBER)
1071: IS

Line 1103: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

1099: l_element_entry_id NUMBER := NULL ;
1100: l_start_date DATE ;
1101: l_end_date DATE ;
1102: l_effective_start_date DATE ;
1103: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1104: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
1105: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
1106: l_submitted NUMBER ;
1107: l_prev_submitted NUMBER ;

Line 1466: UPDATE per_assignment_extra_info

1462: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
1463:
1464: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
1465:
1466: UPDATE per_assignment_extra_info
1467: SET AEI_INFORMATION10 = P_EXEMPTED
1468: ,AEI_INFORMATION6 = P_ER_COMMENTS
1469: ,AEI_INFORMATION11 = nvl(l_element_entry_id,p_element_entry_id)
1470: ,aei_information18 = P_CARRY_OVER

Line 1558: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;

1554: l_count NUMBER;
1555: l_element_type_id NUMBER;
1556: l_start_date DATE ;
1557: l_end_date DATE ;
1558: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1559: l_session NUMBER ;
1560:
1561:
1562:

Line 1675: UPDATE per_assignment_extra_info

1671:
1672:
1673: END IF ;
1674:
1675: UPDATE per_assignment_extra_info
1676: SET AEI_INFORMATION18 = p_carry
1677: where AEI_INFORMATION11 = p_element_entry_id
1678: and assignment_id = p_assignment_id;
1679: