APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on PER_PARTICIPANTS

Line 631: lv_participant_type per_participants.participation_type%type;

627: --local variables
628: ln_participant_person_id wf_item_attribute_values.number_value%type ;
629: lv_particpant_user_name varchar2(320);
630: lv_particpant_display_name varchar2(360);
631: lv_participant_type per_participants.participation_type%type;
632: ln_participant_id per_participants.participant_id%type;
633: ln_appraisal_id number;
634: type_value varchar2(30);
635: begin

Line 632: ln_participant_id per_participants.participant_id%type;

628: ln_participant_person_id wf_item_attribute_values.number_value%type ;
629: lv_particpant_user_name varchar2(320);
630: lv_particpant_display_name varchar2(360);
631: lv_participant_type per_participants.participation_type%type;
632: ln_participant_id per_participants.participant_id%type;
633: ln_appraisal_id number;
634: type_value varchar2(30);
635: begin
636: -- Do nothing in cancel or timeout mode

Line 654: -- participant person id and type from per_participants

650: raise g_invalid_appraisal_id;
651: elsif (ln_participant_id is null) then
652: raise g_invalid_participant_id;
653: end if;
654: -- participant person id and type from per_participants
655: -- for the given appraisal id
656: select person_id,participation_type
657: into ln_participant_person_id,lv_participant_type
658: from per_participants

Line 658: from per_participants

654: -- participant person id and type from per_participants
655: -- for the given appraisal id
656: select person_id,participation_type
657: into ln_participant_person_id,lv_participant_type
658: from per_participants
659: where participation_in_id = ln_appraisal_id
660: and participant_id=ln_participant_id;
661:
662: -- get the role details for the participant and set the item attributes