DBA Data[Home] [Help]

APPS.PAY_GB_WNU_RULES dependencies on PER_BUSINESS_GROUPS

Line 44: from per_business_groups pbg,

40: and information_type = 'GB_WNU';
41: --
42: cursor csr_bg is
43: select pbg.legislation_code
44: from per_business_groups pbg,
45: per_all_assignments_f aaf
46: where aaf.assignment_id = p_assignment_id
47: and aaf.business_group_id = pbg.business_group_id
48: and p_effective_date between

Line 210: from per_business_groups pbg,

206: aaf.effective_start_date and aaf.effective_end_date;
207: --
208: cursor csr_bg(c_assignment_id NUMBER) is
209: select pbg.legislation_code
210: from per_business_groups pbg,
211: per_all_assignments_f aaf
212: where aaf.assignment_id = c_assignment_id
213: and aaf.business_group_id = pbg.business_group_id
214: and p_effective_date between