DBA Data[Home] [Help]

APPS.HR_PL_CONTACT_REL_API dependencies on PER_CONTACT_RELATIONSHIPS

Line 835: ,p_comments in PER_CONTACT_RELATIONSHIPS.COMMENTS%TYPE default hr_api.g_varchar2 -- bug 13375568

831: (p_validate in boolean default false
832: ,p_effective_date in date
833: ,p_contact_relationship_id in number
834: ,p_contact_type in varchar2 default hr_api.g_varchar2
835: ,p_comments in PER_CONTACT_RELATIONSHIPS.COMMENTS%TYPE default hr_api.g_varchar2 -- bug 13375568
836: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
837: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
838: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
839: ,p_date_start in date default hr_api.g_date

Line 902: from per_contact_relationships pr

898: cursor csr_bg is
899: select legislation_code
900: from per_business_groups pbg
901: where pbg.business_group_id in (select pr.business_group_id
902: from per_contact_relationships pr
903: where pr.contact_relationship_id = p_contact_relationship_id);
904: --
905: begin
906: