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_DPSA dependencies on HR_ORGANIZATION_UNITS

Line 123: l_emp_id hr_organization_units.organization_id%TYPE ;

119: l_action_info_id NUMBER;
120: l_ovn NUMBER;
121: l_count NUMBER := 0;
122: l_business_group_id NUMBER;
123: l_emp_id hr_organization_units.organization_id%TYPE ;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;

Line 124: l_le_name hr_organization_units.name%TYPE ;

120: l_ovn NUMBER;
121: l_count NUMBER := 0;
122: l_business_group_id NUMBER;
123: l_emp_id hr_organization_units.organization_id%TYPE ;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;

Line 125: l_lu_name hr_organization_units.name%TYPE ;

121: l_count NUMBER := 0;
122: l_business_group_id NUMBER;
123: l_emp_id hr_organization_units.organization_id%TYPE ;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_business_id hr_organization_information.org_information1%TYPE ;
127: l_y_number hr_organization_information.org_information1%TYPE ;
128: l_contact_person hr_organization_information.org_information1%TYPE ;
129: l_phone hr_organization_information.org_information1%TYPE ;

Line 137: FROM hr_organization_units o1

133: /*Local Unit Information*/
134: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
135: IS
136: SELECT o1.name , hoi2.ORG_INFORMATION1
137: FROM hr_organization_units o1
138: , hr_organization_information hoi1
139: , hr_organization_information hoi2
140: WHERE o1.business_group_id =l_business_group_id
141: AND hoi1.organization_id = o1.organization_id

Line 154: FROM hr_organization_units o1

150: /*Legal Employer Information*/
151: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
152: IS
153: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION13
154: FROM hr_organization_units o1
155: , hr_organization_information hoi1
156: , hr_organization_information hoi2
157: WHERE o1.business_group_id =l_business_group_id
158: AND hoi1.organization_id = o1.organization_id

Line 172: FROM hr_organization_units o1

168: /*Legal Employer Contact Information*/
169: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
170: IS
171: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
172: FROM hr_organization_units o1
173: , hr_organization_information hoi1
174: , hr_organization_information hoi3
175: , hr_organization_information hoi4
176: WHERE o1.business_group_id =l_business_group_id

Line 194: FROM hr_organization_units o1

190: /*Local Unit Contact Information*/
191: Cursor csr_Local_Unit_contact ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
192: IS
193: SELECT hoi4.ORG_INFORMATION2 contact_person , hoi3.ORG_INFORMATION2 phone
194: FROM hr_organization_units o1
195: , hr_organization_information hoi1
196: , hr_organization_information hoi3
197: , hr_organization_information hoi4
198: WHERE o1.business_group_id =l_business_group_id