[Home] [Help]
646: select et.input_currency_code
647: from pay_element_types_f et
648: ,per_pay_bases pb
649: ,pay_input_values_f iv
650: ,per_all_assignments_f asg
651: where asg.pay_basis_id = pb.pay_basis_id
652: and pb.input_value_id = iv.input_value_id
653: and iv.element_type_id = et.element_type_id
654: and asg.assignment_id = p_assignment_id
1536: --Bug 2827121 Manager can be a contingent worker also.
1537:
1538: CURSOR c_get_assignment IS
1539: SELECT assignment_id, position_id, organization_id, supervisor_id, business_group_id
1540: FROM per_all_assignments_f
1541: WHERE person_id = p_person_id
1542: AND primary_flag = 'Y'
1543: AND assignment_type IN ('E', 'C','B') -- Bug 2827121 --Bug 5148387
1544: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1556:
1557: --
1558: CURSOR c_manager_id (p_position_id NUMBER) IS
1559: SELECT person_id
1560: FROM per_all_assignments_f ass,
1561: per_assignment_status_types ast
1562: WHERE ass.position_id = p_position_id
1563: AND ass.primary_flag = 'Y'
1564: AND ass.assignment_type IN ('E', 'C') -- Bug 2827121
1610: l_application_id NUMBER;
1611: l_ame_approver ame_util.approverrecord;
1612: l_outputs ff_exec.outputs_t;
1613: l_loc_rec hr_locations_all%ROWTYPE;
1614: -- l_ass_rec per_all_assignments_f%ROWTYPE;
1615: l_jurisdiction_code VARCHAR2 (30);
1616: --
1617:
1618: BEGIN
1981: and rownum = 1);
1982: --
1983: cursor c_asg is
1984: select asg.assignment_id
1985: from per_all_assignments_f asg
1986: where asg.person_id = p_person_id
1987: and asg.primary_flag = 'Y'
1988: and p_effective_date
1989: between asg.effective_start_date
2554: ppp.date_start
2555: END) HIRE_DATE
2556: ,pps.actual_termination_date actual_termination_date
2557: from per_all_people_f ppf
2558: ,per_all_assignments_f paf
2559: ,PER_PERIODS_OF_PLACEMENT PPP
2560: ,PER_PERIODS_OF_SERVICE PPS
2561: where ppf.person_id = paf.person_id
2562: and paf. assignment_type in ('E','B') -- Need to consider Ex-Employee too