DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PER_ASSIGNMENTS_F

Line 278: ,per_assignments_f paf

274: ,pay_action_information pai_prsi /* prsi Details 5657992 */
275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf
279: ,per_periods_of_service pps
280: ,pay_ie_paye_details_f payef -- 10277535
281: ,pay_ie_prsi_details_f prsif
282: ,pay_all_payrolls_f PAPF

Line 490: ,per_assignments_f asg

486: v_paye_ref NUMBER) IS
487:
488: SELECT max(pps.period_of_service_id)
489: FROM per_periods_of_service pps
490: ,per_assignments_f asg
491: ,pay_all_payrolls_f pay
492: ,hr_soft_coding_keyflex flex
493: WHERE pps.person_id = v_person_id
494: AND pps.person_id = asg.person_id

Line 513: FROM per_assignments_f

509: FROM pay_assignment_Actions paa,
510: pay_payroll_actions ppa
511:
512: WHERE paa.assignment_id in (SELECT assignment_id
513: FROM per_assignments_f
514: WHERE period_of_service_id = p_pds_id
515: and person_id=c_person_id)
516: AND paa.payroll_action_id = ppa.payroll_action_id
517: AND ppa.action_type IN ('R','Q','I','B','V')

Line 531: FROM per_assignments_f paf, per_assignment_extra_info paei

527: FROM pay_assignment_Actions paa,
528: pay_payroll_actions ppa
529:
530: WHERE paa.assignment_id in (SELECT paf.assignment_id
531: FROM per_assignments_f paf, per_assignment_extra_info paei
532: WHERE paf.period_of_service_id = p_pds_id
533: AND paf.person_id=c_person_id
534: AND paf.assignment_id=paei.assignment_id
535: AND paei.information_type = 'IE_ASG_OVERRIDE'