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.PAY_SG_IRAS_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 23: g_legal_entity_name hr_organization_information.org_information1%type;

19: g_name_of_bank ff_archive_items.value%type;
20: g_org_run char(1);
21: g_org_a8a_run char(1);
22: g_national_identifier per_all_people_f.national_identifier%type;
23: g_legal_entity_name hr_organization_information.org_information1%type;
24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;

Line 24: g_er_income_tax_number hr_organization_information.org_information4%type;

20: g_org_run char(1);
21: g_org_a8a_run char(1);
22: g_national_identifier per_all_people_f.national_identifier%type;
23: g_legal_entity_name hr_organization_information.org_information1%type;
24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;

Line 25: g_er_auth_person hr_organization_information.org_information10%type;

21: g_org_a8a_run char(1);
22: g_national_identifier per_all_people_f.national_identifier%type;
23: g_legal_entity_name hr_organization_information.org_information1%type;
24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;

Line 26: g_er_auth_person_desig hr_organization_information.org_information11%type;

22: g_national_identifier per_all_people_f.national_identifier%type;
23: g_legal_entity_name hr_organization_information.org_information1%type;
24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;

Line 27: g_er_ohq_status hr_organization_information.org_information12%type;

23: g_legal_entity_name hr_organization_information.org_information1%type;
24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;

Line 28: g_er_iras_category hr_organization_information.org_information13%type;

24: g_er_income_tax_number hr_organization_information.org_information4%type;
25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;

Line 29: g_er_telephone_no hr_organization_information.org_information14%type;

25: g_er_auth_person hr_organization_information.org_information10%type;
26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%type;

Line 30: g_er_payer_id hr_organization_information.org_information15%type;

26: g_er_auth_person_desig hr_organization_information.org_information11%type;
27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;

Line 31: g_er_designation_type hr_organization_information.org_information17%type;

27: g_er_ohq_status hr_organization_information.org_information12%type;
28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%type;
34: g_er_auth_person_email hr_organization_information.org_information5%type;
35: g_er_division hr_organization_information.org_information8%type;

Line 32: g_er_position_seg_type hr_organization_information.org_information18%type;

28: g_er_iras_category hr_organization_information.org_information13%type;
29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%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);

Line 33: g_er_bonus_date hr_organization_information.org_information8%type;

29: g_er_telephone_no hr_organization_information.org_information14%type;
30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%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: l_counter number;

Line 34: g_er_auth_person_email hr_organization_information.org_information5%type;

30: g_er_payer_id hr_organization_information.org_information15%type;
31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%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: l_counter number;
38: --------------------------------------------------------------------------------------------------------

Line 35: g_er_division hr_organization_information.org_information8%type;

31: g_er_designation_type hr_organization_information.org_information17%type;
32: g_er_position_seg_type hr_organization_information.org_information18%type;
33: g_er_bonus_date hr_organization_information.org_information8%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: l_counter number;
38: --------------------------------------------------------------------------------------------------------
39: -- Bug# 3501927 A8A Balance store rec

Line 167: from hr_organization_information,

163: ------------------------------------------------------------------------
164: cursor get_org_a8a_applicable
165: is
166: select org_information19
167: from hr_organization_information,
168: pay_payroll_actions
169: where org_information_context ='SG_LEGAL_ENTITY'
170: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
171: and payroll_action_id = p_payroll_action_id;

Line 2494: v_legal_entity_name hr_organization_information.org_information1%type;

2490: p_basis_start in date,
2491: p_basis_end in date)
2492: is
2493: --
2494: v_legal_entity_name hr_organization_information.org_information1%type;
2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;

Line 2495: v_er_income_tax_number hr_organization_information.org_information4%type;

2491: p_basis_end in date)
2492: is
2493: --
2494: v_legal_entity_name hr_organization_information.org_information1%type;
2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;

Line 2496: v_er_auth_person hr_organization_information.org_information10%type;

2492: is
2493: --
2494: v_legal_entity_name hr_organization_information.org_information1%type;
2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;

Line 2497: v_er_auth_person_desig hr_organization_information.org_information11%type;

2493: --
2494: v_legal_entity_name hr_organization_information.org_information1%type;
2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;

Line 2498: v_er_ohq_status hr_organization_information.org_information12%type;

2494: v_legal_entity_name hr_organization_information.org_information1%type;
2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991

Line 2499: v_er_iras_category hr_organization_information.org_information13%type;

2495: v_er_income_tax_number hr_organization_information.org_information4%type;
2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;

Line 2500: v_er_telephone_no hr_organization_information.org_information14%type;

2496: v_er_auth_person hr_organization_information.org_information10%type;
2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;
2504: v_er_position_seg_type hr_organization_information.org_information18%type;

Line 2501: v_er_payer_id hr_organization_information.org_information15%type;

2497: v_er_auth_person_desig hr_organization_information.org_information11%type;
2498: v_er_ohq_status hr_organization_information.org_information12%type;
2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;
2504: v_er_position_seg_type hr_organization_information.org_information18%type;
2505: -- Added for bug 5078454

Line 2503: v_er_designation_type hr_organization_information.org_information17%type;

2499: v_er_iras_category hr_organization_information.org_information13%type;
2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;
2504: v_er_position_seg_type hr_organization_information.org_information18%type;
2505: -- Added for bug 5078454
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088

Line 2504: v_er_position_seg_type hr_organization_information.org_information18%type;

2500: v_er_telephone_no hr_organization_information.org_information14%type;
2501: v_er_payer_id hr_organization_information.org_information15%type;
2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;
2504: v_er_position_seg_type hr_organization_information.org_information18%type;
2505: -- Added for bug 5078454
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;

Line 2506: v_er_bonus_date hr_organization_information.org_information8%type;

2502: -- Added for bug 3093991
2503: v_er_designation_type hr_organization_information.org_information17%type;
2504: v_er_position_seg_type hr_organization_information.org_information18%type;
2505: -- Added for bug 5078454
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;
2509: v_er_division hr_organization_information.org_information8%type;
2510: l_pri_assignment_id per_all_assignments_f.assignment_id%type;

Line 2508: v_er_auth_person_email hr_organization_information.org_information5%type;

2504: v_er_position_seg_type hr_organization_information.org_information18%type;
2505: -- Added for bug 5078454
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;
2509: v_er_division hr_organization_information.org_information8%type;
2510: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2511: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2512:

Line 2509: v_er_division hr_organization_information.org_information8%type;

2505: -- Added for bug 5078454
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;
2509: v_er_division hr_organization_information.org_information8%type;
2510: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2511: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2512:
2513:

Line 2531: hr_organization_information target,

2527: target.org_information17,
2528: target.org_information18,
2529: target.org_information8
2530: from hr_organization_units org,
2531: hr_organization_information target,
2532: hr_soft_coding_keyflex scl
2533: where org.business_group_id = c_business_group_id
2534: and org.organization_id = c_legal_entity_id
2535: and org.organization_id = target.organization_id

Line 2547: hr_organization_information target,

2543: is
2544: select target.org_information5,
2545: target.org_information7
2546: from hr_organization_units org,
2547: hr_organization_information target,
2548: hr_soft_coding_keyflex scl
2549: where org.business_group_id = c_business_group_id
2550: and org.organization_id = c_legal_entity_id
2551: and org.organization_id = target.organization_id

Line 3472: p_er_designation_type in hr_organization_information.org_information17%type,

3468: p_assignment_id in per_all_assignments_f.assignment_id%type,
3469: p_legal_entity_id in hr_organization_units.organization_id%type,
3470: p_basis_start in date,
3471: p_basis_end in date,
3472: p_er_designation_type in hr_organization_information.org_information17%type,
3473: p_er_position_seg_type in hr_organization_information.org_information18%type)
3474: is
3475: --
3476: v_designation hr_all_positions_f.name%type;

Line 3473: p_er_position_seg_type in hr_organization_information.org_information18%type)

3469: p_legal_entity_id in hr_organization_units.organization_id%type,
3470: p_basis_start in date,
3471: p_basis_end in date,
3472: p_er_designation_type in hr_organization_information.org_information17%type,
3473: p_er_position_seg_type in hr_organization_information.org_information18%type)
3474: is
3475: --
3476: v_designation hr_all_positions_f.name%type;
3477:

Line 3599: c_er_position_seg_type hr_organization_information.org_information18

3595: c_assignment_id per_all_assignments_f.assignment_id%type,
3596: c_basis_start date,
3597: c_basis_end date,
3598: c_legal_entity_id hr_organization_units.organization_id%type,
3599: c_er_position_seg_type hr_organization_information.org_information18
3600: %type) is
3601:
3602: select decode(fifs.application_column_name, 'SEGMENT1', ppd.segment1,
3603: 'SEGMENT2', ppd.segment2,

Line 3638: hr_organization_information hoi,

3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3638: hr_organization_information hoi,
3639: fnd_id_flex_segments fifs,
3640: fnd_id_flex_structures fift
3641: where assign.person_id = c_person_id
3642: and assign.assignment_id = c_assignment_id

Line 3887: hr_organization_information hoi2,

3883: from per_all_people_f pap,
3884: per_people_extra_info pei,
3885: per_people_extra_info pei2,
3886: hr_all_organization_units hou,
3887: hr_organization_information hoi2,
3888: hr_organization_information hoi1
3889: where pap.person_id = c_person_id
3890: and pap.person_id = pei.person_id
3891: and pei.information_type = 'HR_STOCK_EXERCISE_SG'

Line 3888: hr_organization_information hoi1

3884: per_people_extra_info pei,
3885: per_people_extra_info pei2,
3886: hr_all_organization_units hou,
3887: hr_organization_information hoi2,
3888: hr_organization_information hoi1
3889: where pap.person_id = c_person_id
3890: and pap.person_id = pei.person_id
3891: and pei.information_type = 'HR_STOCK_EXERCISE_SG'
3892: and pap.person_id = pei2.person_id