APPS.FUN_AP_TRANSFER dependencies on ZX_LINES_DET_FACTORS

Line 511: FROM zx_lines_det_factors zx,

507: zx.event_class_code,
508: zx.trx_id,
509: zx.trx_line_id,
510: zx.trx_level_type
511: FROM zx_lines_det_factors zx,
512: ra_customer_trx_all artrx
513: WHERE zx.trx_id = artrx.customer_trx_id
514: AND zx.application_id = 222
515: AND zx.entity_code = 'TRANSACTIONS'

Line 522: l_application_id zx_lines_det_factors.application_id%TYPE;

518: AND artrx.INTERFACE_HEADER_ATTRIBUTE2 = p_trx_id; -- bug no : 7718598
519:
520:
521: l_payment_method_lookup_code VARCHAR2(30);
522: l_application_id zx_lines_det_factors.application_id%TYPE;
523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;

Line 523: l_entity_code zx_lines_det_factors.entity_code%TYPE;

519:
520:
521: l_payment_method_lookup_code VARCHAR2(30);
522: l_application_id zx_lines_det_factors.application_id%TYPE;
523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;

Line 524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;

520:
521: l_payment_method_lookup_code VARCHAR2(30);
522: l_application_id zx_lines_det_factors.application_id%TYPE;
523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
528:

Line 525: l_trx_id zx_lines_det_factors.trx_id%TYPE;

521: l_payment_method_lookup_code VARCHAR2(30);
522: l_application_id zx_lines_det_factors.application_id%TYPE;
523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
528:
529: BEGIN

Line 526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;

522: l_application_id zx_lines_det_factors.application_id%TYPE;
523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
528:
529: BEGIN
530:

Line 527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;

523: l_entity_code zx_lines_det_factors.entity_code%TYPE;
524: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
525: l_trx_id zx_lines_det_factors.trx_id%TYPE;
526: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
527: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
528:
529: BEGIN
530:
531: -- Get etax info for AP to be able to calculate tax