APPS.PAY_NO_K27_REIM_UPLD dependencies on PER_ALL_ASSIGNMENTS_F

Line 69: FROM pay_element_links_f links, per_all_assignments_f assign

65: input_val_rec6 input_val_csr%ROWTYPE;
66: --
67: CURSOR link_csr(p_element_type_id IN NUMBER) IS
68: SELECT links.element_link_id
69: FROM pay_element_links_f links, per_all_assignments_f assign
70: WHERE links.element_type_id = p_element_type_id
71: AND links.business_group_id=p_business_group_id
72: AND assign.assignment_id=p_assignment_id
73: AND (( links.payroll_id is not null

Line 102: per_all_assignments_f paaf,

98: CURSOR csr_payroll_periods
99: IS
100: select distinct ptp.start_date
101: from
102: per_all_assignments_f paaf,
103: pay_payrolls_f ppf,
104: per_time_periods ptp
105: where
106: paaf.assignment_id = p_assignment_id

Line 207: ,p_date IN per_all_assignments_f.effective_start_date%TYPE

203: FUNCTION get_element_link_id
204: (
205: p_assignment_id IN NUMBER
206: ,p_business_group_id IN NUMBER
207: ,p_date IN per_all_assignments_f.effective_start_date%TYPE
208: ,p_element_name IN pay_element_types_f.ELEMENT_NAME%TYPE
209: ) RETURN NUMBER
210: IS
211: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;

Line 222: FROM pay_element_links_f links, per_all_assignments_f assign

218:
219: Cursor csr_element_link_id(p_element_type_id NUMBER)
220: IS
221: SELECT links.element_link_id
222: FROM pay_element_links_f links, per_all_assignments_f assign
223: WHERE links.element_type_id = p_element_type_id
224: AND links.business_group_id= p_business_group_id
225: AND assign.assignment_id= p_assignment_id
226: AND (( links.payroll_id is not null

Line 407: ,p_date per_all_assignments_f.effective_start_date%TYPE)

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
411: , per_all_people_f PAP

Line 410: FROM per_all_assignments_f PAA

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
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')

Line 426: ,p_date per_all_assignments_f.effective_start_date%TYPE

422:
423: CURSOR csr_asg_lu_id
424: ( p_business_group_id per_business_groups.business_group_id%TYPE
425: ,p_asg_id NUMBER
426: ,p_date per_all_assignments_f.effective_start_date%TYPE
427: )
428: IS
429: select distinct SEGMENT2
430: from

Line 431: per_all_assignments_f paaf,

427: )
428: IS
429: select distinct SEGMENT2
430: from
431: per_all_assignments_f paaf,
432: hr_soft_coding_keyflex hsck
433: where
434: paaf.assignment_id = p_asg_id
435: and paaf.business_group_id = p_business_group_id

Line 1276: per_all_assignments_f paaf ,

1272: to_char(to_date(pai.action_information13,'RRRRMMDD'),'DD-MON-RRRR') Reimb_date,
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