APPS.ARP_CREDIT_MEMO_MODULE dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2314: RA_CUSTOMER_TRX_LINES_ALL CTL,

2310:
2311: SELECT SUM(LGD.AMOUNT), MAX(SUBSTR(NVL(RR.TYPE, 'N'), 1, 1))
2312: INTO l_rev_count, l_rule_type
2313: FROM RA_CUST_TRX_LINE_GL_DIST LGD,
2314: RA_CUSTOMER_TRX_LINES_ALL CTL,
2315: RA_RULES RR
2316: WHERE LGD.CUSTOMER_TRX_LINE_ID = p_prev_cust_trx_line_id
2317: AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID
2318: AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)

Line 2996: FROM ra_customer_trx_lines_all cmline,

2992: CURSOR lines (p_cm_line_id NUMBER) IS
2993: SELECT invline.accounting_rule_id,
2994: invline.rule_start_date,
2995: cmline.extended_amount line_amount
2996: FROM ra_customer_trx_lines_all cmline,
2997: ra_customer_trx_lines_all invline
2998: WHERE cmline.previous_customer_trx_line_id =
2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;

Line 2997: ra_customer_trx_lines_all invline

2993: SELECT invline.accounting_rule_id,
2994: invline.rule_start_date,
2995: cmline.extended_amount line_amount
2996: FROM ra_customer_trx_lines_all cmline,
2997: ra_customer_trx_lines_all invline
2998: WHERE cmline.previous_customer_trx_line_id =
2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:

Line 3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;

2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;

Line 3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;

3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:

Line 3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;

3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:
3009: BEGIN

Line 3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;

3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:
3009: BEGIN
3010: