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.

[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on HR_ORGANIZATION_UNITS

Line 210: l_emp_id hr_organization_units.organization_id%TYPE ;

206: l_count NUMBER := 0;
207: l_business_group_id NUMBER;
208: l_test_submission varchar2(1);
209: -- l_company_terminating varchar2(1); bug 10367494
210: l_emp_id hr_organization_units.organization_id%TYPE ;
211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

Line 211: l_le_name hr_organization_units.name%TYPE ;

207: l_business_group_id NUMBER;
208: l_test_submission varchar2(1);
209: -- l_company_terminating varchar2(1); bug 10367494
210: l_emp_id hr_organization_units.organization_id%TYPE ;
211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
215: l_org_type hr_organization_information.org_information1%TYPE ;

Line 231: FROM hr_organization_units o1

227: /*Legal Employer Information*/
228: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
229: IS
230: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
231: FROM hr_organization_units o1
232: , hr_organization_information hoi1
233: , hr_organization_information hoi2
234: WHERE o1.business_group_id =l_business_group_id
235: AND hoi1.organization_id = o1.organization_id

Line 250: select organization_id from hr_organization_units

246: is
247: select * from hr_organization_information
248: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
249: and organization_id in (
250: select organization_id from hr_organization_units
251: where business_group_id= l_business_group_id);
252:
253: sp service_provider_details%rowtype;
254:

Line 297: hr_organization_units hou,

293: ptp.TIME_PERIOD_ID
294: FROM
295: pay_payrolls_f ppf,
296: per_assignments_f paf,
297: hr_organization_units hou,
298: hr_organization_information hoi,
299: hr_soft_coding_keyflex scl,
300: per_time_periods ptp
301: WHERE hou.business_group_id = l_business_group_id

Line 916: bg_id hr_organization_units.business_group_id%type

912:
913: /* Cursor to get SE Number, PUCODE at HR Org level */
914:
915: CURSOR csr_get_hr_org_info(
916: bg_id hr_organization_units.business_group_id%type
917: ,hr_org_id hr_organization_information.organization_id%type) IS
918: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
919: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
920: FROM hr_organization_units o1

Line 920: FROM hr_organization_units o1

916: bg_id hr_organization_units.business_group_id%type
917: ,hr_org_id hr_organization_information.organization_id%type) IS
918: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
919: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
920: FROM hr_organization_units o1
921: , hr_organization_information hoi1
922: , hr_organization_information hoi2
923: WHERE o1.business_group_id =bg_id
924: AND hoi1.organization_id = o1.organization_id

Line 964: FROM hr_organization_units o1

960: /* Cursor to get the details of the legal employer */
961: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
962: IS
963: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
964: FROM hr_organization_units o1
965: , hr_organization_information hoi1
966: , hr_organization_information hoi2
967: WHERE o1.business_group_id =g_business_group_id
968: AND hoi1.organization_id = o1.organization_id