APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_PROJECTS

Line 60: from pa_projects_all p, pa_project_types_all pt

56: IF proj is null THEN
57: IF from_project_number is null then
58: begin
59: select min(p.segment1) into from_project_number
60: from pa_projects_all p, pa_project_types_all pt
61: where p.project_type = pt.project_type
62: and pt.project_type_class_code = 'CONTRACT';
63: exception
64: when no_data_found then

Line 76: from pa_projects_all p, pa_project_types_all pt

72:
73: IF to_project_number is null then
74: begin
75: select max(p.segment1) into to_project_number
76: from pa_projects_all p, pa_project_types_all pt
77: where p.project_type = pt.project_type
78: and pt.project_type_class_code = 'CONTRACT';
79: exception
80: when no_data_found then

Line 228: PA_PROJECTS P,

224: ,0)
225: ,0))
226: ,0)
227: FROM
228: PA_PROJECTS P,
229: PA_PROJECT_PLAYERS PL,
230: PA_DRAFT_INVOICES PDI,
231: PA_DRAFT_INVOICES PDI1,
232: PA_DRAFT_INVOICE_ITEMS PDII

Line 370: PA_PROJECTS P,

366: SELECT
367: DISTINCT
368: P.PROJECT_ID
369: FROM
370: PA_PROJECTS P,
371: PA_PROJECT_PLAYERS PL
372: WHERE P.CARRYING_OUT_ORGANIZATION_ID BETWEEN NVL(P_ORG_ID
373: ,0)
374: AND NVL(P_ORG_ID

Line 614: PA_PROJECTS P,

610: ,NVL(PCR.AMOUNT
611: ,0)
612: ,0))
613: FROM
614: PA_PROJECTS P,
615: PA_PROJECT_PLAYERS PL,
616: PA_EVENTS PE,
617: PA_EVENT_TYPES PET,
618: PA_DRAFT_REVENUES PDR,

Line 761: PA_PROJECTS P,

757: ,NVL(PCR.AMOUNT
758: ,0)
759: ,0))
760: FROM
761: PA_PROJECTS P,
762: PA_PROJECT_PLAYERS PL,
763: PA_EVENTS PE,
764: PA_EVENT_TYPES PET,
765: PA_DRAFT_REVENUES PDR,

Line 829: PA_PROJECTS P,

825: WHERE EXISTS (
826: SELECT
827: 1
828: FROM
829: PA_PROJECTS P,
830: PA_PROJECT_PLAYERS PL,
831: PA_DRAFT_INVOICES PDI,
832: PA_DRAFT_INVOICE_ITEMS PDII
833: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID

Line 954: PA_PROJECTS P,

950: ,NVL(PDII.PROJFUNC_BILL_AMOUNT
951: ,0)
952: ,0)) * - 1
953: FROM
954: PA_PROJECTS P,
955: PA_PROJECT_PLAYERS PL,
956: PA_DRAFT_INVOICES PDI,
957: PA_DRAFT_INVOICE_ITEMS PDII
958: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID

Line 1007: PA_PROJECTS P,

1003: ,0))
1004: ,TO_CHAR(NVL(PDII.PROJFUNC_BILL_AMOUNT
1005: ,0)))))
1006: FROM
1007: PA_PROJECTS P,
1008: PA_PROJECT_PLAYERS PL,
1009: PA_EVENT_TYPES PET,
1010: PA_EVENTS PE,
1011: PA_DRAFT_INVOICES PDI,

Line 1100: PA_PROJECTS P,

1096: SET
1097: COST_WORK_AMOUNT = (SELECT
1098: SUM(PCR.PROJFUNC_BILL_AMOUNT)
1099: FROM
1100: PA_PROJECTS P,
1101: PA_PROJECT_PLAYERS PL,
1102: PA_CUST_REV_DIST_LINES PCR,
1103: PA_DRAFT_INVOICES PDI
1104: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID

Line 1139: PA_PROJECTS P,

1135: SET
1136: INVOICE_REDUCTION = (SELECT
1137: SUM(PE.PROJFUNC_BILL_AMOUNT)
1138: FROM
1139: PA_PROJECTS P,
1140: PA_PROJECT_PLAYERS PL,
1141: PA_EVENT_TYPES PET,
1142: PA_EVENTS PE
1143: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID

Line 1302: PA_PROJECTS

1298: CURSOR C IS
1299: SELECT
1300: PROJECT_ID
1301: FROM
1302: PA_PROJECTS
1303: WHERE PROJECT_ID between NVL(PROJ
1304: ,0)
1305: AND NVL(PROJ
1306: ,999999999999999);

Line 1313: PA_PROJECTS P

1309: (PROJECT_ID)
1310: SELECT
1311: P.PROJECT_ID
1312: FROM
1313: PA_PROJECTS P
1314: WHERE P.PROJECT_ID between NVL(PROJ
1315: ,0)
1316: AND NVL(PROJ
1317: ,999999999999999)