APPS.AP_APXTRSWP_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 373: FROM ap_invoice_distributions_all

369:
370: BEGIN
371: SELECT COUNT(*)
372: INTO cui_counter
373: FROM ap_invoice_distributions_all
374: WHERE accounting_date BETWEEN p_start_date AND p_end_date
375: AND accrual_posted_flag = 'N'
376: AND p_acct_method = 'A'
377: AND org_id = CO_org_id

Line 550: AP_INVOICE_DISTRIBUTIONS_ALL AID

546: SELECT DISTINCT PLL.LINE_LOCATION_ID,
547: PLL.CLOSED_DATE
548: FROM PO_LINE_LOCATIONS_ALL PLL,
549: PO_DISTRIBUTIONS_ALL PD,
550: AP_INVOICE_DISTRIBUTIONS_ALL AID
551: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
552: AND PLL.CLOSED_DATE IS NOT NULL
553: AND PD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID
554: AND AID.POSTED_FLAG = 'N'

Line 638: FROM ap_invoice_distributions_all aid

634: FUNCTION UPDATE_ACCTG_DATES RETURN BOOLEAN IS
635:
636: CURSOR DIST_ORGS IS
637: SELECT aid.invoice_id, aid.invoice_distribution_id
638: FROM ap_invoice_distributions_all aid
639: WHERE aid.accrual_posted_flag = 'N'
640: AND ((p_period_name is null and aid.accounting_date between p_from_acctg_date
641: and p_to_acctg_date)
642: OR (p_period_name is not null and aid.period_name = p_period_name))

Line 666: FROM ap_invoice_distributions_all aid,

662: and le.language = USERENV('LANG'));
663:
664: CURSOR DIST_ORG IS
665: SELECT aid.invoice_id, aid.invoice_distribution_id
666: FROM ap_invoice_distributions_all aid,
667: ap_system_parameters_all asp
668: WHERE aid.accrual_posted_flag = 'N'
669: AND asp.accounting_method_option = 'Accrual'
670: AND ((p_period_name is null and aid.accounting_date between p_from_acctg_date

Line 708: UPDATE ap_invoice_distributions_all aid

704: l_invoice_distribution_id;
705:
706: EXIT WHEN DIST_ORGS%NOTFOUND OR DIST_ORGS%NOTFOUND IS NULL;
707:
708: UPDATE ap_invoice_distributions_all aid
709: SET accounting_date = c_sweep_to_date,
710: period_name = p_to_period,
711: last_update_date = sysdate,
712: last_updated_by = 5

Line 829: UPDATE ap_invoice_distributions_all aid

825: l_invoice_distribution_id;
826:
827: EXIT WHEN DIST_ORG%NOTFOUND OR DIST_ORG%NOTFOUND IS NULL;
828:
829: UPDATE ap_invoice_distributions_all aid
830: SET accounting_date = c_sweep_to_date,
831: period_name = p_to_period,
832: last_update_date = sysdate,
833: last_updated_by = 5

Line 1059: FROM ap_invoice_distributions_all

1055: BEGIN
1056: IF p_sweep_now_1 = 'Y' OR p_unacct_rpt = 'Y' THEN RETURN(FALSE);
1057: ELSE SELECT COUNT(*)
1058: INTO cui_counter
1059: FROM ap_invoice_distributions_all
1060: WHERE accounting_date BETWEEN p_start_date AND p_end_date
1061: AND accrual_posted_flag = 'N'
1062: AND p_acct_method = 'A'
1063: AND org_id = CO_org_id

Line 1254: FROM ap_invoice_distributions_all

1250: BEGIN
1251: IF P_SWEEP_NOW_1 <> 'Y' then
1252: SELECT COUNT(*)
1253: INTO cui_counter
1254: FROM ap_invoice_distributions_all
1255: WHERE accounting_date BETWEEN p_start_date AND p_end_date
1256: AND accrual_posted_flag = 'N'
1257: AND p_acct_method = 'A'
1258: AND set_of_books_id = p_set_of_books_id