APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MF_RCT_DIST_ALL

Line 1610: psa_mf_rct_dist_all psa_rct_dist,

1606: ra_customer_trx ctcm,
1607: ra_customer_trx ctinv,
1608: ra_cust_trx_types ctt,
1609: ar_cash_receipt_history crh,
1610: psa_mf_rct_dist_all psa_rct_dist,
1611: psa_mf_trx_dist_all psa_trx_dist,
1612: psa_lookup_codes l1
1613: WHERE
1614: psa_rct_dist.receivable_application_id = p_receivable_application_id

Line 1701: psa_mf_rct_dist_all psa_rct_dist,

1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,
1701: psa_mf_rct_dist_all psa_rct_dist,
1702: psa_mf_trx_dist_all psa_trx_dist,
1703: psa_lookup_codes l1
1704: WHERE
1705: psa_rct_dist.receivable_application_id = p_receivable_application_id

Line 1820: psa_mf_rct_dist_all psa_rct_dist,

1816: ra_customer_trx ctinv,
1817: ra_cust_trx_types ctt,
1818: ar_cash_receipt_history crhnew,
1819: ar_cash_receipt_history crhold,
1820: psa_mf_rct_dist_all psa_rct_dist,
1821: psa_mf_trx_dist_all psa_trx_dist,
1822: psa_lookup_codes l1
1823: WHERE
1824: psa_rct_dist.receivable_application_id = p_receivable_application_id

Line 2086: UPDATE psa_mf_rct_dist_all pda

2082:
2083: -- Bug 3671841, issuing a call to purge orphan distributions
2084: PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS;
2085:
2086: UPDATE psa_mf_rct_dist_all pda
2087: SET pda.posting_control_id = l_pst_ctrl_id
2088: WHERE pda.attribute1 = 'CLEARED'
2089: AND pda.receivable_application_id IN
2090: (SELECT receivable_application_id FROM ar_receivable_applications ara, ar_cash_receipt_history crh

Line 2096: ' UPDATE psa_mf_rct_dist_all '|| SQL%ROWCOUNT);

2092: AND crh.posting_control_id = l_pst_ctrl_id) ;
2093:
2094: -- ========================= FND LOG ===========================
2095: psa_utils.debug_other_string(g_state_level,l_full_path,
2096: ' UPDATE psa_mf_rct_dist_all '|| SQL%ROWCOUNT);
2097: -- ========================= FND LOG ===========================
2098:
2099: FOR I IN Cur_MFAR_rct_app_id
2100: LOOP

Line 2396: UPDATE psa_mf_rct_dist_all pda

2392:
2393: -- Bug 3671841, issuing a call to purge orphan distributions
2394: PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS;
2395:
2396: UPDATE psa_mf_rct_dist_all pda
2397: SET pda.posting_control_id = l_pst_ctrl_id
2398: WHERE pda.receivable_application_id IN
2399: (SELECT receivable_application_id FROM ar_receivable_applications ara
2400: WHERE ara.posting_control_id = l_pst_ctrl_id);

Line 2405: ' --> (PSA_MF_RCT_DIST_ALL) Posting control id updated for '

2401:
2402: IF (SQL%FOUND) THEN
2403: -- ========================= FND LOG ===========================
2404: psa_utils.debug_other_string(g_state_level,l_full_path,
2405: ' --> (PSA_MF_RCT_DIST_ALL) Posting control id updated for '
2406: || (SQL%ROWCOUNT) );
2407: -- ========================= FND LOG ===========================
2408: END IF;
2409: -- ========================= FND LOG ===========================

Line 3877: psa_mf_rct_dist_all psa_rct_dist,

3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
3875: ra_cust_trx_types ctt,
3876: ar_cash_receipt_history crh,
3877: psa_mf_rct_dist_all psa_rct_dist,
3878: psa_mf_trx_dist_all psa_trx_dist,
3879: ra_cust_trx_line_gl_dist ar_trx_dist,
3880: psa_lookup_codes l1
3881: WHERE

Line 4083: UPDATE psa_mf_rct_dist_all pda

4079:
4080: END LOOP;
4081: END LOOP;
4082:
4083: UPDATE psa_mf_rct_dist_all pda
4084: SET pda.posting_control_id = l_pst_ctrl_id
4085: WHERE pda.receivable_application_id IN
4086: (SELECT receivable_application_id
4087: FROM ar_receivable_applications ara