APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 395: from per_all_assignments_f paaf, per_assignment_extra_info paei

391: paa.assignment_action_id),16))
392: FROM pay_assignment_actions paa,pay_payroll_actions ppa
393: WHERE ((c_ppsn is null and paa.assignment_id=c_assignment_id)
394: OR(c_ppsn is not null and paa.assignment_id in (select paaf.assignment_id
395: from per_all_assignments_f paaf, per_assignment_extra_info paei
396: where paaf.person_id = c_person_id
397: and paaf.assignment_id=paei.assignment_id
398: and paei.information_type = 'IE_ASG_OVERRIDE'
399: and paei.aei_information1 = c_ppsn --'314678745T'

Line 468: FROM per_assignment_extra_info

464: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
465:
466: CURSOR csr_ppsn_override(p_asg_id NUMBER) IS
467: SELECT aei_information1 PPSN_OVERRIDE
468: FROM per_assignment_extra_info
469: WHERE assignment_id = p_asg_id
470: AND aei_information_category = 'IE_ASG_OVERRIDE';
471:
472: CURSOR csr_get_org_email(l_paye_ref number

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'

Line 546: l_ppsn_override per_assignment_extra_info.aei_information1%type:=null;

542: AND paa.action_status IN ('C','S') --10225372
543: AND paa.source_action_id is null
544: AND ppa.effective_date<= to_date('30/04'||'/'||to_char(cp_end_date,'yyyy'),'dd/mm/yyyy');
545: --
546: l_ppsn_override per_assignment_extra_info.aei_information1%type:=null;
547: /*6876894*/
548: l_formula_id NUMBER;
549: l_include_flag VARCHAR2(10);
550: l_email VARCHAR2(100):=null;