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

Line 447: HR_ORGANIZATION_INFORMATION hoi,

443: p_asg_lu_org_id number)
444: IS
445: select hoi.ORG_INFORMATION1
446: FROM
447: HR_ORGANIZATION_INFORMATION hoi,
448: HR_ORGANIZATION_UNITS hou,
449: HR_ORGANIZATION_INFORMATION hoi1
450: where hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
451: and HOi1.ORG_INFORMATION_CONTEXT = 'CLASS'

Line 449: HR_ORGANIZATION_INFORMATION hoi1

445: select hoi.ORG_INFORMATION1
446: FROM
447: HR_ORGANIZATION_INFORMATION hoi,
448: HR_ORGANIZATION_UNITS hou,
449: HR_ORGANIZATION_INFORMATION hoi1
450: where hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
451: and HOi1.ORG_INFORMATION_CONTEXT = 'CLASS'
452: and HOI1.org_information2 ='Y'
453: and HOI1.org_information1 = 'NO_LOCAL_UNIT'

Line 459: l_asg_lu_org_num HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

455: and hou.organization_id = hoi.organization_id
456: and hou.business_group_id= p_business_group_id
457: and hoi.organization_id = p_asg_lu_org_id;
458:
459: l_asg_lu_org_num HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
460:
461: CURSOR Cur_Rec_uploaded
462: (
463: --p_mun_sso_num IN VARCHAR2

Line 949: l_business_id hr_organization_information.org_information1%TYPE ;

945:
946: -- l_company_terminating varchar2(1); bug 10367494
947: l_emp_id hr_organization_units.organization_id%TYPE ;
948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
952: l_org_type hr_organization_information.org_information1%TYPE ;
953: l_date VARCHAR2(100);

Line 950: l_cvr_number hr_organization_information.org_information1%TYPE ;

946: -- l_company_terminating varchar2(1); bug 10367494
947: l_emp_id hr_organization_units.organization_id%TYPE ;
948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
952: l_org_type hr_organization_information.org_information1%TYPE ;
953: l_date VARCHAR2(100);
954: l_time VARCHAR2(10);

Line 951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

947: l_emp_id hr_organization_units.organization_id%TYPE ;
948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
952: l_org_type hr_organization_information.org_information1%TYPE ;
953: l_date VARCHAR2(100);
954: l_time VARCHAR2(10);
955:

Line 952: l_org_type hr_organization_information.org_information1%TYPE ;

948: l_le_name hr_organization_units.name%TYPE ;
949: l_business_id hr_organization_information.org_information1%TYPE ;
950: l_cvr_number hr_organization_information.org_information1%TYPE ;
951: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
952: l_org_type hr_organization_information.org_information1%TYPE ;
953: l_date VARCHAR2(100);
954: l_time VARCHAR2(10);
955:
956: l_date_id VARCHAR2(20);

Line 976: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

972:
973: /*Cursors */
974:
975: /*Legal Employer Information*/
976: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
977: IS
978: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
979: FROM hr_organization_units o1
980: , hr_organization_information hoi1

Line 980: , hr_organization_information hoi1

976: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
977: IS
978: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
979: FROM hr_organization_units o1
980: , hr_organization_information hoi1
981: , hr_organization_information hoi2
982: WHERE o1.business_group_id =l_business_group_id
983: AND hoi1.organization_id = o1.organization_id
984: AND hoi1.organization_id = csr_v_legal_emp_id

Line 981: , hr_organization_information hoi2

977: IS
978: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
979: FROM hr_organization_units o1
980: , hr_organization_information hoi1
981: , hr_organization_information hoi2
982: WHERE o1.business_group_id =l_business_group_id
983: AND hoi1.organization_id = o1.organization_id
984: AND hoi1.organization_id = csr_v_legal_emp_id
985: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 993: Cursor csr_Legal_Emp_MO_FO_FH ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

989:
990: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
991:
992: /*Legal Employer MO, FO, EH Codes */
993: Cursor csr_Legal_Emp_MO_FO_FH ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
994: IS
995: SELECT
996: hoi2.ORG_INFORMATION2,
997: hoi2.ORG_INFORMATION3,

Line 1002: , hr_organization_information hoi1

998: hoi2.ORG_INFORMATION4,
999: hoi2.ORG_INFORMATION5,
1000: hoi2.ORG_INFORMATION6
1001: FROM hr_organization_units o1
1002: , hr_organization_information hoi1
1003: , hr_organization_information hoi2
1004: WHERE o1.business_group_id =l_business_group_id
1005: AND hoi1.organization_id = o1.organization_id
1006: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1003: , hr_organization_information hoi2

999: hoi2.ORG_INFORMATION5,
1000: hoi2.ORG_INFORMATION6
1001: FROM hr_organization_units o1
1002: , hr_organization_information hoi1
1003: , hr_organization_information hoi2
1004: WHERE o1.business_group_id =l_business_group_id
1005: AND hoi1.organization_id = o1.organization_id
1006: AND hoi1.organization_id = csr_v_legal_emp_id
1007: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1018: select * from hr_organization_information

1014:
1015: -- Service Provider information.
1016: cursor service_provider_details
1017: is
1018: select * from hr_organization_information
1019: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
1020: and organization_id in (
1021: select organization_id from hr_organization_units
1022: where business_group_id= l_business_group_id);

Line 1069: hr_organization_information hoi,

1065: FROM
1066: pay_payrolls_f ppf,
1067: per_assignments_f paf,
1068: hr_organization_units hou,
1069: hr_organization_information hoi,
1070: hr_soft_coding_keyflex scl,
1071: per_time_periods ptp
1072: WHERE hou.business_group_id = l_business_group_id
1073: AND hou.organization_id = g_legal_employer_id

Line 1100: FROM hr_organization_information

1096: l_report_type VARCHAR2(100);
1097:
1098: CURSOR csr_use_hol_card(p_org_id NUMBER) is
1099: SELECT NVL(org_information5,'N')
1100: FROM hr_organization_information
1101: WHERE organization_id = p_org_id
1102: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1103:
1104: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS