DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on HR_ORGANIZATION_UNITS

Line 635: SELECT 'X' from pa_all_organizations paorg,hr_organization_units hrorg

631: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
632: L_Value VARCHAR2(1) := 'N';
633:
634: CURSOR C (p_id NUMBER,p_bill_ou number) IS
635: SELECT 'X' from pa_all_organizations paorg,hr_organization_units hrorg
636: WHERE paorg.organization_id=hrorg.organization_id and nvl(paorg.org_id,-99)=nvl(p_bill_ou,-99)
637: and sysdate between hrorg.date_from and nvl(hrorg.date_to,sysdate+1) AND hrorg.organization_id=p_id ;
638:
639: