eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_OFFER_WF dependencies on PER_ASSIGNMENTS_F

Line 96: l_candidate_assignment_id per_assignments_f.assignment_id%type;

92: --
93: l_hiring_mgr_id per_people_f.person_id%type;
94: l_hiring_mgr_username wf_users.name%type;
95: l_hiring_mgr_disp_name wf_users.display_name%type;
96: l_candidate_assignment_id per_assignments_f.assignment_id%type;
97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;
99: l_candidate_appl_number per_people_f.applicant_number%type;
100: l_fwd_from_username wf_users.name%type;

Line 379: l_candidate_assignment_id per_assignments_f.assignment_id%type;

375: result out nocopy varchar2 ) is
376: --
377: l_hiring_mgr_id per_people_f.person_id%type;
378: l_fwd_to_id per_people_f.person_id%type;
379: l_candidate_assignment_id per_assignments_f.assignment_id%type;
380: --
381: begin
382: --
383: if ( funmode = 'RUN' ) then

Line 431: l_candidate_assignment_id per_assignments_f.assignment_id%type;

427: actid in number,
428: funmode in varchar2,
429: result out nocopy varchar2 ) is
430: --
431: l_candidate_assignment_id per_assignments_f.assignment_id%type;
432: --
433: begin
434: --
435: if ( funmode = 'RUN' ) then

Line 468: l_candidate_assignment_id per_assignments_f.assignment_id%type;

464: actid in number,
465: funmode in varchar2,
466: result out nocopy varchar2 ) is
467: --
468: l_candidate_assignment_id per_assignments_f.assignment_id%type;
469: --
470: begin
471: --
472: if ( funmode = 'RUN' ) then

Line 548: l_candidate_assignment_id per_assignments_f.assignment_id%type;

544: actid in number,
545: funmode in varchar2,
546: result out nocopy varchar2 ) is
547: --
548: l_candidate_assignment_id per_assignments_f.assignment_id%type;
549: l_candidate_person_id per_people_f.person_id%type;
550: begin
551: --
552: if ( funmode = 'RUN' ) then

Line 626: l_candidate_assignment_id per_assignments_f.assignment_id%type;

622: actid in number,
623: funmode in varchar2,
624: result out nocopy varchar2 ) is
625: --
626: l_candidate_assignment_id per_assignments_f.assignment_id%type;
627: l_candidate_person_id per_people_f.person_id%type;
628: l_host varchar2(200);
629: --
630: --

Line 705: l_candidate_assignment_id per_assignments_f.assignment_id%type;

701: actid in number,
702: funmode in varchar2,
703: result out nocopy varchar2 ) is
704: --
705: l_candidate_assignment_id per_assignments_f.assignment_id%type;
706: l_candidate_person_id per_people_f.person_id%type;
707: --
708: --
709: begin

Line 932: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

928: funmode in varchar2,
929: result out nocopy varchar2 ) is
930: -- Salary amount
931: CURSOR csr_salary_amount
932: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
933: select answer_value
934: from per_assign_proposal_answers
935: where assignment_id = p_assignment_id
936: and proposal_question_name = 'ANNUAL_SALARY';

Line 940: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

936: and proposal_question_name = 'ANNUAL_SALARY';
937:
938: -- Position title
939: CURSOR csr_position_title
940: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
941: select answer_value
942: from per_assign_proposal_answers
943: where assignment_id = p_assignment_id
944: and proposal_question_name = 'POSITION_TITLE';

Line 948: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

944: and proposal_question_name = 'POSITION_TITLE';
945:
946: -- Cost center/ Organization
947: CURSOR csr_organization
948: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
949: select hou.name
950: from per_assignments_x pax,
951: hr_all_organization_units hou -- 09/26/97 Changed
952: where pax.assignment_id = p_assignment_id

Line 957: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

953: and pax.organization_id = hou.organization_id;
954:
955: -- Sign-on bonus amount
956: CURSOR csr_sign_on_bonus_amount
957: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
958: select answer_value
959: from per_assign_proposal_answers
960: where assignment_id = p_assignment_id
961: and proposal_question_name = 'SIGN_ON_BONUS_AMOUNT';

Line 965: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

961: and proposal_question_name = 'SIGN_ON_BONUS_AMOUNT';
962:
963: -- Relocation maximum amount reimbursed
964: CURSOR csr_relocation_amount
965: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
966: select answer_value
967: from per_assign_proposal_answers
968: where assignment_id = p_assignment_id
969: and proposal_question_name = 'RELOCATION_MAXIMUM_AMOUNT_REIMBURSED';

Line 973: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is

969: and proposal_question_name = 'RELOCATION_MAXIMUM_AMOUNT_REIMBURSED';
970:
971: -- Stock option shares
972: CURSOR csr_stock_option_shares
973: (p_assignment_id in per_assignments_f.assignment_id%TYPE) is
974: select answer_value
975: from per_assign_proposal_answers
976: where assignment_id = p_assignment_id
977: and proposal_question_name = 'STOCK_OPTION_SHARES';

Line 984: p_assignment_id per_assignments_f.assignment_id%TYPE := to_number(itemkey);

980: salary_amount per_assign_proposal_answers.answer_value%TYPE;
981: relocation_amount per_assign_proposal_answers.answer_value%TYPE;
982: sign_on_bonus_amount per_assign_proposal_answers.answer_value%TYPE;
983: stock_option_shares per_assign_proposal_answers.answer_value%TYPE;
984: p_assignment_id per_assignments_f.assignment_id%TYPE := to_number(itemkey);
985: organization hr_organization_units.name%TYPE;
986:
987: -- 05/08/97 Change Begins
988: --