[Home] [Help]
20: g_org_run char(1);
21: g_org_a8a_run char(1);
22: g_iras_method char(1); /* Bug 7415444 , Original or Amendment*/
23: g_national_identifier per_all_people_f.national_identifier%type;
24: g_legal_entity_name hr_organization_information.org_information1%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
21: g_org_a8a_run char(1);
22: g_iras_method char(1); /* Bug 7415444 , Original or Amendment*/
23: g_national_identifier per_all_people_f.national_identifier%type;
24: g_legal_entity_name hr_organization_information.org_information1%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
22: g_iras_method char(1); /* Bug 7415444 , Original or Amendment*/
23: g_national_identifier per_all_people_f.national_identifier%type;
24: g_legal_entity_name hr_organization_information.org_information1%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
23: g_national_identifier per_all_people_f.national_identifier%type;
24: g_legal_entity_name hr_organization_information.org_information1%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
24: g_legal_entity_name hr_organization_information.org_information1%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
25: g_er_income_tax_number hr_organization_information.org_information4%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
26: g_er_ohq_status hr_organization_information.org_information12%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
27: g_er_iras_category hr_organization_information.org_information13%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;
28: g_er_telephone_no hr_organization_information.org_information14%type;
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;
36: g_er_payer_id_check char(1);
29: g_er_payer_id hr_organization_information.org_information15%type;
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;
36: g_er_payer_id_check char(1);
37: g_er_incorp_date_1 char(10); /* Bug 7415444 */
30: g_er_designation_type hr_organization_information.org_information17%type;
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;
36: g_er_payer_id_check char(1);
37: g_er_incorp_date_1 char(10); /* Bug 7415444 */
38: g_er_incorp_date_2 char(10);
31: g_er_position_seg_type hr_organization_information.org_information18%type;
32: g_er_bonus_date hr_organization_information.org_information8%type;
33: g_er_incorp_date hr_organization_information.org_information9%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;
36: g_er_payer_id_check char(1);
37: g_er_incorp_date_1 char(10); /* Bug 7415444 */
38: g_er_incorp_date_2 char(10);
39: l_counter number;
166: ------------------------------------------------------------------------
167: cursor get_org_a8a_applicable
168: is
169: select org_information19
170: from hr_organization_information,
171: pay_payroll_actions
172: where org_information_context ='SG_LEGAL_ENTITY'
173: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
174: and payroll_action_id = p_payroll_action_id;
2501: p_basis_start in date,
2502: p_basis_end in date)
2503: is
2504: --
2505: v_legal_entity_name hr_organization_information.org_information1%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2502: p_basis_end in date)
2503: is
2504: --
2505: v_legal_entity_name hr_organization_information.org_information1%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2503: is
2504: --
2505: v_legal_entity_name hr_organization_information.org_information1%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2504: --
2505: v_legal_entity_name hr_organization_information.org_information1%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2505: v_legal_entity_name hr_organization_information.org_information1%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2506: v_er_income_tax_number hr_organization_information.org_information4%type;
2507: v_er_ohq_status hr_organization_information.org_information12%type;
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2514: -- Added for bug 5078454
2508: v_er_iras_category hr_organization_information.org_information13%type;
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2514: -- Added for bug 5078454
2515: v_er_bonus_date hr_organization_information.org_information8%type;
2516: -- Added for bug 5435088
2509: v_er_telephone_no hr_organization_information.org_information14%type;
2510: v_er_payer_id hr_organization_information.org_information15%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2514: -- Added for bug 5078454
2515: v_er_bonus_date hr_organization_information.org_information8%type;
2516: -- Added for bug 5435088
2517: v_er_auth_person_email hr_organization_information.org_information5%type;
2511: -- Added for bug 3093991
2512: v_er_designation_type hr_organization_information.org_information17%type;
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2514: -- Added for bug 5078454
2515: v_er_bonus_date hr_organization_information.org_information8%type;
2516: -- Added for bug 5435088
2517: v_er_auth_person_email hr_organization_information.org_information5%type;
2518: v_er_division hr_organization_information.org_information8%type;
2519: -- Added for bug 7415444
2513: v_er_position_seg_type hr_organization_information.org_information18%type;
2514: -- Added for bug 5078454
2515: v_er_bonus_date hr_organization_information.org_information8%type;
2516: -- Added for bug 5435088
2517: v_er_auth_person_email hr_organization_information.org_information5%type;
2518: v_er_division hr_organization_information.org_information8%type;
2519: -- Added for bug 7415444
2520: v_er_a8b_incorp_date hr_organization_information.org_information9%type;
2521: v_shares_nsop_count number;
2514: -- Added for bug 5078454
2515: v_er_bonus_date hr_organization_information.org_information8%type;
2516: -- Added for bug 5435088
2517: v_er_auth_person_email hr_organization_information.org_information5%type;
2518: v_er_division hr_organization_information.org_information8%type;
2519: -- Added for bug 7415444
2520: v_er_a8b_incorp_date hr_organization_information.org_information9%type;
2521: v_shares_nsop_count number;
2522: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2516: -- Added for bug 5435088
2517: v_er_auth_person_email hr_organization_information.org_information5%type;
2518: v_er_division hr_organization_information.org_information8%type;
2519: -- Added for bug 7415444
2520: v_er_a8b_incorp_date hr_organization_information.org_information9%type;
2521: v_shares_nsop_count number;
2522: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2523: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2524:
2538: target.org_information18,
2539: target.org_information8,
2540: target.org_information9
2541: from hr_organization_units org,
2542: hr_organization_information target,
2543: hr_soft_coding_keyflex scl
2544: where org.business_group_id = c_business_group_id
2545: and org.organization_id = c_legal_entity_id
2546: and org.organization_id = target.organization_id
2554: is
2555: select target.org_information5,
2556: target.org_information7
2557: from hr_organization_units org,
2558: hr_organization_information target,
2559: hr_soft_coding_keyflex scl
2560: where org.business_group_id = c_business_group_id
2561: and org.organization_id = c_legal_entity_id
2562: and org.organization_id = target.organization_id
3598: p_assignment_id in per_all_assignments_f.assignment_id%type,
3599: p_legal_entity_id in hr_organization_units.organization_id%type,
3600: p_basis_start in date,
3601: p_basis_end in date,
3602: p_er_designation_type in hr_organization_information.org_information17%type,
3603: p_er_position_seg_type in hr_organization_information.org_information18%type)
3604: is
3605: --
3606: v_designation hr_all_positions_f.name%type;
3599: p_legal_entity_id in hr_organization_units.organization_id%type,
3600: p_basis_start in date,
3601: p_basis_end in date,
3602: p_er_designation_type in hr_organization_information.org_information17%type,
3603: p_er_position_seg_type in hr_organization_information.org_information18%type)
3604: is
3605: --
3606: v_designation hr_all_positions_f.name%type;
3607:
3725: c_assignment_id per_all_assignments_f.assignment_id%type,
3726: c_basis_start date,
3727: c_basis_end date,
3728: c_legal_entity_id hr_organization_units.organization_id%type,
3729: c_er_position_seg_type hr_organization_information.org_information18
3730: %type) is
3731:
3732: select decode(fifs.application_column_name, 'SEGMENT1', ppd.segment1,
3733: 'SEGMENT2', ppd.segment2,
3764: hr_all_positions_f pos,
3765: hr_all_positions_f_tl pst,
3766: per_position_definitions ppd,
3767: hr_organization_units hou,
3768: hr_organization_information hoi,
3769: fnd_id_flex_segments fifs,
3770: fnd_id_flex_structures fift
3771: where assign.person_id = c_person_id
3772: and assign.assignment_id = c_assignment_id
4028: from per_all_people_f pap,
4029: per_people_extra_info pei,
4030: per_people_extra_info pei2,
4031: hr_all_organization_units hou,
4032: hr_organization_information hoi2,
4033: hr_organization_information hoi1
4034: where pap.person_id = c_person_id
4035: and pap.person_id = pei.person_id
4036: and pei.information_type = 'HR_STOCK_EXERCISE_SG'
4029: per_people_extra_info pei,
4030: per_people_extra_info pei2,
4031: hr_all_organization_units hou,
4032: hr_organization_information hoi2,
4033: hr_organization_information hoi1
4034: where pap.person_id = c_person_id
4035: and pap.person_id = pei.person_id
4036: and pei.information_type = 'HR_STOCK_EXERCISE_SG'
4037: and pap.person_id = pei2.person_id