eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MF_MISC_DIST_ALL

Line 461: 'PSA_MF_MISC_DIST_ALL' ref30

457: NULL ref26,
458: 'c1' ref27,
459: 'MISC' ref28,
460: 'MISC_' || ard.source_type ref29,
461: 'PSA_MF_MISC_DIST_ALL' ref30
462: FROM
463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,

Line 463: psa_mf_misc_dist_all mfd,

459: 'MISC' ref28,
460: 'MISC_' || ard.source_type ref29,
461: 'PSA_MF_MISC_DIST_ALL' ref30
462: FROM
463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,

Line 579: 'PSA_MF_MISC_DIST_ALL' ref30

575: 'TRADE') ref28,
576: DECODE( cr.type,
577: 'MISC', 'MISC_',
578: 'TRADE_') ref29,
579: 'PSA_MF_MISC_DIST_ALL' ref30
580: FROM
581: psa_mf_misc_dist_all mfd,
582: psa_lookup_codes l1,
583: ar_misc_cash_distributions mcd,

Line 581: psa_mf_misc_dist_all mfd,

577: 'MISC', 'MISC_',
578: 'TRADE_') ref29,
579: 'PSA_MF_MISC_DIST_ALL' ref30
580: FROM
581: psa_mf_misc_dist_all mfd,
582: psa_lookup_codes l1,
583: ar_misc_cash_distributions mcd,
584: ar_cash_receipts cr,
585: ar_cash_receipt_history crh,

Line 702: ' --> Inserting into GL INTERFACE foor - PSA_MF_MISC_DIST_ALL');

698: END;
699:
700: -- ========================= FND LOG ===========================
701: psa_utils.debug_other_string(g_state_level,l_full_path,
702: ' --> Inserting into GL INTERFACE foor - PSA_MF_MISC_DIST_ALL');
703: -- ========================= FND LOG ===========================
704:
705: FOR J IN Cur_MFAR_mrct_lines
706: LOOP

Line 964: UPDATE psa_mf_misc_dist_all

960: -- ========================= FND LOG ===========================
961:
962: END LOOP;
963:
964: UPDATE psa_mf_misc_dist_all
965: SET posting_control_id = l_pst_ctrl_id
966: WHERE misc_cash_distribution_id IN
967: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions
968: WHERE posting_control_id = l_pst_ctrl_id);

Line 973: ' --> (PSA_MF_MISC_DIST_ALL) Updated Posting control id for '

969:
970: IF (SQL%FOUND) THEN
971: -- ====================== FND LOG ==========================
972: psa_utils.debug_other_string(g_state_level,l_full_path,
973: ' --> (PSA_MF_MISC_DIST_ALL) Updated Posting control id for '
974: || (SQL%ROWCOUNT));
975: -- ====================== FND LOG ==========================
976: END IF;
977:

Line 979: -- delete all such records in psa_mf_misc_dist_all that

975: -- ====================== FND LOG ==========================
976: END IF;
977:
978: -- Bug3967158
979: -- delete all such records in psa_mf_misc_dist_all that
980: -- do not have the matching records on core distributions
981:
982: DELETE FROM psa_mf_misc_dist_all
983: WHERE posting_control_id = l_pst_ctrl_id

Line 982: DELETE FROM psa_mf_misc_dist_all

978: -- Bug3967158
979: -- delete all such records in psa_mf_misc_dist_all that
980: -- do not have the matching records on core distributions
981:
982: DELETE FROM psa_mf_misc_dist_all
983: WHERE posting_control_id = l_pst_ctrl_id
984: AND misc_cash_distribution_id NOT IN
985: (SELECT misc_cash_distribution_id
986: FROM ar_misc_cash_distributions

Line 992: ' --> (PSA_MF_MISC_DIST_ALL) Deleted --> '

988:
989: IF (SQL%FOUND) THEN
990: -- ====================== FND LOG ==========================
991: psa_utils.debug_other_string(g_state_level,l_full_path,
992: ' --> (PSA_MF_MISC_DIST_ALL) Deleted --> '
993: || (SQL%ROWCOUNT));
994: -- ====================== FND LOG ==========================
995: END IF;
996:

Line 4156: 'PSA_MF_MISC_DIST_ALL' ref30

4152: NULL ref26,
4153: 'c1' ref27,
4154: 'MISC' ref28,
4155: 'MISC_' || ard.source_type ref29,
4156: 'PSA_MF_MISC_DIST_ALL' ref30
4157: FROM
4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,

Line 4158: psa_mf_misc_dist_all mfd,

4154: 'MISC' ref28,
4155: 'MISC_' || ard.source_type ref29,
4156: 'PSA_MF_MISC_DIST_ALL' ref30
4157: FROM
4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,
4161: ar_distributions_all ard,
4162: ar_cash_receipts_all cr,

Line 4247: ## Insert into GL_INTERFACE Select from psa_mf_misc_dist_all

4243:
4244: END;
4245:
4246: /*
4247: ## Insert into GL_INTERFACE Select from psa_mf_misc_dist_all
4248: */
4249:
4250: FOR J IN Cur_MFAR_mrct_lines
4251: LOOP

Line 4331: UPDATE psa_mf_misc_dist_all

4327: VALUES (J.cash_receipt_history_id, l_pst_ctrl_id);
4328:
4329: END LOOP;
4330:
4331: UPDATE psa_mf_misc_dist_all
4332: SET posting_control_id = l_pst_ctrl_id
4333: WHERE misc_cash_distribution_id IN
4334: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions_all
4335: WHERE posting_control_id = l_pst_ctrl_id);