DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ANALYSIS_CRITERIA

Line 484: l_max_segment per_analysis_criteria.segment1%type;

480: l_ANCRIT_REC ghr_api.special_information_type;
481: l_emp_number per_all_people.employee_number%TYPE;
482:
483: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
484: l_max_segment per_analysis_criteria.segment1%type;
485: l_lang_cnt number;
486: l_flex_struct_name varchar2(30);
487: l_special_pay_plan varchar2(30);
488: l_special_pay_grade varchar2(30);

Line 520: from per_analysis_criteria pea,

516: pea.segment4,
517: pea.segment5,
518: pea.segment6,
519: pea.segment7
520: from per_analysis_criteria pea,
521: per_person_analyses pan
522: where pan.person_id = g_person_id
523: and pan.id_flex_num = l_id_flex_num
524: and pea.analysis_criteria_id = pan.analysis_criteria_id

Line 543: per_analysis_Criteria pac

539: pac.segment5,
540: pac.segment6,
541: pac.segment17
542: from per_person_analyses pan,
543: per_analysis_Criteria pac
544: where pan.person_id = g_person_id
545: and pan.id_flex_num = l_id_flex_num
546: and pan.analysis_criteria_id = pac.analysis_criteria_id
547: and p_sr_report_date