APPS.PA_RETENTION_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 685: FROM pa_agreements_all agr,pa_draft_invoices_all di

681: -- Select the Funding Currency
682:
683: SELECT agreement_currency_code
684: INTO FundingCurrency
685: FROM pa_agreements_all agr,pa_draft_invoices_all di
686: WHERE agr.agreement_id = di.agreement_id
687: AND di.project_id = p_project_id
688: AND di.draft_invoice_num = p_draft_invoice_num;
689:

Line 765: FROM pa_agreements_all agr,pa_draft_invoices_all di

761: -- Select the Funding Currency
762:
763: SELECT agreement_currency_code
764: INTO FundingCurrency
765: FROM pa_agreements_all agr,pa_draft_invoices_all di
766: WHERE agr.agreement_id = di.agreement_id
767: AND di.project_id = p_project_id
768: AND di.draft_invoice_num = p_draft_invoice_num;
769: */

Line 1577: FROM pa_draft_invoices_all di,

1573: */
1574: hz_cust_site_uses hz_site,
1575: hz_cust_site_uses hz_site1
1576: WHERE EXISTS (SELECT NULL
1577: FROM pa_draft_invoices_all di,
1578: pa_agreements_all agr, pa_proj_retn_rules rt
1579: WHERE di.project_id = p_project_id
1580: AND di.request_id = p_request_id
1581: AND di.agreement_id = agr.agreement_id

Line 1616: FROM pa_draft_invoices_all di, pa_agreements_all agr,

1612: di.draft_invoice_num,
1613: agr.agreement_id agreement_id,
1614: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1615: di.inv_currency_code invoice_currency_code
1616: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1617: pa_projects_all pr
1618: WHERE NVL(di.canceled_flag,'N') ='N'
1619: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1620: AND NVL(di.draft_invoice_num_credited,0) = 0

Line 2797: FROM pa_draft_invoices_all

2793:
2794: CURSOR cur_cm_invoice IS
2795: SELECT draft_invoice_num credit_invoice_num,
2796: draft_invoice_num_credited org_invoice_num
2797: FROM pa_draft_invoices_all
2798: WHERE project_id = p_project_id
2799: AND request_id = p_request_id
2800: AND draft_invoice_num_credited IS NOT NULL
2801: ORDER BY draft_invoice_num;

Line 2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2921: di.agreement_id agreement_id,
2922: agr.customer_id customer_id,
2923: rtn.task_id rtn_task_id,
2924: dii.line_num line_num_credited
2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2926: pa_agreements_all agr,
2927: pa_proj_retn_rules rtn
2928: WHERE dii.project_id = p_project_id
2929: AND dii.draft_invoice_num = l_org_invoice_num

Line 2968: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2964: di.agreement_id agreement_id,
2965: agr.customer_id customer_id,
2966: dii.retention_rule_id rtn_task_id, -- To get the retention lines
2967: dii.line_num line_num_credited
2968: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2969: pa_agreements_all agr
2970: WHERE dii.project_id = p_project_id
2971: AND dii.draft_invoice_num = l_org_invoice_num
2972: AND dii.project_id = di.project_id

Line 3162: FROM pa_draft_invoices_all p

3158: -- Get the new draft invoice num
3159:
3160: SELECT NVL( MAX(p.draft_invoice_num) + 1, 1)
3161: INTO TmpInvoiceNum
3162: FROM pa_draft_invoices_all p
3163: WHERE p.project_id = p_project_id;
3164:
3165: IF g1_debug_mode = 'Y' THEN
3166: pa_retention_util.write_log('Invoice_Cancel_Action: ' || 'New Invoice Num : ' || TmpInvoiceNum);

Line 3170: INSERT INTO pa_draft_invoices_all

3166: pa_retention_util.write_log('Invoice_Cancel_Action: ' || 'New Invoice Num : ' || TmpInvoiceNum);
3167: END IF;
3168:
3169: -- Copy the Header as it is
3170: INSERT INTO pa_draft_invoices_all
3171: (
3172: PROJECT_ID ,
3173: DRAFT_INVOICE_NUM ,
3174: LAST_UPDATE_DATE ,

Line 3298: FROM pa_draft_invoices_all di

3294: di.ship_to_customer_id,
3295: di.bill_to_contact_id,
3296: di.ship_to_contact_id /*last 3 columns added for
3297: customer account relation enhancement*/
3298: FROM pa_draft_invoices_all di
3299: WHERE di.project_id = p_project_id
3300: AND di.draft_invoice_num = p_draft_invoice_num;
3301:
3302: FOR InvoiceLines IN (SELECT dii.line_num line_Num ,

Line 3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3330: di.agreement_id agreement_id,
3331: agr.customer_id customer_id,
3332: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3333: dii.inv_amount inv_amount
3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3335: pa_agreements_all agr,
3336: pa_proj_retn_rules rtn
3337: WHERE di.project_id = p_project_id
3338: AND di.draft_invoice_num = p_draft_invoice_num

Line 3458: pa_draft_invoices_all di,

3454: di.agreement_id agreement_id,
3455: agr.customer_id customer_id,
3456: rtn.task_id rtn_task_id
3457: FROM pa_draft_invoice_items dii,
3458: pa_draft_invoices_all di,
3459: pa_agreements_all agr,
3460: pa_proj_retn_rules rtn
3461: WHERE di.project_id = p_project_id
3462: AND di.draft_invoice_num = p_draft_invoice_num

Line 3541: pa_draft_invoices_all di,

3537: di.agreement_id agreement_id,
3538: agr.customer_id customer_id,
3539: NVL(rtn.task_id,dii.task_id) rtn_task_id
3540: FROM pa_draft_invoice_items dii,
3541: pa_draft_invoices_all di,
3542: pa_agreements_all agr,
3543: pa_proj_retn_rules rtn
3544: WHERE di.project_id = p_project_id
3545: AND di.draft_invoice_num = p_draft_invoice_num

Line 3648: pa_draft_invoices_all di,

3644: di.agreement_id agreement_id,
3645: agr.customer_id customer_id,
3646: rtn.task_id rtn_task_id
3647: FROM pa_draft_invoice_items dii,
3648: pa_draft_invoices_all di,
3649: pa_agreements_all agr,
3650: pa_proj_retn_rules rtn
3651: WHERE di.project_id = p_project_id
3652: AND di.draft_invoice_num = p_draft_invoice_num

Line 3698: pa_draft_invoices_all di,

3694: di.agreement_id agreement_id,
3695: agr.customer_id customer_id,
3696: dii.task_id dii_task_id
3697: FROM pa_draft_invoice_items dii,
3698: pa_draft_invoices_all di,
3699: pa_agreements_all agr
3700: WHERE di.project_id = p_project_id
3701: AND di.draft_invoice_num = p_draft_invoice_num
3702: AND di.agreement_id = agr.agreement_id