APPS.PA_RETENTION_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 703: FROM pa_agreements_all agr,pa_draft_invoices_all di

699: -- Select the Funding Currency
700:
701: SELECT agreement_currency_code
702: INTO FundingCurrency
703: FROM pa_agreements_all agr,pa_draft_invoices_all di
704: WHERE agr.agreement_id = di.agreement_id
705: AND di.project_id = p_project_id
706: AND di.draft_invoice_num = p_draft_invoice_num;
707:

Line 783: FROM pa_agreements_all agr,pa_draft_invoices_all di

779: -- Select the Funding Currency
780:
781: SELECT agreement_currency_code
782: INTO FundingCurrency
783: FROM pa_agreements_all agr,pa_draft_invoices_all di
784: WHERE agr.agreement_id = di.agreement_id
785: AND di.project_id = p_project_id
786: AND di.draft_invoice_num = p_draft_invoice_num;
787: */

Line 1595: FROM pa_draft_invoices_all di,

1591: */
1592: hz_cust_site_uses hz_site,
1593: hz_cust_site_uses hz_site1
1594: WHERE EXISTS (SELECT NULL
1595: FROM pa_draft_invoices_all di,
1596: pa_agreements_all agr, pa_proj_retn_rules rt
1597: WHERE di.project_id = p_project_id
1598: AND di.request_id = p_request_id
1599: AND di.agreement_id = agr.agreement_id

Line 1634: FROM pa_draft_invoices_all di, pa_agreements_all agr,

1630: di.draft_invoice_num,
1631: agr.agreement_id agreement_id,
1632: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1633: di.inv_currency_code invoice_currency_code
1634: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1635: pa_projects_all pr
1636: WHERE NVL(di.canceled_flag,'N') ='N'
1637: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1638: AND NVL(di.draft_invoice_num_credited,0) = 0

Line 2834: FROM pa_draft_invoices_all

2830:
2831: CURSOR cur_cm_invoice IS
2832: SELECT draft_invoice_num credit_invoice_num,
2833: draft_invoice_num_credited org_invoice_num
2834: FROM pa_draft_invoices_all
2835: WHERE project_id = p_project_id
2836: AND request_id = p_request_id
2837: AND draft_invoice_num_credited IS NOT NULL
2838: ORDER BY draft_invoice_num;

Line 2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2958: di.agreement_id agreement_id,
2959: agr.customer_id customer_id,
2960: rtn.task_id rtn_task_id,
2961: dii.line_num line_num_credited
2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2963: pa_agreements_all agr,
2964: pa_proj_retn_rules rtn
2965: WHERE dii.project_id = p_project_id
2966: AND dii.draft_invoice_num = l_org_invoice_num

Line 3005: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3001: di.agreement_id agreement_id,
3002: agr.customer_id customer_id,
3003: dii.retention_rule_id rtn_task_id, -- To get the retention lines
3004: dii.line_num line_num_credited
3005: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3006: pa_agreements_all agr
3007: WHERE dii.project_id = p_project_id
3008: AND dii.draft_invoice_num = l_org_invoice_num
3009: AND dii.project_id = di.project_id

Line 3199: FROM pa_draft_invoices_all p

3195: -- Get the new draft invoice num
3196:
3197: SELECT NVL( MAX(p.draft_invoice_num) + 1, 1)
3198: INTO TmpInvoiceNum
3199: FROM pa_draft_invoices_all p
3200: WHERE p.project_id = p_project_id;
3201:
3202: IF g1_debug_mode = 'Y' THEN
3203: pa_retention_util.write_log('Invoice_Cancel_Action: ' || 'New Invoice Num : ' || TmpInvoiceNum);

Line 3207: INSERT INTO pa_draft_invoices_all

3203: pa_retention_util.write_log('Invoice_Cancel_Action: ' || 'New Invoice Num : ' || TmpInvoiceNum);
3204: END IF;
3205:
3206: -- Copy the Header as it is
3207: INSERT INTO pa_draft_invoices_all
3208: (
3209: PROJECT_ID ,
3210: DRAFT_INVOICE_NUM ,
3211: LAST_UPDATE_DATE ,

Line 3335: FROM pa_draft_invoices_all di

3331: di.ship_to_customer_id,
3332: di.bill_to_contact_id,
3333: di.ship_to_contact_id /*last 3 columns added for
3334: customer account relation enhancement*/
3335: FROM pa_draft_invoices_all di
3336: WHERE di.project_id = p_project_id
3337: AND di.draft_invoice_num = p_draft_invoice_num;
3338:
3339: FOR InvoiceLines IN (SELECT dii.line_num line_Num ,

Line 3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3367: di.agreement_id agreement_id,
3368: agr.customer_id customer_id,
3369: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3370: dii.inv_amount inv_amount
3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3372: pa_agreements_all agr,
3373: pa_proj_retn_rules rtn
3374: WHERE di.project_id = p_project_id
3375: AND di.draft_invoice_num = p_draft_invoice_num

Line 3495: pa_draft_invoices_all di,

3491: di.agreement_id agreement_id,
3492: agr.customer_id customer_id,
3493: rtn.task_id rtn_task_id
3494: FROM pa_draft_invoice_items dii,
3495: pa_draft_invoices_all di,
3496: pa_agreements_all agr,
3497: pa_proj_retn_rules rtn
3498: WHERE di.project_id = p_project_id
3499: AND di.draft_invoice_num = p_draft_invoice_num

Line 3578: pa_draft_invoices_all di,

3574: di.agreement_id agreement_id,
3575: agr.customer_id customer_id,
3576: NVL(rtn.task_id,dii.task_id) rtn_task_id
3577: FROM pa_draft_invoice_items dii,
3578: pa_draft_invoices_all di,
3579: pa_agreements_all agr,
3580: pa_proj_retn_rules rtn
3581: WHERE di.project_id = p_project_id
3582: AND di.draft_invoice_num = p_draft_invoice_num

Line 3685: pa_draft_invoices_all di,

3681: di.agreement_id agreement_id,
3682: agr.customer_id customer_id,
3683: rtn.task_id rtn_task_id
3684: FROM pa_draft_invoice_items dii,
3685: pa_draft_invoices_all di,
3686: pa_agreements_all agr,
3687: pa_proj_retn_rules rtn
3688: WHERE di.project_id = p_project_id
3689: AND di.draft_invoice_num = p_draft_invoice_num

Line 3735: pa_draft_invoices_all di,

3731: di.agreement_id agreement_id,
3732: agr.customer_id customer_id,
3733: dii.task_id dii_task_id
3734: FROM pa_draft_invoice_items dii,
3735: pa_draft_invoices_all di,
3736: pa_agreements_all agr
3737: WHERE di.project_id = p_project_id
3738: AND di.draft_invoice_num = p_draft_invoice_num
3739: AND di.agreement_id = agr.agreement_id