APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MFAR_VAL_PKG

Line 1050: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ctlgd.customer_trx_id, 'TRX', l_sob_id),

1046: -- Added UNION clauses to select transactions associated with receipts and adjustments
1047: SELECT ctlgd.customer_trx_id customer_trx_id
1048: FROM ra_cust_trx_line_gl_dist ctlgd
1049: WHERE ctlgd.posting_control_id = l_pst_ctrl_id
1050: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ctlgd.customer_trx_id, 'TRX', l_sob_id),
1051: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1052: UNION
1053: SELECT customer_trx_id
1054: FROM ar_adjustments adj

Line 1056: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id),

1052: UNION
1053: SELECT customer_trx_id
1054: FROM ar_adjustments adj
1055: WHERE adj.posting_control_id = l_pst_ctrl_id
1056: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id),
1057: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1058: AND arp_global.sysparam.accounting_method = 'ACCRUAL'
1059: UNION
1060: SELECT applied_customer_trx_id

Line 1064: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ra.receivable_application_id, 'RCT', l_sob_id),

1060: SELECT applied_customer_trx_id
1061: FROM ar_receivable_applications ra
1062: WHERE ra.status = 'APP'
1063: AND ra.posting_control_id = l_pst_ctrl_id
1064: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ra.receivable_application_id, 'RCT', l_sob_id),
1065: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1066: UNION
1067: SELECT ra.applied_customer_trx_id
1068: FROM ar_receivable_applications ra,

Line 1074: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ra.receivable_application_id, 'RCT', l_sob_id),

1070: ar_cash_receipt_history crho
1071: WHERE crh.posting_control_id = l_pst_ctrl_id
1072: AND crh.cash_receipt_history_id = crho.reversal_cash_receipt_hist_id
1073: AND crh.cash_receipt_id = ra.cash_receipt_id
1074: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ra.receivable_application_id, 'RCT', l_sob_id),
1075: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1076: AND ra.status = 'APP';
1077: -- Bug 3757993 .. End
1078:

Line 1450: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check

1446: SELECT distinct ra.receivable_application_id receivable_application_id
1447: FROM ar_receivable_applications ra
1448: WHERE ra.status = 'APP'
1449: AND ra.posting_control_id = l_pst_ctrl_id
1450: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check
1451: (ra.receivable_application_id, 'RCT', l_sob_id) , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE';
1452:
1453: -- selects app_id if original cash receipt status had been reversed.
1454: CURSOR Cur_Clr_MFAR_rct_app_id

Line 1461: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check

1457: FROM ar_receivable_applications ra, ar_cash_receipt_history crh, ar_cash_receipt_history crho
1458: WHERE crh.posting_control_id = l_pst_ctrl_id
1459: AND crh.cash_receipt_history_id = crho.reversal_cash_receipt_hist_id
1460: AND crh.cash_receipt_id = ra.cash_receipt_id
1461: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check
1462: (ra.receivable_application_id, 'RCT', p_set_of_books_id) , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1463: AND ra.status = 'APP';
1464:
1465: --

Line 2457: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id)

2453: IS
2454: SELECT distinct adj.adjustment_id adjustment_id
2455: FROM ar_adjustments adj
2456: WHERE adj.posting_control_id = l_pst_ctrl_id
2457: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id)
2458: , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE';
2459:
2460: -- Bug 2982757
2461: -- Modified cursor to fetch adjustment ccid from ar_distributions

Line 3784: AND DECODE(PSA_MFAR_VAL_PKG.ar_mfar_validate_check

3780: SELECT distinct ra.receivable_application_id receivable_application_id
3781: FROM ar_receivable_applications ra
3782: WHERE ra.status = 'APP'
3783: AND ra.posting_control_id = l_pst_ctrl_id
3784: AND DECODE(PSA_MFAR_VAL_PKG.ar_mfar_validate_check
3785: (ra.receivable_application_id, 'RCT', l_sob_id) , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE';
3786:
3787: CURSOR Cur_mfar_rct_lines (p_receivable_application_id NUMBER)
3788: IS