APPS.JAI_AR_TRX_LINES_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 74: FROM RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

70: lv_service_type_code VARCHAR2(30);
71:
72: CURSOR transaction_type_cur IS
73: SELECT a.type
74: FROM RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
75: WHERE a.cust_trx_type_id = b.cust_trx_type_id
76: AND b.customer_trx_id = v_header_id
77: AND NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
78:

Line 581: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

577: WHERE CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
578:
579: Cursor transaction_type_cur IS
580: Select a.type
581: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
582: Where a.cust_trx_type_id = b.cust_trx_type_id
583: And b.customer_trx_id = v_header_id
584: And NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
585:

Line 1156: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1152: WHERE customer_trx_id = v_header_id;
1153:
1154: Cursor transaction_type_cur IS
1155: Select a.type
1156: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1157: Where a.cust_trx_type_id = b.cust_trx_type_id
1158: And b.customer_trx_id = v_header_id
1159: And (a.org_id = pr_new.org_id OR
1160: (a.org_id is null and pr_new.org_id is null));

Line 1509: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1505: WHERE customer_trx_id = v_header_id;
1506:
1507: Cursor transaction_type_cur IS
1508: Select a.type
1509: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1510: Where a.cust_trx_type_id = b.cust_trx_type_id
1511: And b.customer_trx_id = v_header_id
1512: And (a.org_id = pr_new.org_id OR
1513: (a.org_id is NULL AND pr_new.org_id is NULL));