DBA Data[Home] [Help]

APPS.PSP_POA_BUS dependencies on MO_GLOBAL

Line 513: AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(p.org_id) = 'Y')

509: AND p.pa_org_use_type = 'EXPENDITURES'
510: AND h.organization_id = p_expenditure_organization_id
511: AND h.business_group_id = l_business_group_id
512: -- AND nvl(p.org_id, -9999) = nvl(l_operating_unit, -9999)
513: AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(p.org_id) = 'Y')
514: or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ))
515: AND NVL(inactive_date,to_date('31/12/4712','DD/MM/RRRR')) > p_start_date_active;
516:
517:

Line 514: or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ))

510: AND h.organization_id = p_expenditure_organization_id
511: AND h.business_group_id = l_business_group_id
512: -- AND nvl(p.org_id, -9999) = nvl(l_operating_unit, -9999)
513: AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(p.org_id) = 'Y')
514: or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ))
515: AND NVL(inactive_date,to_date('31/12/4712','DD/MM/RRRR')) > p_start_date_active;
516:
517:
518: BEGIN