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

Line 541: hr_organization_information hoi1,

537: SELECT hoi2.org_information9
538: FROM pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: hr_organization_units hou,
541: hr_organization_information hoi1,
542: hr_organization_information hoi2
543: WHERE paa.payroll_action_id = ppa.payroll_action_id
544: AND ppa.business_group_id = hou.organization_id
545: AND hou.organization_id = hoi1.organization_id

Line 542: hr_organization_information hoi2

538: FROM pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: hr_organization_units hou,
541: hr_organization_information hoi1,
542: hr_organization_information hoi2
543: WHERE paa.payroll_action_id = ppa.payroll_action_id
544: AND ppa.business_group_id = hou.organization_id
545: AND hou.organization_id = hoi1.organization_id
546: AND hoi1.organization_id = hoi2.organization_id

Line 727: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

723: 'hla.LOCATION_CODE=csr_get_archived_info_rec.action_information30),''K'') INTO lt_rate_flg FROM DUAL;');
724: build_sql(sqlstr,l_cntr_sql,
725: 'IF lt_rate_flg = ''K'' THEN');
726: build_sql(sqlstr,l_cntr_sql,
727: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
728: 'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
729: build_sql(sqlstr,l_cntr_sql,
730: 'AND organization_id=csr_get_archived_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
731: build_sql(sqlstr,l_cntr_sql,

Line 734: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

730: 'AND organization_id=csr_get_archived_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
731: build_sql(sqlstr,l_cntr_sql,
732: 'IF lt_rate_flg = ''K'' THEN ');
733: build_sql(sqlstr,l_cntr_sql,
734: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
735: 'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
736: build_sql(sqlstr,l_cntr_sql,
737: 'AND organization_id='||lt_per_bgId_value||'),''K'') INTO lt_rate_flg FROM DUAL;'); --Bug 16451278
738: build_sql(sqlstr,l_cntr_sql,

Line 1296: hr_organization_information hoi1,

1292: SELECT hoi2.org_information9
1293: FROM pay_assignment_actions paa,
1294: pay_payroll_actions ppa,
1295: hr_organization_units hou,
1296: hr_organization_information hoi1,
1297: hr_organization_information hoi2
1298: WHERE paa.payroll_action_id = ppa.payroll_action_id
1299: AND ppa.business_group_id = hou.organization_id
1300: AND hou.organization_id = hoi1.organization_id

Line 1297: hr_organization_information hoi2

1293: FROM pay_assignment_actions paa,
1294: pay_payroll_actions ppa,
1295: hr_organization_units hou,
1296: hr_organization_information hoi1,
1297: hr_organization_information hoi2
1298: WHERE paa.payroll_action_id = ppa.payroll_action_id
1299: AND ppa.business_group_id = hou.organization_id
1300: AND hou.organization_id = hoi1.organization_id
1301: AND hoi1.organization_id = hoi2.organization_id