DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on HR_ORGANIZATION_UNITS

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

1008: asg.effective_end_date BETWEEN p_start_date AND p_end_date
1009: );
1010:
1011: -- The cursor to find the organization id of the GRE/Legal entity id
1012: CURSOR c_org_id(p_org_name hr_organization_units.name%type)
1013: IS
1014: SELECT organization_id
1015: FROM hr_organization_units
1016: WHERE NAME = p_org_name

Line 1015: FROM hr_organization_units

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