APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MISC_POSTING

Line 421: (SELECT cash_receipt_history_id FROM psa_misc_posting);

417: IS
418: SELECT cash_receipt_history_id FROM ar_cash_receipt_history
419: WHERE posting_control_id = l_pst_ctrl_id
420: AND cash_receipt_history_id NOT IN
421: (SELECT cash_receipt_history_id FROM psa_misc_posting);
422:
423: CURSOR c_create_dist
424: IS
425: SELECT cr.cash_receipt_id FROM ar_cash_receipts cr, ar_cash_receipt_history crh

Line 942: ## Insert a record into psa_misc_posting to keep track of

938:
939: END LOOP;
940:
941: /*
942: ## Insert a record into psa_misc_posting to keep track of
943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
944: */
945:
946: -- ========================= FND LOG ===========================

Line 948: ' --> Inserting into psa_misc_posting ');

944: */
945:
946: -- ========================= FND LOG ===========================
947: psa_utils.debug_other_string(g_state_level,l_full_path,
948: ' --> Inserting into psa_misc_posting ');
949: -- ========================= FND LOG ===========================
950:
951: FOR J IN c_crh_post
952: LOOP

Line 954: INSERT INTO psa_misc_posting (cash_receipt_history_id, posting_control_id)

950:
951: FOR J IN c_crh_post
952: LOOP
953:
954: INSERT INTO psa_misc_posting (cash_receipt_history_id, posting_control_id)
955: VALUES (J.cash_receipt_history_id, l_pst_ctrl_id);
956:
957: -- ========================= FND LOG ===========================
958: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);

4116: IS
4117: SELECT cash_receipt_history_id FROM ar_cash_receipt_history_all
4118: WHERE posting_control_id = l_pst_ctrl_id
4119: AND cash_receipt_history_id NOT IN
4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:
4122: CURSOR c_create_dist
4123: IS
4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh

Line 4320: ## Insert a record into psa_misc_posting to keep track of

4316:
4317: END LOOP;
4318:
4319: /*
4320: ## Insert a record into psa_misc_posting to keep track of
4321: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
4322: */
4323:
4324: FOR J IN c_crh_post

Line 4326: INSERT INTO psa_misc_posting (cash_receipt_history_id, posting_control_id)

4322: */
4323:
4324: FOR J IN c_crh_post
4325: LOOP
4326: INSERT INTO psa_misc_posting (cash_receipt_history_id, posting_control_id)
4327: VALUES (J.cash_receipt_history_id, l_pst_ctrl_id);
4328:
4329: END LOOP;
4330: