DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ANALYSIS_CRITERIA

Line 471: l_max_segment per_analysis_criteria.segment1%type;

467: l_ANCRIT_REC ghr_api.special_information_type;
468: l_emp_number per_all_people.employee_number%TYPE;
469:
470: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
471: l_max_segment per_analysis_criteria.segment1%type;
472: l_lang_cnt number;
473: l_flex_struct_name varchar2(30);
474: l_special_pay_plan varchar2(30);
475: l_special_pay_grade varchar2(30);

Line 507: from per_analysis_criteria pea,

503: pea.segment4,
504: pea.segment5,
505: pea.segment6,
506: pea.segment7
507: from per_analysis_criteria pea,
508: per_person_analyses pan
509: where pan.person_id = g_person_id
510: and pan.id_flex_num = l_id_flex_num
511: and pea.analysis_criteria_id = pan.analysis_criteria_id

Line 530: per_analysis_Criteria pac

526: pac.segment5,
527: pac.segment6,
528: pac.segment17
529: from per_person_analyses pan,
530: per_analysis_Criteria pac
531: where pan.person_id = g_person_id
532: and pan.id_flex_num = l_id_flex_num
533: and pan.analysis_criteria_id = pac.analysis_criteria_id
534: and p_sr_report_date