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 257: , per_all_assignments_f asg

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

Line 278: from per_all_assignments_f asg,

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

Line 293: , per_all_assignments_f asg

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

Line 306: from per_all_assignments_f asg1

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

Line 309: from per_all_assignments_f asg2

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

Line 325: per_all_assignments_f asg,

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

Line 339: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

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

Line 513: from per_all_assignments_f

509: ---cursor to get the assignment_type
510: ---
511: cursor csr_asg_type is
512: select ASSIGNMENT_TYPE
513: from per_all_assignments_f
514: where assignment_id=p_assignment_id
515: and p_change_date between effective_start_date
516: and effective_end_date;
517: --

Line 622: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

618: --
619: l_exists varchar2(1);
620: l_api_updating boolean;
621: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
622: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
623: l_payroll_status per_time_periods.status%TYPE;
624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;

Line 624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;

620: l_api_updating boolean;
621: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
622: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
623: l_payroll_status per_time_periods.status%TYPE;
624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;

Line 625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

621: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
622: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
623: l_payroll_status per_time_periods.status%TYPE;
624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;
629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

623: l_payroll_status per_time_periods.status%TYPE;
624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;
629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
630: --
631: --

Line 629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;
629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
630: --
631: --
632: -- Cursor to check existence of pay proposal with the same change date for the
633: -- assignment.

Line 667: from per_all_assignments_f asg,

663: asg.assignment_type,
664: ptp.status,
665: asg.pay_basis_id,
666: asg.payroll_id
667: from per_all_assignments_f asg,
668: per_time_periods ptp,
669: per_assignment_status_types ast
670: where asg.assignment_id = p_assignment_id
671: and asg.assignment_status_type_id = ast.assignment_status_type_id

Line 895: ,p_period in per_all_assignments_f.sal_review_period%TYPE

891: --
892: --
893: function derive_next_sal_perf_date
894: (p_change_date in per_pay_proposals.change_date%TYPE
895: ,p_period in per_all_assignments_f.sal_review_period%TYPE
896: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
897: )
898: Return Date is
899: --

Line 896: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE

892: --
893: function derive_next_sal_perf_date
894: (p_change_date in per_pay_proposals.change_date%TYPE
895: ,p_period in per_all_assignments_f.sal_review_period%TYPE
896: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
897: )
898: Return Date is
899: --
900: l_proc varchar2(72) := g_package||'derive_next_sal_perf_date';

Line 1019: from per_all_assignments_f assg,

1015: -- Cursor to check the assignment status as next_sal_review_date.
1016: --
1017: cursor csr_valid_assg_status is
1018: select null
1019: from per_all_assignments_f assg,
1020: per_assignment_status_types ast
1021: where assg.assignment_id = p_assignment_id
1022: and assg.assignment_status_type_id = ast.assignment_status_type_id
1023: and assg.business_group_id + 0 = p_business_group_id

Line 1167: from per_all_assignments_f

1163: --
1164: cursor csr_sal_review_details is
1165: select sal_review_period,
1166: sal_review_period_frequency
1167: from per_all_assignments_f
1168: where assignment_id = p_assignment_id
1169: and business_group_id + 0 = p_business_group_id
1170: and p_change_date between effective_start_date
1171: and nvl(effective_end_date, hr_api.g_eot);

Line 1178: from per_all_assignments_f assg,

1174: -- Cursor to check the assignment status as next_sal_review_date.
1175: --
1176: cursor csr_valid_assg_status is
1177: select null
1178: from per_all_assignments_f assg,
1179: per_assignment_status_types ast
1180: where assg.assignment_id = p_assignment_id
1181: and assg.assignment_status_type_id = ast.assignment_status_type_id
1182: and assg.business_group_id + 0 = p_business_group_id

Line 1314: per_all_assignments_f ass

1310: --
1311: Cursor csr_is_first_proposal is
1312: select null
1313: from per_pay_proposals pro,
1314: per_all_assignments_f ass
1315: where pro.assignment_id = p_assignment_id
1316: and ass.assignment_id = pro.assignment_id
1317: and p_change_date between ass.effective_start_date
1318: AND ass.effective_end_date;

Line 1514: l_organization_id per_all_assignments_f.organization_id%TYPE;

1510: ,p_proposed_salary_warning out nocopy boolean
1511: ) is
1512:
1513: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1514: l_organization_id per_all_assignments_f.organization_id%TYPE;
1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

Line 1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

1511: ) is
1512:
1513: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1514: l_organization_id per_all_assignments_f.organization_id%TYPE;
1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1519: l_frequency per_all_assignments_f.frequency%TYPE;

Line 1516: l_position_id per_all_assignments_f.position_id%TYPE;

1512:
1513: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1514: l_organization_id per_all_assignments_f.organization_id%TYPE;
1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1519: l_frequency per_all_assignments_f.frequency%TYPE;
1520: l_prop_salary_link_warning boolean;

Line 1517: l_grade_id per_all_assignments_f.grade_id%TYPE;

1513: l_proc varchar2(70):= g_package || 'is_salary_in_range';
1514: l_organization_id per_all_assignments_f.organization_id%TYPE;
1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1519: l_frequency per_all_assignments_f.frequency%TYPE;
1520: l_prop_salary_link_warning boolean;
1521: l_prop_salary_ele_warning boolean;

Line 1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

1514: l_organization_id per_all_assignments_f.organization_id%TYPE;
1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1519: l_frequency per_all_assignments_f.frequency%TYPE;
1520: l_prop_salary_link_warning boolean;
1521: l_prop_salary_ele_warning boolean;
1522: l_prop_salary_grade_warning boolean;

Line 1519: l_frequency per_all_assignments_f.frequency%TYPE;

1515: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1516: l_position_id per_all_assignments_f.position_id%TYPE;
1517: l_grade_id per_all_assignments_f.grade_id%TYPE;
1518: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1519: l_frequency per_all_assignments_f.frequency%TYPE;
1520: l_prop_salary_link_warning boolean;
1521: l_prop_salary_ele_warning boolean;
1522: l_prop_salary_grade_warning boolean;
1523: --

Line 1531: from per_all_assignments_f

1527: ,position_id
1528: ,grade_id
1529: ,normal_hours
1530: ,frequency
1531: from per_all_assignments_f
1532: where assignment_id=p_assignment_id
1533: and p_change_date between effective_start_date and effective_end_date;
1534: --
1535: --

Line 1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE

1609: -- Internal Table Handler Use only
1610: --
1611: --
1612: procedure is_salary_in_range_int
1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

Line 1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

1610: --
1611: --
1612: procedure is_salary_in_range_int
1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE

Line 1615: ,p_position_id in per_all_assignments_f.position_id%TYPE

1611: --
1612: procedure is_salary_in_range_int
1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

Line 1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1612: procedure is_salary_in_range_int
1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE

Line 1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

1613: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE
1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 1618: ,p_frequency in per_all_assignments_f.frequency%TYPE

1614: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1615: ,p_position_id in per_all_assignments_f.position_id%TYPE
1616: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1617: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1618: ,p_frequency in per_all_assignments_f.frequency%TYPE
1619: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1620: ,p_change_date in per_pay_proposals.change_date%TYPE
1621: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1622: ,p_prop_salary_link_warning out nocopy boolean

Line 1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE

1691: -- Internal Table Handler Use only
1692: --
1693: --
1694: procedure is_salary_in_range_int
1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

Line 1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

1692: --
1693: --
1694: procedure is_salary_in_range_int
1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE

Line 1697: ,p_position_id in per_all_assignments_f.position_id%TYPE

1693: --
1694: procedure is_salary_in_range_int
1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

Line 1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1694: procedure is_salary_in_range_int
1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE

Line 1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

1695: (p_organization_id in per_all_assignments_f.organization_id%TYPE
1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE
1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 1700: ,p_frequency in per_all_assignments_f.frequency%TYPE

1696: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
1697: ,p_position_id in per_all_assignments_f.position_id%TYPE
1698: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1699: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
1700: ,p_frequency in per_all_assignments_f.frequency%TYPE
1701: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
1702: ,p_change_date in per_pay_proposals.change_date%TYPE
1703: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
1704: ,p_prop_salary_link_warning out nocopy boolean

Line 1708: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1704: ,p_prop_salary_link_warning out nocopy boolean
1705: ,p_prop_salary_ele_warning out nocopy boolean
1706: ,p_prop_salary_grade_warning out nocopy boolean
1707: --added by vkodedal bug#8452388
1708: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1709: ) is
1710:
1711: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;

Line 1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;

1708: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1709: ) is
1710:
1711: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1713: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1714: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1716: l_org_working_hours NUMBER;

Line 1713: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;

1709: ) is
1710:
1711: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1713: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1714: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1716: l_org_working_hours NUMBER;
1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;

Line 1714: l_normal_hours per_all_assignments_f.normal_hours%TYPE;

1710:
1711: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1713: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1714: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1716: l_org_working_hours NUMBER;
1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1718: l_bus_working_hours NUMBER;

Line 1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;

1711: l_proc varchar2(70):= g_package || 'is_salary_in_range_int';
1712: l_working_hours per_all_assignments_f.normal_hours%TYPE;
1713: l_working_hours_frequency per_all_assignments_f.frequency%TYPE;
1714: l_normal_hours per_all_assignments_f.normal_hours%TYPE;
1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1716: l_org_working_hours NUMBER;
1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1718: l_bus_working_hours NUMBER;
1719: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;

Line 2226: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

2222: --
2223: l_proc varchar2(72):= g_package||'chk_approved';
2224: l_exists varchar2(1);
2225: l_api_updating boolean;
2226: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2227: l_autoApprove varchar2(1);
2228: --
2229: -- Cursor which checks for unapproved components
2230: --

Line 2249: from per_all_assignments_f

2245: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
2246: --
2247: cursor asg_type is
2248: select assignment_type
2249: from per_all_assignments_f
2250: where assignment_id=p_assignment_id
2251: and p_change_date between
2252: effective_start_date and effective_end_date;
2253:

Line 2782: , per_all_assignments_f asg

2778: --
2779: cursor csr_chk_performance_review_id is
2780: select null
2781: from per_performance_reviews prv
2782: , per_all_assignments_f asg
2783: where asg.assignment_id = p_assignment_id
2784: and asg.person_id=prv.person_id
2785: and prv.performance_review_id = p_performance_review_id;
2786: --