eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 679: ,per_all_assignments_f asg

675: select et.input_currency_code
676: from pay_element_types_f et
677: ,per_pay_bases pb
678: ,pay_input_values_f iv
679: ,per_all_assignments_f asg
680: where asg.pay_basis_id = pb.pay_basis_id
681: and pb.input_value_id = iv.input_value_id
682: and iv.element_type_id = et.element_type_id
683: and asg.assignment_id = p_assignment_id

Line 1585: FROM per_all_assignments_f

1581: --Bug 2827121 Manager can be a contingent worker also.
1582:
1583: CURSOR c_get_assignment IS
1584: SELECT assignment_id, position_id, organization_id, supervisor_id, business_group_id
1585: FROM per_all_assignments_f
1586: WHERE person_id = p_person_id
1587: AND primary_flag = 'Y'
1588: AND assignment_type IN ('E', 'C','B') -- Bug 2827121 --Bug 5148387
1589: AND p_effective_date BETWEEN effective_start_date AND effective_end_date

Line 1605: FROM per_all_assignments_f ass,

1601:
1602: --
1603: CURSOR c_manager_id (p_position_id NUMBER) IS
1604: SELECT person_id
1605: FROM per_all_assignments_f ass,
1606: per_assignment_status_types ast
1607: WHERE ass.position_id = p_position_id
1608: AND ass.primary_flag = 'Y'
1609: AND ass.assignment_type IN ('E', 'C') -- Bug 2827121

Line 1659: -- l_ass_rec per_all_assignments_f%ROWTYPE;

1655: l_application_id NUMBER;
1656: l_ame_approver ame_util.approverrecord;
1657: l_outputs ff_exec.outputs_t;
1658: l_loc_rec hr_locations_all%ROWTYPE;
1659: -- l_ass_rec per_all_assignments_f%ROWTYPE;
1660: l_jurisdiction_code VARCHAR2 (30);
1661: --
1662:
1663: BEGIN

Line 2030: from per_all_assignments_f asg

2026: and rownum = 1);
2027: --
2028: cursor c_asg is
2029: select asg.assignment_id
2030: from per_all_assignments_f asg
2031: where asg.person_id = p_person_id
2032: and asg.primary_flag = 'Y'
2033: and p_effective_date
2034: between asg.effective_start_date

Line 2603: ,per_all_assignments_f paf

2599: ppp.date_start
2600: END) HIRE_DATE
2601: ,pps.actual_termination_date actual_termination_date
2602: from per_all_people_f ppf
2603: ,per_all_assignments_f paf
2604: ,PER_PERIODS_OF_PLACEMENT PPP
2605: ,PER_PERIODS_OF_SERVICE PPS
2606: where ppf.person_id = paf.person_id
2607: and paf. assignment_type in ('E','B') -- Need to consider Ex-Employee too