APPS.HR_OFFER_WF dependencies on PER_ASSIGN_PROPOSAL_ANSWERS

Line 934: from per_assign_proposal_answers

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';
937:
938: -- Position title

Line 942: from per_assign_proposal_answers

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';
945:
946: -- Cost center/ Organization

Line 959: from per_assign_proposal_answers

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';
962:
963: -- Relocation maximum amount reimbursed

Line 967: from per_assign_proposal_answers

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';
970:
971: -- Stock option shares

Line 975: from per_assign_proposal_answers

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';
978:
979: position_title per_assign_proposal_answers.answer_value%TYPE;

Line 979: position_title per_assign_proposal_answers.answer_value%TYPE;

975: from per_assign_proposal_answers
976: where assignment_id = p_assignment_id
977: and proposal_question_name = 'STOCK_OPTION_SHARES';
978:
979: position_title per_assign_proposal_answers.answer_value%TYPE;
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;

Line 980: salary_amount per_assign_proposal_answers.answer_value%TYPE;

976: where assignment_id = p_assignment_id
977: and proposal_question_name = 'STOCK_OPTION_SHARES';
978:
979: position_title per_assign_proposal_answers.answer_value%TYPE;
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);

Line 981: relocation_amount per_assign_proposal_answers.answer_value%TYPE;

977: and proposal_question_name = 'STOCK_OPTION_SHARES';
978:
979: position_title per_assign_proposal_answers.answer_value%TYPE;
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;

Line 982: sign_on_bonus_amount per_assign_proposal_answers.answer_value%TYPE;

978:
979: position_title per_assign_proposal_answers.answer_value%TYPE;
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:

Line 983: stock_option_shares per_assign_proposal_answers.answer_value%TYPE;

979: position_title per_assign_proposal_answers.answer_value%TYPE;
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