APPS.ARP_CREDIT_MEMO_MODULE dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2911: FROM ra_customer_trx_lines_all cmline,

2907: CURSOR lines (p_cm_line_id NUMBER) IS
2908: SELECT invline.accounting_rule_id,
2909: invline.rule_start_date,
2910: cmline.extended_amount line_amount
2911: FROM ra_customer_trx_lines_all cmline,
2912: ra_customer_trx_lines_all invline
2913: WHERE cmline.previous_customer_trx_line_id =
2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;

Line 2912: ra_customer_trx_lines_all invline

2908: SELECT invline.accounting_rule_id,
2909: invline.rule_start_date,
2910: cmline.extended_amount line_amount
2911: FROM ra_customer_trx_lines_all cmline,
2912: ra_customer_trx_lines_all invline
2913: WHERE cmline.previous_customer_trx_line_id =
2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:

Line 2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;

2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;

Line 2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;

2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:

Line 2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;

2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:
2924: BEGIN

Line 2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;

2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:
2924: BEGIN
2925: