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.PER_PYP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 258: , per_all_assignments_f asg

254: from pay_element_entries_f peef
255: , pay_element_links_f pel
256: , pay_input_values_f piv
257: , per_pay_bases ppb
258: , per_all_assignments_f asg
259: where asg.assignment_id = p_assignment_id
260: and asg.pay_basis_id=ppb.pay_basis_id
261: and ppb.input_value_id=piv.input_value_id
262: and asg.effective_start_date

Line 279: from per_all_assignments_f asg,

275: and peef.creator_type = 'SP';
276: --
277: cursor csr_asg_effective_end_date is
278: select max(effective_end_date)
279: from per_all_assignments_f asg,
280: per_assignment_status_types ast
281: where asg.assignment_id = p_assignment_id
282: and asg.assignment_status_type_id=ast.assignment_status_type_id
283: and ast.per_system_status='ACTIVE_ASSIGN';

Line 294: , per_all_assignments_f asg

290: select final_process_date,
291: last_standard_process_date,
292: actual_termination_date
293: from per_periods_of_service pds
294: , per_all_assignments_f asg
295: where asg.assignment_id=p_assignment_id
296: and p_change_date between asg.effective_start_date and asg.effective_end_date
297: and asg.person_id=pds.person_id
298: and p_change_date between pds.date_start

Line 307: from per_all_assignments_f asg1

303: -- the change_date
304: --
305: cursor csr_asg_pay_bases is
306: select null
307: from per_all_assignments_f asg1
308: where assignment_id = p_assignment_id
309: and exists (select null
310: from per_all_assignments_f asg2
311: where asg2.assignment_id = p_assignment_id

Line 310: from per_all_assignments_f asg2

306: select null
307: from per_all_assignments_f asg1
308: where assignment_id = p_assignment_id
309: and exists (select null
310: from per_all_assignments_f asg2
311: where asg2.assignment_id = p_assignment_id
312: and asg1.pay_basis_id +0 <> asg2.pay_basis_id
313: and asg2.effective_start_date > p_change_date
314: and asg1.effective_end_date >= p_change_date);

Line 326: per_all_assignments_f asg,

322: CURSOR csr_ele_term_rule(p_assignment_id IN NUMBER
323: ,p_change_date IN DATE) IS
324: SELECT pet.post_termination_rule
325: FROM pay_element_types_f pet,
326: per_all_assignments_f asg,
327: per_pay_bases ppb,
328: pay_input_values_f iv
329: WHERE pet.element_type_id = iv.element_type_id
330: AND iv.input_value_id = ppb.input_value_id

Line 340: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

336: --
337: --
338: l_exists varchar2(1);
339: l_effective_end_date date;
340: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
341: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
342: --4073821
343: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
344: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;

Line 602: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

598: --
599: l_exists varchar2(1);
600: l_api_updating boolean;
601: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
602: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
603: l_payroll_status per_time_periods.status%TYPE;
604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;

Line 604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;

600: l_api_updating boolean;
601: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
602: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
603: l_payroll_status per_time_periods.status%TYPE;
604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;
607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
608: l_change_date per_pay_proposals.change_date%TYPE;

Line 605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

601: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
602: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
603: l_payroll_status per_time_periods.status%TYPE;
604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;
607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
608: l_change_date per_pay_proposals.change_date%TYPE;
609: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

603: l_payroll_status per_time_periods.status%TYPE;
604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;
607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
608: l_change_date per_pay_proposals.change_date%TYPE;
609: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
610: --
611: --

Line 609: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;
607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
608: l_change_date per_pay_proposals.change_date%TYPE;
609: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
610: --
611: --
612: -- Cursor to check existence of pay proposal with the same change date for the
613: -- assignment.

Line 647: from per_all_assignments_f asg,

643: asg.assignment_type,
644: ptp.status,
645: asg.pay_basis_id,
646: asg.payroll_id
647: from per_all_assignments_f asg,
648: per_time_periods ptp,
649: per_assignment_status_types ast
650: where asg.assignment_id = p_assignment_id
651: and asg.assignment_status_type_id = ast.assignment_status_type_id

Line 875: ,p_period in per_all_assignments_f.sal_review_period%TYPE

871: --
872: --
873: function derive_next_sal_perf_date
874: (p_change_date in per_pay_proposals.change_date%TYPE
875: ,p_period in per_all_assignments_f.sal_review_period%TYPE
876: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
877: )
878: Return Date is
879: --

Line 876: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE

872: --
873: function derive_next_sal_perf_date
874: (p_change_date in per_pay_proposals.change_date%TYPE
875: ,p_period in per_all_assignments_f.sal_review_period%TYPE
876: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
877: )
878: Return Date is
879: --
880: l_proc varchar2(72) := g_package||'derive_next_sal_perf_date';

Line 994: from per_all_assignments_f assg,

990: -- Cursor to check the assignment status as next_sal_review_date.
991: --
992: cursor csr_valid_assg_status is
993: select null
994: from per_all_assignments_f assg,
995: per_assignment_status_types ast
996: where assg.assignment_id = p_assignment_id
997: and assg.assignment_status_type_id = ast.assignment_status_type_id
998: and assg.business_group_id + 0 = p_business_group_id

Line 1142: from per_all_assignments_f

1138: --
1139: cursor csr_sal_review_details is
1140: select sal_review_period,
1141: sal_review_period_frequency
1142: from per_all_assignments_f
1143: where assignment_id = p_assignment_id
1144: and business_group_id + 0 = p_business_group_id
1145: and p_change_date between effective_start_date
1146: and nvl(effective_end_date, hr_api.g_eot);

Line 1153: from per_all_assignments_f assg,

1149: -- Cursor to check the assignment status as next_sal_review_date.
1150: --
1151: cursor csr_valid_assg_status is
1152: select null
1153: from per_all_assignments_f assg,
1154: per_assignment_status_types ast
1155: where assg.assignment_id = p_assignment_id
1156: and assg.assignment_status_type_id = ast.assignment_status_type_id
1157: and assg.business_group_id + 0 = p_business_group_id

Line 1289: per_all_assignments_f ass

1285: --
1286: Cursor csr_is_first_proposal is
1287: select null
1288: from per_pay_proposals pro,
1289: per_all_assignments_f ass
1290: where pro.assignment_id = p_assignment_id
1291: and ass.assignment_id = pro.assignment_id
1292: and p_change_date between ass.effective_start_date
1293: AND ass.effective_end_date;

Line 1489: l_organization_id per_all_assignments_f.organization_id%TYPE;

1485: ,p_proposed_salary_warning out nocopy boolean
1486: ) is
1487:
1488: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1489: l_organization_id per_all_assignments_f.organization_id%TYPE;
1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

Line 1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

1486: ) is
1487:
1488: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1489: l_organization_id per_all_assignments_f.organization_id%TYPE;
1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1494: l_frequency per_all_assignments_f.frequency%TYPE;

Line 1491: l_position_id per_all_assignments_f.position_id%TYPE;

1487:
1488: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1489: l_organization_id per_all_assignments_f.organization_id%TYPE;
1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1494: l_frequency per_all_assignments_f.frequency%TYPE;
1495: l_prop_salary_link_warning boolean;

Line 1492: l_grade_id per_all_assignments_f.grade_id%TYPE;

1488: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1489: l_organization_id per_all_assignments_f.organization_id%TYPE;
1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1494: l_frequency per_all_assignments_f.frequency%TYPE;
1495: l_prop_salary_link_warning boolean;
1496: l_prop_salary_ele_warning boolean;

Line 1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

1489: l_organization_id per_all_assignments_f.organization_id%TYPE;
1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1494: l_frequency per_all_assignments_f.frequency%TYPE;
1495: l_prop_salary_link_warning boolean;
1496: l_prop_salary_ele_warning boolean;
1497: l_prop_salary_grade_warning boolean;

Line 1494: l_frequency per_all_assignments_f.frequency%TYPE;

1490: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1491: l_position_id per_all_assignments_f.position_id%TYPE;
1492: l_grade_id per_all_assignments_f.grade_id%TYPE;
1493: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1494: l_frequency per_all_assignments_f.frequency%TYPE;
1495: l_prop_salary_link_warning boolean;
1496: l_prop_salary_ele_warning boolean;
1497: l_prop_salary_grade_warning boolean;
1498: --

Line 1506: from per_all_assignments_f

1502: ,position_id
1503: ,grade_id
1504: ,normal_hours
1505: ,frequency
1506: from per_all_assignments_f
1507: where assignment_id=p_assignment_id
1508: and p_change_date between effective_start_date and effective_end_date;
1509: --
1510: --

Line 1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE

1583: -- Internal Table Handler Use only
1584: --
1585: --
1586: procedure is_salary_in_range_int
1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

Line 1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

1584: --
1585: --
1586: procedure is_salary_in_range_int
1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1592: ,p_frequency in per_all_assignments_f.frequency%TYPE

Line 1589: ,p_position_id in per_all_assignments_f.position_id%TYPE

1585: --
1586: procedure is_salary_in_range_int
1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1592: ,p_frequency in per_all_assignments_f.frequency%TYPE
1593: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

Line 1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1586: procedure is_salary_in_range_int
1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1592: ,p_frequency in per_all_assignments_f.frequency%TYPE
1593: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1594: ,p_change_date in per_pay_proposals.change_date%TYPE

Line 1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

1587: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1592: ,p_frequency in per_all_assignments_f.frequency%TYPE
1593: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1594: ,p_change_date in per_pay_proposals.change_date%TYPE
1595: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 1592: ,p_frequency in per_all_assignments_f.frequency%TYPE

1588: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1589: ,p_position_id in per_all_assignments_f.position_id%TYPE
1590: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1591: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1592: ,p_frequency in per_all_assignments_f.frequency%TYPE
1593: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1594: ,p_change_date in per_pay_proposals.change_date%TYPE
1595: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1596: ,p_prop_salary_link_warning out nocopy boolean

Line 1602: l_working_hours per_all_assignments_f.normal_hours%TYPE;

1598: ,p_prop_salary_grade_warning out nocopy boolean
1599: ) is
1600:
1601: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1602: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1603: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1604: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1606: l_org_working_hours NUMBER;

Line 1603: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;

1599: ) is
1600:
1601: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1602: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1603: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1604: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1606: l_org_working_hours NUMBER;
1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;

Line 1604: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

1600:
1601: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1602: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1603: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1604: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1606: l_org_working_hours NUMBER;
1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1608: l_bus_working_hours NUMBER;

Line 1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;

1601: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1602: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1603: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1604: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1606: l_org_working_hours NUMBER;
1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1608: l_bus_working_hours NUMBER;
1609: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;

Line 2083: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

2079: --
2080: l_proc varchar2(72):= g_package||'chk_approved';
2081: l_exists varchar2(1);
2082: l_api_updating boolean;
2083: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2084: l_autoApprove varchar2(1);
2085: --
2086: -- Cursor which checks for unapproved components
2087: --

Line 2106: from per_all_assignments_f

2102: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
2103: --
2104: cursor asg_type is
2105: select assignment_type
2106: from per_all_assignments_f
2107: where assignment_id=p_assignment_id
2108: and p_change_date between
2109: effective_start_date and effective_end_date;
2110:

Line 2639: , per_all_assignments_f asg

2635: --
2636: cursor csr_chk_performance_review_id is
2637: select null
2638: from per_performance_reviews prv
2639: , per_all_assignments_f asg
2640: where asg.assignment_id = p_assignment_id
2641: and asg.person_id=prv.person_id
2642: and prv.performance_review_id = p_performance_review_id;
2643: --