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_FI_ARCHIVE_PYSA dependencies on HR_ORGANIZATION_INFORMATION

Line 126: FROM hr_organization_information

122: ,p_sql OUT NOCOPY VARCHAR2)
123: IS
124: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
125: SELECT org_information6 message
126: FROM hr_organization_information
127: WHERE organization_id = p_bus_grp_id
128: AND org_information_context = 'Business Group:Payslip Info'
129: AND org_information1 = 'MESG';
130: -----------------------------------------------------------------

Line 138: FROM hr_organization_information

134: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
135: SELECT org_information4 balance_type_id
136: ,org_information5 balance_dim_id
137: ,org_information7 narrative
138: FROM hr_organization_information
139: WHERE organization_id = p_bus_grp_id
140: AND org_information_context = 'Business Group:Payslip Info'
141: AND org_information1 = 'BALANCE';
142: /* Cursor to fetch defined balance id */

Line 179: FROM hr_organization_information hoi

175: ,hoi.org_information3 input_value_id
176: ,hoi.org_information7 element_narrative
177: ,pec.classification_name
178: ,piv.uom
179: FROM hr_organization_information hoi
180: ,pay_element_classifications pec
181: ,pay_element_types_f pet
182: ,pay_input_values_f piv
183: WHERE hoi.organization_id = p_bus_grp_id

Line 748: FROM hr_organization_information

744: WHERE organization_id = p_organization_id;
745: /* Cursor to retrieve Currency */
746: CURSOR csr_currency(p_bg_id NUMBER) IS
747: SELECT org_information10
748: FROM hr_organization_information
749: WHERE organization_id = p_bg_id
750: AND org_information_context = 'Business Group Information';
751: l_bg_id NUMBER;
752: CURSOR csr_legal_employer (p_organization_id NUMBER) IS

Line 755: , HR_ORGANIZATION_INFORMATION hoi1

751: l_bg_id NUMBER;
752: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
753: SELECT hoi3.organization_id
754: FROM HR_ORGANIZATION_UNITS o1
755: , HR_ORGANIZATION_INFORMATION hoi1
756: , HR_ORGANIZATION_INFORMATION hoi2
757: , HR_ORGANIZATION_INFORMATION hoi3
758: WHERE o1.business_group_id =l_bg_id
759: AND hoi1.organization_id = o1.organization_id

Line 756: , HR_ORGANIZATION_INFORMATION hoi2

752: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
753: SELECT hoi3.organization_id
754: FROM HR_ORGANIZATION_UNITS o1
755: , HR_ORGANIZATION_INFORMATION hoi1
756: , HR_ORGANIZATION_INFORMATION hoi2
757: , HR_ORGANIZATION_INFORMATION hoi3
758: WHERE o1.business_group_id =l_bg_id
759: AND hoi1.organization_id = o1.organization_id
760: AND hoi1.organization_id = p_organization_id

Line 757: , HR_ORGANIZATION_INFORMATION hoi3

753: SELECT hoi3.organization_id
754: FROM HR_ORGANIZATION_UNITS o1
755: , HR_ORGANIZATION_INFORMATION hoi1
756: , HR_ORGANIZATION_INFORMATION hoi2
757: , HR_ORGANIZATION_INFORMATION hoi3
758: WHERE o1.business_group_id =l_bg_id
759: AND hoi1.organization_id = o1.organization_id
760: AND hoi1.organization_id = p_organization_id
761: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 818: l_currency hr_organization_information.org_information10%TYPE;

814: l_nationality per_all_people_f.nationality%TYPE;
815: l_position per_all_positions.name%TYPE;
816: l_hire_date per_periods_of_service.date_start%TYPE;
817: l_grade per_grades.name%TYPE;
818: l_currency hr_organization_information.org_information10%TYPE;
819: l_organization hr_organization_units.name%TYPE;
820: l_pay_location hr_locations_all.address_line_1%TYPE;
821: l_postal_code VARCHAR2(80);
822: l_country VARCHAR2(30);

Line 834: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

830: l_employer_name hr_organization_units.name%TYPE;
831: l_local_unit_id hr_organization_units.organization_id%TYPE;
832: l_legal_employer_id hr_organization_units.organization_id%TYPE;
833: l_job PER_JOBS.NAME%TYPE;
834: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
835: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
836: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
837: l_defined_balance_id NUMBER;
838: l_balance_value NUMBER;

Line 1592: FROM hr_organization_information hoi

1588: ,hoi.org_information3 input_value_id
1589: ,hoi.org_information7 element_narrative
1590: ,pec.classification_name
1591: ,piv.uom
1592: FROM hr_organization_information hoi
1593: ,pay_element_classifications pec
1594: ,pay_element_types_f pet
1595: ,pay_input_values_f piv
1596: WHERE hoi.organization_id = p_bus_grp_id

Line 1707: FROM hr_organization_information

1703: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
1704: SELECT org_information4 balance_type_id
1705: ,org_information5 balance_dim_id
1706: ,org_information7 narrative
1707: FROM hr_organization_information
1708: WHERE organization_id = p_bus_grp_id
1709: AND org_information_context = 'Business Group:Payslip Info'
1710: AND org_information1 = 'BALANCE';
1711: /* Cursor to retrieve Tax Unit Id for setting context */

Line 2919: , HR_ORGANIZATION_INFORMATION hoi1

2915:
2916: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
2917: SELECT hoi3.organization_id
2918: FROM HR_ORGANIZATION_UNITS o1
2919: , HR_ORGANIZATION_INFORMATION hoi1
2920: , HR_ORGANIZATION_INFORMATION hoi2
2921: , HR_ORGANIZATION_INFORMATION hoi3
2922: WHERE o1.business_group_id =p_business_group_id
2923: AND hoi1.organization_id = o1.organization_id

Line 2920: , HR_ORGANIZATION_INFORMATION hoi2

2916: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
2917: SELECT hoi3.organization_id
2918: FROM HR_ORGANIZATION_UNITS o1
2919: , HR_ORGANIZATION_INFORMATION hoi1
2920: , HR_ORGANIZATION_INFORMATION hoi2
2921: , HR_ORGANIZATION_INFORMATION hoi3
2922: WHERE o1.business_group_id =p_business_group_id
2923: AND hoi1.organization_id = o1.organization_id
2924: AND hoi1.organization_id = p_organization_id

Line 2921: , HR_ORGANIZATION_INFORMATION hoi3

2917: SELECT hoi3.organization_id
2918: FROM HR_ORGANIZATION_UNITS o1
2919: , HR_ORGANIZATION_INFORMATION hoi1
2920: , HR_ORGANIZATION_INFORMATION hoi2
2921: , HR_ORGANIZATION_INFORMATION hoi3
2922: WHERE o1.business_group_id =p_business_group_id
2923: AND hoi1.organization_id = o1.organization_id
2924: AND hoi1.organization_id = p_organization_id
2925: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'