APPS.GHR_BREAKDOWN_RPT dependencies on PER_PEOPLE_F

Line 412: FROM per_people_f

408: ELSIF p_clause = 'PERFORMANCE_RATING' -- Performance Rating level
409: THEN
410: SELECT person_id
411: INTO l_result
412: FROM per_people_f
413: WHERE rowid = p_PER_rowid;
414: return_special_information(p_person_id => l_result,
415: p_structure_name => 'US Fed Perf Appraisal',
416: p_effective_date => l_effective_date,

Line 436: FROM per_people_f

432: AND GDF.grade_definition_id = GRD.grade_definition_id;
433: ELSIF p_clause = 'FULL_NAME' THEN
434: SELECT full_name
435: INTO l_result
436: FROM per_people_f
437: WHERE rowid = p_PER_rowid;
438: ELSIF p_clause = 'PERSON_ID' THEN
439: SELECT person_id
440: INTO l_result

Line 441: FROM per_people_f

437: WHERE rowid = p_PER_rowid;
438: ELSIF p_clause = 'PERSON_ID' THEN
439: SELECT person_id
440: INTO l_result
441: FROM per_people_f
442: WHERE rowid = p_PER_rowid;
443: ELSIF p_clause = 'EMPLOYEE_NUMBER' THEN
444: SELECT employee_number
445: INTO l_result

Line 446: FROM per_people_f

442: WHERE rowid = p_PER_rowid;
443: ELSIF p_clause = 'EMPLOYEE_NUMBER' THEN
444: SELECT employee_number
445: INTO l_result
446: FROM per_people_f
447: WHERE rowid = p_PER_rowid;
448: ELSIF p_clause = 'AGENCY_CODE' THEN
449: l_result := ghr_api.get_position_agency_code_pos(p_ASG.position_id,
450: p_ASG.business_group_id);

Line 475: FROM per_people_f PER, per_assignments_f ASG

471: PROCEDURE process(p_breakdown_criteria_id IN NUMBER := NULL) IS
472: CURSOR c_emp IS
473: SELECT PER.rowid PER_rowid, ASG.rowid ASG_rowid,
474: PER.person_id, PER.sex
475: FROM per_people_f PER, per_assignments_f ASG
476: WHERE l_effective_date BETWEEN PER.effective_start_date
477: AND PER.effective_end_date
478: AND PER.person_id = ASG.person_id
479: AND l_effective_date BETWEEN ASG.effective_start_date