DBA Data[Home] [Help]

APPS.PAY_US_RETRO_OVERLAP dependencies on PER_BUSINESS_GROUPS

Line 104: FROM per_business_groups pbg,

100: AND ROWNUM < 2;*/
101: CURSOR c_get_legislative_bg(p_legislation_code IN VARCHAR2)
102: IS
103: SELECT business_group_id
104: FROM per_business_groups pbg,
105: hr_organization_information hoi
106: WHERE hoi.organization_id = pbg.business_group_id
107: AND hoi.org_information_context = 'Business Group Information'
108: AND hoi.org_information9 = UPPER(p_legislation_code);