DBA Data[Home] [Help]

APPS.IRC_APS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: , per_all_assignments_f paf

28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , irc_apl_profile_snapshots aps
32: , per_all_assignments_f paf
33: where aps.profile_snapshot_id = p_profile_snapshot_id
34: and paf.person_id = aps.person_id
35: and pbg.business_group_id = paf.business_group_id;
36: --

Line 104: , per_all_assignments_f paf

100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , irc_apl_profile_snapshots aps
104: , per_all_assignments_f paf
105: where aps.profile_snapshot_id = p_profile_snapshot_id
106: and paf.person_id = aps.person_id
107: and pbg.business_group_id = paf.business_group_id;
108: --