eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_GENERAL dependencies on PER_PEOPLE_EXTRA_INFO

Line 1324: ,p_COLUMN_NAME in per_people_extra_info.PEI_INFORMATION3%TYPE

1320: PROCEDURE INS_OR_UPD_PERSON_EIT_COLUMN
1321: ( p_person_id IN NUMBER
1322: ,p_new_value in VARCHAR2
1323: ,p_Session_Date in VARCHAR2
1324: ,p_COLUMN_NAME in per_people_extra_info.PEI_INFORMATION3%TYPE
1325: ,p_dt_update_mode in varchar2
1326: )
1327: IS
1328: CURSOR CSR_PERSON_EIT

Line 1342: from per_people_extra_info

1338: pei_information4,
1339: pei_information5,
1340: pei_information6,
1341: pei_information7
1342: from per_people_extra_info
1343: where information_type='FI_PENSION'
1344: AND PEI_INFORMATION_CATEGORY='FI_PENSION'
1345: AND PEI_INFORMATION3=p_COLUMN_NAME
1346: AND PERSON_ID = P_PERSON_ID;

Line 1349: L_OVN per_people_extra_info.object_version_number%TYPE;

1345: AND PEI_INFORMATION3=p_COLUMN_NAME
1346: AND PERSON_ID = P_PERSON_ID;
1347:
1348: LR_PERSON_EIT CSR_PERSON_EIT%ROWTYPE;
1349: L_OVN per_people_extra_info.object_version_number%TYPE;
1350: L_person_extra_info_id number;
1351: l_Action VARCHAR2(3);
1352:
1353: BEGIN