978: l_c_cash_stmt := l_c_cash_stmt || ' order by 5 asc ';
979: END IF;
980:
981: -- ========================= FND LOG ===========================
982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
983: || arp_global.sysparam.accounting_method);
984: -- ========================= FND LOG ===========================
985:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
979: END IF;
980:
981: -- ========================= FND LOG ===========================
982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
983: || arp_global.sysparam.accounting_method);
984: -- ========================= FND LOG ===========================
985:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
987: OPEN c_accrual_cur FOR l_c_accrual_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
982: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
983: || arp_global.sysparam.accounting_method);
984: -- ========================= FND LOG ===========================
985:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
987: OPEN c_accrual_cur FOR l_c_accrual_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
988: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN
989: OPEN c_accrual_cur FOR l_c_cash_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
990: END IF;
984: -- ========================= FND LOG ===========================
985:
986: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
987: OPEN c_accrual_cur FOR l_c_accrual_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
988: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN
989: OPEN c_accrual_cur FOR l_c_cash_stmt USING l_zero_amt_flag, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
990: END IF;
991:
992:
1612: l_c_cash_stmt := l_c_cash_stmt || ' order by 6,5 asc ';
1613: END IF;
1614:
1615: -- ========================= FND LOG ===========================
1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
1617: || arp_global.sysparam.accounting_method);
1618: -- ========================= FND LOG ===========================
1619:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
1613: END IF;
1614:
1615: -- ========================= FND LOG ===========================
1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
1617: || arp_global.sysparam.accounting_method);
1618: -- ========================= FND LOG ===========================
1619:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
1621: OPEN c_accrual_cur FOR l_c_accrual_stmt
1616: psa_utils.debug_other_string(g_state_level,l_full_path,' arp_global.sysparam.accounting_method --> '
1617: || arp_global.sysparam.accounting_method);
1618: -- ========================= FND LOG ===========================
1619:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
1621: OPEN c_accrual_cur FOR l_c_accrual_stmt
1622: USING sum_amt_due_rem, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
1623: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN
1624: OPEN c_accrual_cur FOR l_c_cash_stmt
1619:
1620: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
1621: OPEN c_accrual_cur FOR l_c_accrual_stmt
1622: USING sum_amt_due_rem, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
1623: ELSIF arp_global.sysparam.accounting_method = 'CASH' THEN
1624: OPEN c_accrual_cur FOR l_c_cash_stmt
1625: USING sum_amt_due_rem, p_cust_trx_id, p_cust_trx_id, p_cust_trx_line_id;
1626: END IF;
1627: