APPS.PAY_KR_HIA_PKG dependencies on PER_ASSIGNMENTS_F

Line 111: FROM per_assignments_f asg,

107: CURSOR csr_asg -- 3506171
108: IS
109: SELECT DISTINCT asg.assignment_id,
110: asg.establishment_id
111: FROM per_assignments_f asg,
112: pay_payroll_actions xppa,
113: hr_organization_units hou1,
114: hr_organization_information hoi1
115: WHERE xppa.payroll_action_id = p_payroll_action_id

Line 282: FROM per_assignments_f pa,

278: IS
279: SELECT paa.assignment_id,
280: pa.payroll_id,
281: pa.establishment_id -- 3506171
282: FROM per_assignments_f pa,
283: pay_assignment_actions paa
284: WHERE paa.assignment_action_id = p_assignment_action_id
285: AND pa.assignment_id = paa.assignment_id
286: AND g_pact.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date;

Line 299: per_assignments_f pa,

295: hhoi.org_information1 business_place_code,
296: NULL business_place_unit
297: FROM per_people_extra_info pei,
298: per_people_f pp,
299: per_assignments_f pa,
300: pay_assignment_actions paa,
301: pay_payroll_actions ppa,
302: hr_organization_information hhoi,
303: per_periods_of_service pds

Line 369: per_assignments_f pa,

365: Cursor csr_last_year_asg_action
366: IS
367: SELECT paa.assignment_action_id
368: FROM pay_assignment_actions paa,
369: per_assignments_f pa,
370: pay_payroll_actions ppa
371: WHERE pa.assignment_id = l_assignment_id
372: AND paa.assignment_id = l_assignment_id
373: AND paa.assignment_id = pa.assignment_id