APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1089: FROM per_all_assignments_f

1085: SELECT assignment_id,
1086: organization_id, -- ORG Node Id
1087: location_id, -- for GEO mapping
1088: business_group_id -- for GEO mapping
1089: FROM per_all_assignments_f
1090: WHERE person_id = cp_person_id
1091: AND (
1092: (cp_assignment_id IS NOT NULL AND assignment_id = cp_assignment_id)
1093: OR

Line 1201: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1197: l_start_date DATE;
1198: l_end_date DATE;
1199:
1200: -- Person Assigment attributes
1201: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1202: l_organization_id per_all_assignments_f.organization_id%TYPE;
1203: l_location_id per_all_assignments_f.location_id%TYPE;
1204: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1205:

Line 1202: l_organization_id per_all_assignments_f.organization_id%TYPE;

1198: l_end_date DATE;
1199:
1200: -- Person Assigment attributes
1201: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1202: l_organization_id per_all_assignments_f.organization_id%TYPE;
1203: l_location_id per_all_assignments_f.location_id%TYPE;
1204: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1205:
1206: -- GEO Node attributes

Line 1203: l_location_id per_all_assignments_f.location_id%TYPE;

1199:
1200: -- Person Assigment attributes
1201: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1202: l_organization_id per_all_assignments_f.organization_id%TYPE;
1203: l_location_id per_all_assignments_f.location_id%TYPE;
1204: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1205:
1206: -- GEO Node attributes
1207: l_geo_node VARCHAR2(150);

Line 1204: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1200: -- Person Assigment attributes
1201: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1202: l_organization_id per_all_assignments_f.organization_id%TYPE;
1203: l_location_id per_all_assignments_f.location_id%TYPE;
1204: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1205:
1206: -- GEO Node attributes
1207: l_geo_node VARCHAR2(150);
1208: l_geo_node_id NUMBER;

Line 1618: FROM per_all_assignments_f

1614:
1615: -- Cursor to get the person id for an assignment id.
1616: CURSOR c_per_id (cp_assignment_id NUMBER) IS
1617: SELECT person_id
1618: FROM per_all_assignments_f
1619: WHERE assignment_id = cp_assignment_id;
1620:
1621: BEGIN
1622: