APPS.HXC_TIMECARD_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 1621: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1617: IS
1618: l_assignment_index NUMBER;
1619: l_start_date DATE;
1620: l_end_date DATE;
1621: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1622: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1623: l_assignment_periods periods;
1624: l_assign_period_limit NUMBER; -- 5922228
1625:

Line 1622: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1618: l_assignment_index NUMBER;
1619: l_start_date DATE;
1620: l_end_date DATE;
1621: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1622: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1623: l_assignment_periods periods;
1624: l_assign_period_limit NUMBER; -- 5922228
1625:
1626:

Line 1635: FROM PER_ALL_ASSIGNMENTS_F pas,

1631: IS
1632: SELECT pas.ASSIGNMENT_ID,
1633: pas.EFFECTIVE_START_DATE,
1634: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1635: FROM PER_ALL_ASSIGNMENTS_F pas,
1636: per_assignment_status_types typ
1637: ,per_periods_of_service ppos --14596859
1638: WHERE pas.PERSON_ID = p_resource_id
1639: AND pas.ASSIGNMENT_TYPE in ('E','C')

Line 1660: FROM per_all_assignments_f pas

1656: , p_assign_period_limit IN number) IS
1657: SELECT pas.assignment_id
1658: , pas.effective_start_date
1659: , nvl (pas.effective_end_date, hr_general.end_of_time) end_date
1660: FROM per_all_assignments_f pas
1661: , per_assignment_status_types typ
1662: WHERE pas.person_id = p_resource_id
1663: AND pas.assignment_type IN ('E', 'C')
1664: AND pas.primary_flag = 'Y'

Line 1791: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1787: l_start_date DATE;
1788: l_end_date DATE;
1789: l_num_past_days NUMBER;
1790: l_num_future_days NUMBER;
1791: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1792: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1793: l_rec_period_id VARCHAR2(50);
1794:
1795: l_index BINARY_INTEGER;

Line 1792: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

1788: l_end_date DATE;
1789: l_num_past_days NUMBER;
1790: l_num_future_days NUMBER;
1791: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1792: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1793: l_rec_period_id VARCHAR2(50);
1794:
1795: l_index BINARY_INTEGER;
1796: l_pref_table hxc_preference_evaluation.t_pref_table;

Line 1806: FROM PER_ALL_ASSIGNMENTS_F pas,

1802: IS
1803: SELECT pas.ASSIGNMENT_ID,
1804: pas.EFFECTIVE_START_DATE,
1805: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1806: FROM PER_ALL_ASSIGNMENTS_F pas,
1807: per_assignment_status_types typ
1808: WHERE pas.PERSON_ID = p_resource_id
1809: AND pas.ASSIGNMENT_TYPE = 'E'
1810: AND pas.PRIMARY_FLAG = 'Y'