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

Line 1006: CURSOR c_org_id(p_org_name hr_organization_units.name%type)

1002: asg.effective_end_date BETWEEN p_start_date AND p_end_date
1003: );
1004:
1005: -- The cursor to find the organization id of the GRE/Legal entity id
1006: CURSOR c_org_id(p_org_name hr_organization_units.name%type)
1007: IS
1008: SELECT organization_id
1009: FROM hr_organization_units
1010: WHERE NAME = p_org_name

Line 1009: FROM hr_organization_units

1005: -- The cursor to find the organization id of the GRE/Legal entity id
1006: CURSOR c_org_id(p_org_name hr_organization_units.name%type)
1007: IS
1008: SELECT organization_id
1009: FROM hr_organization_units
1010: WHERE NAME = p_org_name
1011: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1012:
1013: -- The cursor to find the most recent 'assignment start date' for the effective date