DBA Data[Home] [Help]

APPS.PQH_PQHWSBPR_XMLP_PKG dependencies on PQH_BUDGETS

Line 12: PQH_BUDGETS BGT,

8: SELECT
9: BUDGET_NAME,
10: VERSION_NUMBER
11: FROM
12: PQH_BUDGETS BGT,
13: PQH_BUDGET_VERSIONS BVR
14: WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
15: AND BGT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
16: AND BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line 22: PQH_BUDGETS BGT,

18: SELECT
19: BG.CURRENCY_CODE
20: FROM
21: PER_BUSINESS_GROUPS BG,
22: PQH_BUDGETS BGT,
23: PQH_BUDGET_VERSIONS BVR
24: WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
25: AND BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
26: AND BGT.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID;

Line 31: PQH_BUDGETS BGT,

27: CURSOR CSR_BGT_CURR IS
28: SELECT
29: BGT.CURRENCY_CODE
30: FROM
31: PQH_BUDGETS BGT,
32: PQH_BUDGET_VERSIONS BVR
33: WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
34: AND BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
35: CURSOR CSR_SESSION_DATE IS