DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 5131: l_org_name org_organization_definitions.organization_name%type;

5127:
5128: FUNCTION GET_EXPENDITURE_ORG (p_wc_id IN NUMBER)
5129: RETURN VARCHAR2 IS
5130: l_count number;
5131: l_org_name org_organization_definitions.organization_name%type;
5132: begin
5133:
5134: select count(*)
5135: into l_count

Line 5136: from org_organization_definitions ood,

5132: begin
5133:
5134: select count(*)
5135: into l_count
5136: from org_organization_definitions ood,
5137: po_distributions_all pod
5138: where pod.expenditure_organization_id = ood.organization_id
5139: and pod.po_distribution_id = p_wc_id;
5140:

Line 5148: from org_organization_definitions ood,

5144: else
5145:
5146: select ood.organization_name
5147: into l_org_name
5148: from org_organization_definitions ood,
5149: po_distributions_all pod
5150: where pod.expenditure_organization_id = ood.organization_id
5151: and pod.po_distribution_id = p_wc_id;
5152: