DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 5458: l_org_name org_organization_definitions.organization_name%type;

5454:
5455: FUNCTION GET_EXPENDITURE_ORG (p_wc_id IN NUMBER)
5456: RETURN VARCHAR2 IS
5457: l_count number;
5458: l_org_name org_organization_definitions.organization_name%type;
5459: begin
5460:
5461: select count(*)
5462: into l_count

Line 5463: from org_organization_definitions ood,

5459: begin
5460:
5461: select count(*)
5462: into l_count
5463: from org_organization_definitions ood,
5464: po_distributions_all pod
5465: where pod.expenditure_organization_id = ood.organization_id
5466: and pod.po_distribution_id = p_wc_id;
5467:

Line 5475: from org_organization_definitions ood,

5471: else
5472:
5473: select ood.organization_name
5474: into l_org_name
5475: from org_organization_definitions ood,
5476: po_distributions_all pod
5477: where pod.expenditure_organization_id = ood.organization_id
5478: and pod.po_distribution_id = p_wc_id;
5479: