APPS.GHR_BREAKDOWN_RPT dependencies on GHR_HISTORY_FETCH

Line 316: ghr_history_fetch.fetch_positionei(p_ASG.position_id, 'GHR_US_POS_GRP1',

312: WHERE GRD.grade_id = p_ASG.grade_id
313: AND GDF.grade_definition_id = GRD.grade_definition_id;
314: ELSIF p_clause = 'OCCODE_PATCOB' -- Occupational Category (PATCOB) Code
315: THEN
316: ghr_history_fetch.fetch_positionei(p_ASG.position_id, 'GHR_US_POS_GRP1',
317: l_effective_date, l_posei_data);
318: l_result := l_posei_data.poei_information6 || ' - ' ||
319: decode_lookup('GHR_US_OCC_CATEGORY_CODE', l_posei_data.poei_information6);
320: ELSIF p_clause = 'SERIES' -- Occupational Series

Line 387: ghr_history_fetch.fetch_positionei(p_ASG.position_id, 'GHR_US_POS_GRP1',

383: decode_lookup('GHR_US_HANDICAP_CODE', p_PEI_GRP1.pei_information11);
384: ELSIF p_clause = 'AA_CATEGORY' -- AA Category
385: THEN
386: BEGIN
387: ghr_history_fetch.fetch_positionei(p_ASG.position_id, 'GHR_US_POS_GRP1',
388: l_effective_date, l_posei_data);
389: SELECT NVL(LKP.description, LKP.meaning)
390: INTO l_result
391: FROM hr_lookups LKP

Line 508: ghr_history_fetch.fetch_peopleei(r_emp.person_id, 'GHR_US_PER_GROUP1',

504: WHERE session_id = l_rslt_session_id;
505: END IF;
506: l_rslt_id := 0;
507: FOR r_emp IN c_emp LOOP
508: ghr_history_fetch.fetch_peopleei(r_emp.person_id, 'GHR_US_PER_GROUP1',
509: l_effective_date, r_GRP1);
510: ghr_history_fetch.fetch_assignment(p_rowid => r_emp.ASG_rowid,
511: p_assignment_data => r_ASG,
512: p_result_code => l_result);

Line 510: ghr_history_fetch.fetch_assignment(p_rowid => r_emp.ASG_rowid,

506: l_rslt_id := 0;
507: FOR r_emp IN c_emp LOOP
508: ghr_history_fetch.fetch_peopleei(r_emp.person_id, 'GHR_US_PER_GROUP1',
509: l_effective_date, r_GRP1);
510: ghr_history_fetch.fetch_assignment(p_rowid => r_emp.ASG_rowid,
511: p_assignment_data => r_ASG,
512: p_result_code => l_result);
513: IF r_GRP1.pei_information5 IS NOT NULL THEN
514: l_rslt_id := l_rslt_id + 1;