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.HR_DE_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 57: FROM hr_organization_information inf

53: -- Cursor to return the current named hierarchy.
54: --
55: CURSOR c_hierarchy(p_organization_id NUMBER) IS
56: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
57: FROM hr_organization_information inf
58: ,hr_all_organization_units org
59: WHERE org.organization_id = p_organization_id
60: AND inf.organization_id = org.business_group_id
61: AND inf.org_information_context = 'DE_BG_INFO'

Line 162: 1. Chamber_contribution org_information1 hr_organization_information DE_CHAMBER_CONTRIBUTION |

158: the hierarchy until it finds a value for the data item. |
159: |
160: The following data items are required ; |
161: Data Item Column Table Context |
162: 1. Chamber_contribution org_information1 hr_organization_information DE_CHAMBER_CONTRIBUTION |
163: 2. employer_Betriebsnummer org_information1 hr_organization_information DE_HR_ORG_INFO |
164: 3. payroll_Betriebsnummer org_information2 hr_organization_information DE_HR_ORG_INFO |
165: -------------------------------------------------------------------------------------------------*/
166:

Line 163: 2. employer_Betriebsnummer org_information1 hr_organization_information DE_HR_ORG_INFO |

159: |
160: The following data items are required ; |
161: Data Item Column Table Context |
162: 1. Chamber_contribution org_information1 hr_organization_information DE_CHAMBER_CONTRIBUTION |
163: 2. employer_Betriebsnummer org_information1 hr_organization_information DE_HR_ORG_INFO |
164: 3. payroll_Betriebsnummer org_information2 hr_organization_information DE_HR_ORG_INFO |
165: -------------------------------------------------------------------------------------------------*/
166:
167: PROCEDURE get_org_data_items

Line 164: 3. payroll_Betriebsnummer org_information2 hr_organization_information DE_HR_ORG_INFO |

160: The following data items are required ; |
161: Data Item Column Table Context |
162: 1. Chamber_contribution org_information1 hr_organization_information DE_CHAMBER_CONTRIBUTION |
163: 2. employer_Betriebsnummer org_information1 hr_organization_information DE_HR_ORG_INFO |
164: 3. payroll_Betriebsnummer org_information2 hr_organization_information DE_HR_ORG_INFO |
165: -------------------------------------------------------------------------------------------------*/
166:
167: PROCEDURE get_org_data_items
168: (p_chamber_contribution_out OUT NOCOPY VARCHAR2

Line 183: ,hr_organization_information e

179: ,SUBSTR(org_information1, 1, 30) eb
180: ,SUBSTR(org_information2, 1, 30) pb
181: ,org_information_context ctx
182: FROM hr_organization_units d
183: ,hr_organization_information e
184: WHERE d.organization_id = e.organization_id
185: AND d.organization_id = p_org_id
186: AND e.org_information_context IN ('DE_CHAMBER_CONTRIBUTION','DE_HR_ORG_INFO');
187: --