APPS.FUN_RECIPIENT_WF dependencies on FUN_TRX_LINES

Line 54: FROM fun_trx_lines

50:
51: DELETE FROM fun_dist_lines
52: WHERE line_id IN
53: ( SELECT line_id
54: FROM fun_trx_lines
55: WHERE trx_id = p_trx_id );
56:
57: DELETE FROM fun_trx_lines
58: WHERE trx_id = p_trx_id;

Line 57: DELETE FROM fun_trx_lines

53: ( SELECT line_id
54: FROM fun_trx_lines
55: WHERE trx_id = p_trx_id );
56:
57: DELETE FROM fun_trx_lines
58: WHERE trx_id = p_trx_id;
59:
60: DELETE FROM fun_trx_headers
61: WHERE trx_id = p_trx_id;

Line 150: FROM fun_dist_lines d, fun_trx_lines l

146: CURSOR c_dist IS
147: SELECT d.dist_id, d.line_id, d.party_id,
148: d.party_type_flag, d.dist_type_flag, d.batch_dist_id,
149: d.amount_cr, d.amount_dr, d.ccid
150: FROM fun_dist_lines d, fun_trx_lines l
151: WHERE party_type_flag = 'R' AND
152: d.line_id = l.line_id AND
153: l.trx_id = p_trx_id;
154: i number := 1;

Line 2029: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h

2025: h.RECIPIENT_ID,
2026: dl.amount_dr,
2027: dl.amount_cr
2028: --FUN_TRX_ENTRY_UTIL.GET_DEFAULT_CCID(l_to_le_id, l_from_le_id, 'P') CCID
2029: FROM fun_dist_lines dl, fun_trx_lines l, fun_trx_headers h
2030: WHERE l.trx_id = l_trx_id
2031: AND dl.trx_id = h.trx_id
2032: AND dl.line_id = l.line_id
2033: AND dl.party_type_flag = 'I'