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_NO_K27_REIM_UPLD dependencies on PER_ALL_PEOPLE_F

Line 406: ,p_ni_number per_all_people_f.national_identifier%TYPE

402: l_format_altered VARCHAR2(1) := 'N';
403:
404: CURSOR csr_get_prim_assg
405: ( p_business_group_id per_business_groups.business_group_id%TYPE
406: ,p_ni_number per_all_people_f.national_identifier%TYPE
407: ,p_date per_all_assignments_f.effective_start_date%TYPE)
408: IS
409: SELECT distinct PAA.ASSIGNMENT_ID, PAA.PAYROLL_ID
410: FROM per_all_assignments_f PAA

Line 411: , per_all_people_f PAP

407: ,p_date per_all_assignments_f.effective_start_date%TYPE)
408: IS
409: SELECT distinct PAA.ASSIGNMENT_ID, PAA.PAYROLL_ID
410: FROM per_all_assignments_f PAA
411: , per_all_people_f PAP
412: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
413: AND PAP.per_information_category ='NO'
414: AND (substr(PAP.NATIONAL_IDENTIFIER,1,6)||substr(PAP.NATIONAL_IDENTIFIER,8,5) = lpad(p_ni_number,11,'0')
415: OR PAP.NATIONAL_IDENTIFIER = lpad(p_ni_number,11,'0'))

Line 1277: per_all_people_f papf

1273: papf.employee_number emp_number,
1274: pai.action_information11 reimburse_amount FROM
1275: pay_action_information pai,
1276: per_all_assignments_f paaf ,
1277: per_all_people_f papf
1278: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1279: and pai.action_information1 = 'K27_REIMB_UPLOAD'
1280: and pai.action_information3 = p_legal_employer
1281: and to_date(pai.action_information13,'RRRRMMDD') BETWEEN p_from_dt AND p_to_dt