[Home] [Help]
1588: CURSOR csr_prof_tax_number
1589: IS
1590: --
1591: SELECT hoi.org_information1
1592: FROM hr_soft_coding_keyflex hsck
1593: ,hr_organization_information hoi
1594: ,per_assignments_f paaf
1595: ,pay_assignment_actions paa
1596: ,pay_payroll_actions ppa
1654: Cursor c_reg_name
1655: IS
1656: SELECT hou.name
1657: FROM per_assignments_f peaf
1658: ,hr_soft_coding_keyflex hrscf
1659: ,hr_organization_information hoi
1660: ,hr_organization_units hou
1661: WHERE peaf.assignment_id=p_assignment_id
1662: AND peaf.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id
2006: CURSOR c_pf_org_id(p_assignment_action_id NUMBER)
2007: IS
2008: select DISTINCT hoi.organization_id source_id
2009: from hr_organization_units hoi
2010: ,hr_soft_coding_keyflex scf
2011: ,per_assignments_f asg
2012: ,pay_assignment_actions paa
2013: where asg.assignment_id=paa.assignment_id
2014: and paa.assignment_action_id=p_assignment_action_id
2053: ,p_pay_end DATE)
2054: IS
2055: SELECT MAX(paf.effective_end_date)
2056: FROM per_assignments_f paf
2057: ,hr_soft_coding_keyflex scl
2058: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
2059: AND paf.assignment_id=p_assignment_id
2060: AND scl.segment2 = p_source_id
2061: AND paf.effective_start_date <= p_pay_end
2082: IS
2083: SELECT min(paf.effective_start_date)
2084: FROM per_people_f ppf
2085: ,per_assignments_f paf
2086: ,hr_soft_coding_keyflex scl
2087: WHERE ppf.person_id = l_person_id
2088: AND paf.person_id =ppf.person_id
2089: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id
2090: AND scl.segment2 = l_source_id;
2096: IS
2097: SELECT '1'
2098: FROM per_people_f ppf
2099: ,per_assignments_f paf
2100: ,hr_soft_coding_keyflex scl
2101: WHERE ppf.person_id = l_person_id
2102: AND paf.person_id =ppf.person_id
2103: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id
2104: and scl.segment2 IS NOT NULL
2142: pps.pds_information3 efile -- Termination Reason(EFile)
2143: FROM per_people_f ppf,
2144: per_assignments_f paf,
2145: per_periods_of_service pps,
2146: hr_soft_coding_keyflex scl
2147: WHERE paf.person_id = ppf.person_id
2148: AND paf.period_of_service_id = pps.period_of_service_id
2149: AND paf.assignment_id = p_assignment_id
2150: AND scl.segment2 = l_source_id
2652: CURSOR c_esi_org_id(p_assignment_action_id NUMBER)
2653: IS
2654: SELECT DISTINCT hoi.organization_id source_id
2655: FROM hr_organization_units hoi
2656: ,hr_soft_coding_keyflex scf
2657: ,per_assignments_f asg
2658: ,pay_assignment_actions paa
2659: WHERE asg.assignment_id=paa.assignment_id
2660: AND paa.assignment_action_id=p_assignment_action_id
2787: ,p_pay_end DATE)
2788: IS
2789: SELECT MAX(paf.effective_end_date)
2790: FROM per_assignments_f paf
2791: ,hr_soft_coding_keyflex scl
2792: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
2793: AND paf.assignment_id=p_assignment_id
2794: AND scl.segment4 = p_source_id
2795: AND paf.effective_start_date <= p_pay_end
2819:
2820: CURSOR csr_emplr_class IS
2821: SELECT target.org_information3 FROM
2822: per_all_assignments_f assign,
2823: hr_soft_coding_keyflex scl,
2824: hr_organization_information target
2825: WHERE assign.assignment_id = p_assignment_id
2826: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2827: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3623: CURSOR c_pt_state(p_assignment_action_id NUMBER)
3624: IS
3625: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3626: FROM hr_organization_units hoi
3627: ,hr_soft_coding_keyflex scf
3628: ,per_assignments_f asg
3629: ,pay_assignment_actions paa
3630: WHERE asg.assignment_id = paa.assignment_id
3631: AND paa.assignment_action_id = p_assignment_action_id
3644: FROM ( */SELECT hoi.organization_id source_id
3645: ,hoi.name name
3646: ,asg.effective_end_date
3647: FROM hr_organization_units hoi
3648: ,hr_soft_coding_keyflex scf
3649: ,per_assignments_f asg
3650: ,pay_assignment_actions paa
3651: WHERE asg.assignment_id = paa.assignment_id
3652: AND paa.assignment_action_id = p_assignment_action_id