APPS.IRC_IAD_BUS dependencies on IRC_ASSIGNMENT_DETAILS_F

Line 33: from irc_assignment_details_f iad

29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: where pbg.business_group_id =
32: (select distinct asg.business_group_id
33: from irc_assignment_details_f iad
34: , per_all_assignments_f asg
35: where iad.assignment_details_id = p_assignment_details_id
36: and iad.assignment_id = asg.assignment_id);
37: --

Line 106: from irc_assignment_details_f iad

102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: where pbg.business_group_id =
105: (select distinct asg.business_group_id
106: from irc_assignment_details_f iad
107: , per_all_assignments_f asg
108: where iad.assignment_details_id = p_assignment_details_id
109: and iad.assignment_id = asg.assignment_id);
110: --

Line 464: irc_assignment_details_f.assignment_details_id%TYPE

460: -- ----------------------------------------------------------------------------
461: procedure chk_attempt_id
462: (p_attempt_id in number
463: ,p_assignment_details_id in
464: irc_assignment_details_f.assignment_details_id%TYPE
465: ,p_assignment_id in irc_assignment_details_f.assignment_id%TYPE
466: ,p_effective_date in date
467: ,p_object_version_number in
468: irc_assignment_details_f.object_version_number%TYPE

Line 465: ,p_assignment_id in irc_assignment_details_f.assignment_id%TYPE

461: procedure chk_attempt_id
462: (p_attempt_id in number
463: ,p_assignment_details_id in
464: irc_assignment_details_f.assignment_details_id%TYPE
465: ,p_assignment_id in irc_assignment_details_f.assignment_id%TYPE
466: ,p_effective_date in date
467: ,p_object_version_number in
468: irc_assignment_details_f.object_version_number%TYPE
469: )

Line 468: irc_assignment_details_f.object_version_number%TYPE

464: irc_assignment_details_f.assignment_details_id%TYPE
465: ,p_assignment_id in irc_assignment_details_f.assignment_id%TYPE
466: ,p_effective_date in date
467: ,p_object_version_number in
468: irc_assignment_details_f.object_version_number%TYPE
469: )
470: IS
471: --
472: l_proc varchar2(72) := g_package||'chk_attempt_id';

Line 550: (p_associated_column1 => 'IRC_ASSIGNMENT_DETAILS_F.ATTEMPT_ID'

546: hr_utility.set_location('Leaving: '||l_proc, 50);
547: exception
548: when app_exception.application_exception then
549: if hr_multi_message.exception_add
550: (p_associated_column1 => 'IRC_ASSIGNMENT_DETAILS_F.ATTEMPT_ID'
551: ) then
552: raise;
553: end if;
554: end chk_attempt_id;