DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on PA_DRAFT_INVOICE_ITEMS

Line 1074: FROM pa_draft_invoice_items

1070: cursor c1 is
1071: SELECT 1
1072: FROM sys.dual
1073: WHERE EXISTS (SELECT NULL
1074: FROM pa_draft_invoice_items
1075: WHERE project_id = x_project_id);
1076:
1077: cursor c2 is
1078: SELECT 1

Line 1081: FROM pa_draft_invoice_items

1077: cursor c2 is
1078: SELECT 1
1079: FROM sys.dual
1080: where exists (SELECT NULL
1081: FROM pa_draft_invoice_items
1082: where project_id = x_proj_id
1083: AND TASK_ID IN
1084: (SELECT TASK_ID
1085: FROM PA_TASKS

Line 1093: FROM pa_draft_invoice_items

1089: /* cursor c2 is
1090: SELECT 1
1091: FROM sys.dual
1092: where exists (SELECT NULL
1093: FROM pa_draft_invoice_items
1094: where project_id = x_proj_id
1095: AND TASK_ID IN
1096: (SELECT TASK_ID
1097: FROM PA_TASKS

Line 1108: FROM pa_draft_invoice_items

1104: cursor c3 is
1105: SELECT 1
1106: FROM sys.dual
1107: where exists (SELECT NULL
1108: FROM pa_draft_invoice_items
1109: where project_id = x_proj_id
1110: AND TASK_ID = x_TASK_ID);
1111: c3_rec c3%rowtype;
1112: begin