APPS.PER_KR_CONTACT_RULES dependencies on PER_CONTACT_RELATIONSHIPS

Line 54: from per_contact_relationships ctr

50: cursor csr_dpnt is
51: select ctr.cont_information2 itax_law,
52: nvl(ctr.cont_information11, '0') kr_cont_type,
53: decode(ctr.contact_type, 'P', '1', 'S', '3', 'A', '4', 'C', '4', 'R', '4', 'O', '4', 'T', '4', '6') cont_type
54: from per_contact_relationships ctr
55: where ctr.cont_information_category = 'KR'
56: and ctr.cont_information1 = 'Y'
57: and ((ctr.cont_information9 ='D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(trunc(add_months(date_end,12),'YYYY')-1,p_effective_date))
58: or (nvl(ctr.cont_information9,'XXX') <>'D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(date_end, p_effective_date))

Line 104: from per_contact_relationships ctr

100: select ctr.cont_information2 itax_law,
101: nvl(ctr.cont_information11, '0') kr_cont_type,
102: decode(ctr.contact_type, 'S','3','P','1','B','5','SISTER','5',
103: 'A','4','C','4','R','4','O','4','T','4','6') cont_type --Bug 12714266
104: from per_contact_relationships ctr
105: where ctr.cont_information_category = 'KR'
106: and ctr.cont_information1 = 'Y'
107: and ((ctr.cont_information9 ='D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(trunc(add_months(date_end,12),'YYYY')-1,p_effective_date))
108: or (nvl(ctr.cont_information9,'XXX') <>'D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(date_end, p_effective_date))