[Home] [Help]
1459: CURSOR csr_prof_tax_number
1460: IS
1461: --
1462: SELECT hoi.org_information1
1463: FROM hr_soft_coding_keyflex hsck
1464: ,hr_organization_information hoi
1465: ,per_assignments_f paaf
1466: ,pay_assignment_actions paa
1467: ,pay_payroll_actions ppa
1525: Cursor c_reg_name
1526: IS
1527: SELECT hou.name
1528: FROM per_assignments_f peaf
1529: ,hr_soft_coding_keyflex hrscf
1530: ,hr_organization_information hoi
1531: ,hr_organization_units hou
1532: WHERE peaf.assignment_id=p_assignment_id
1533: AND peaf.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id
1857: CURSOR c_pf_org_id(p_assignment_action_id NUMBER)
1858: IS
1859: select DISTINCT hoi.organization_id source_id
1860: from hr_organization_units hoi
1861: ,hr_soft_coding_keyflex scf
1862: ,per_assignments_f asg
1863: ,pay_assignment_actions paa
1864: where asg.assignment_id=paa.assignment_id
1865: and paa.assignment_action_id=p_assignment_action_id
1904: ,p_pay_end DATE)
1905: IS
1906: SELECT MAX(paf.effective_end_date)
1907: FROM per_assignments_f paf
1908: ,hr_soft_coding_keyflex scl
1909: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
1910: AND paf.assignment_id=p_assignment_id
1911: AND scl.segment2 = p_source_id
1912: AND paf.effective_start_date <= p_pay_end
1933: IS
1934: SELECT min(paf.effective_start_date)
1935: FROM per_people_f ppf
1936: ,per_assignments_f paf
1937: ,hr_soft_coding_keyflex scl
1938: WHERE ppf.person_id = l_person_id
1939: AND paf.person_id =ppf.person_id
1940: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id
1941: AND scl.segment2 = l_source_id;
1947: IS
1948: SELECT '1'
1949: FROM per_people_f ppf
1950: ,per_assignments_f paf
1951: ,hr_soft_coding_keyflex scl
1952: WHERE ppf.person_id = l_person_id
1953: AND paf.person_id =ppf.person_id
1954: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id
1955: and scl.segment2 IS NOT NULL
2440: CURSOR c_esi_org_id(p_assignment_action_id NUMBER)
2441: IS
2442: SELECT DISTINCT hoi.organization_id source_id
2443: FROM hr_organization_units hoi
2444: ,hr_soft_coding_keyflex scf
2445: ,per_assignments_f asg
2446: ,pay_assignment_actions paa
2447: WHERE asg.assignment_id=paa.assignment_id
2448: AND paa.assignment_action_id=p_assignment_action_id
2575: ,p_pay_end DATE)
2576: IS
2577: SELECT MAX(paf.effective_end_date)
2578: FROM per_assignments_f paf
2579: ,hr_soft_coding_keyflex scl
2580: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
2581: AND paf.assignment_id=p_assignment_id
2582: AND scl.segment4 = p_source_id
2583: AND paf.effective_start_date <= p_pay_end
2607:
2608: CURSOR csr_emplr_class IS
2609: SELECT target.org_information3 FROM
2610: per_all_assignments_f assign,
2611: hr_soft_coding_keyflex scl,
2612: hr_organization_information target
2613: WHERE assign.assignment_id = p_assignment_id
2614: AND p_payroll_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2615: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3403: CURSOR c_pt_state(p_assignment_action_id NUMBER)
3404: IS
3405: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3406: FROM hr_organization_units hoi
3407: ,hr_soft_coding_keyflex scf
3408: ,per_assignments_f asg
3409: ,pay_assignment_actions paa
3410: WHERE asg.assignment_id = paa.assignment_id
3411: AND paa.assignment_action_id = p_assignment_action_id
3424: FROM ( */SELECT hoi.organization_id source_id
3425: ,hoi.name name
3426: ,asg.effective_end_date
3427: FROM hr_organization_units hoi
3428: ,hr_soft_coding_keyflex scf
3429: ,per_assignments_f asg
3430: ,pay_assignment_actions paa
3431: WHERE asg.assignment_id = paa.assignment_id
3432: AND paa.assignment_action_id = p_assignment_action_id