APPS.PA_MC_UPG dependencies on PA_IMPLEMENTATIONS_ALL

Line 95: FROM PA_IMPLEMENTATIONS_ALL

91: IS
92:
93: CURSOR C_Org IS
94: SELECT org_id
95: FROM PA_IMPLEMENTATIONS_ALL
96: WHERE set_of_books_id = G_Pri_SOB_ID;
97:
98: CURSOR C_Projects IS
99: SELECT Proj.Project_ID

Line 117: PA_IMPLEMENTATIONS_ALL IMP1,

113: Cursor C_CC_EI
114: IS
115: SELECT EI.expenditure_item_id
116: FROM PA_EXPENDITURE_ITEMS_ALL EI,
117: PA_IMPLEMENTATIONS_ALL IMP1,
118: PA_IMPLEMENTATIONS_ALL IMP2
119: WHERE EI.ORG_ID = G_Org_ID
120: AND EI.ORG_ID <> EI.RECVR_ORG_ID
121: AND IMP1.ORG_ID = EI.ORG_ID

Line 118: PA_IMPLEMENTATIONS_ALL IMP2

114: IS
115: SELECT EI.expenditure_item_id
116: FROM PA_EXPENDITURE_ITEMS_ALL EI,
117: PA_IMPLEMENTATIONS_ALL IMP1,
118: PA_IMPLEMENTATIONS_ALL IMP2
119: WHERE EI.ORG_ID = G_Org_ID
120: AND EI.ORG_ID <> EI.RECVR_ORG_ID
121: AND IMP1.ORG_ID = EI.ORG_ID
122: AND IMP1.set_of_books_id = G_Pri_SOB_ID

Line 1308: FROM PA_IMPLEMENTATIONS_ALL IMP1,

1304: Cursor C_SOB
1305: IS
1306: SELECT IMP1.set_of_books_id,
1307: IMP2.set_of_books_id
1308: FROM PA_IMPLEMENTATIONS_ALL IMP1,
1309: PA_IMPLEMENTATIONS_ALL IMP2
1310: WHERE IMP1.org_id = p_prvdr_org_id
1311: AND IMP2.org_id = p_recvr_org_id;
1312:

Line 1309: PA_IMPLEMENTATIONS_ALL IMP2

1305: IS
1306: SELECT IMP1.set_of_books_id,
1307: IMP2.set_of_books_id
1308: FROM PA_IMPLEMENTATIONS_ALL IMP1,
1309: PA_IMPLEMENTATIONS_ALL IMP2
1310: WHERE IMP1.org_id = p_prvdr_org_id
1311: AND IMP2.org_id = p_recvr_org_id;
1312:
1313: BEGIN