APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1051: FROM per_all_assignments_f

1047: SELECT assignment_id,
1048: organization_id, -- ORG Node Id
1049: location_id, -- for GEO mapping
1050: business_group_id -- for GEO mapping
1051: FROM per_all_assignments_f
1052: WHERE person_id = cp_person_id
1053: AND (
1054: (cp_assignment_id IS NOT NULL AND assignment_id = cp_assignment_id)
1055: OR

Line 1163: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1159: l_start_date DATE;
1160: l_end_date DATE;
1161:
1162: -- Person Assigment attributes
1163: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1164: l_organization_id per_all_assignments_f.organization_id%TYPE;
1165: l_location_id per_all_assignments_f.location_id%TYPE;
1166: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1167:

Line 1164: l_organization_id per_all_assignments_f.organization_id%TYPE;

1160: l_end_date DATE;
1161:
1162: -- Person Assigment attributes
1163: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1164: l_organization_id per_all_assignments_f.organization_id%TYPE;
1165: l_location_id per_all_assignments_f.location_id%TYPE;
1166: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1167:
1168: -- GEO Node attributes

Line 1165: l_location_id per_all_assignments_f.location_id%TYPE;

1161:
1162: -- Person Assigment attributes
1163: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1164: l_organization_id per_all_assignments_f.organization_id%TYPE;
1165: l_location_id per_all_assignments_f.location_id%TYPE;
1166: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1167:
1168: -- GEO Node attributes
1169: l_geo_node VARCHAR2(150);

Line 1166: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1162: -- Person Assigment attributes
1163: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1164: l_organization_id per_all_assignments_f.organization_id%TYPE;
1165: l_location_id per_all_assignments_f.location_id%TYPE;
1166: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1167:
1168: -- GEO Node attributes
1169: l_geo_node VARCHAR2(150);
1170: l_geo_node_id NUMBER;

Line 1580: FROM per_all_assignments_f

1576:
1577: -- Cursor to get the person id for an assignment id.
1578: CURSOR c_per_id (cp_assignment_id NUMBER) IS
1579: SELECT person_id
1580: FROM per_all_assignments_f
1581: WHERE assignment_id = cp_assignment_id;
1582:
1583: BEGIN
1584: