DBA Data[Home] [Help]

APPS.GHR_BREAKDOWN_RPT dependencies on PER_PEOPLE_EXTRA_INFO

Line 295: p_PEI_GRP1 IN per_people_extra_info%ROWTYPE,

291: End return_special_information;
292:
293: FUNCTION Any_Clause(p_clause IN VARCHAR2,
294: p_PER_rowid IN ROWID,
295: p_PEI_GRP1 IN per_people_extra_info%ROWTYPE,
296: p_ASG IN per_all_assignments_f%ROWTYPE)
297: RETURN VARCHAR2
298: IS
299: l_result VARCHAR2(300);

Line 486: r_GRP1 per_people_extra_info%rowtype;

482: AND ghr_api.get_position_agency_code_pos(ASG.position_id, ASG.business_group_id)
483: LIKE l_agcy_and_selm
484: AND ASG.primary_flag = 'Y'
485: AND ASG.assignment_type <> 'B';
486: r_GRP1 per_people_extra_info%rowtype;
487: r_ASG per_all_assignments_f%rowtype;
488: l_result VARCHAR2(80);
489:
490: -- Information to be inserted in GHR_BREAKDOWN_RESULTS