DBA Data[Home] [Help]

APPS.IRC_DOCUMENT_API dependencies on HR_ORGANIZATION_INFORMATION

Line 1099: and pasf.business_group_id in ( select bginfo.organization_id from hr_organization_information bginfo

1095: paf.party_id = p_party_id
1096: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
1097: and trunc(sysdate) between pasf.effective_start_date and pasf.effective_end_date
1098: and pasf.person_id = paf.person_id
1099: and pasf.business_group_id in ( select bginfo.organization_id from hr_organization_information bginfo
1100: where bginfo.ORG_INFORMATION_CONTEXT = 'BG Recruitment'
1101: and bginfo.org_information11 = 'Y'
1102: );
1103: begin