APPS.PAY_US_NACHA_TAPE dependencies on FND_LOOKUP_VALUES

Line 1553: FROM fnd_lookup_types flt, fnd_lookup_values flv

1549: lr_batch_no csr_get_batch_no%ROWTYPE;
1550:
1551: CURSOR csr_get_conc_ident IS
1552: SELECT flv.meaning
1553: FROM fnd_lookup_types flt, fnd_lookup_values flv
1554: WHERE flt.lookup_type = 'PAYMENT_TRX_CONC_IDENTS'
1555: AND flt.application_id = (SELECT application_id FROM fnd_application
1556: WHERE application_short_name = 'PAY')
1557: AND flt.lookup_type = flv.lookup_type

Line 1570: TYPE lt_identifier_rec_type IS RECORD (ident_name fnd_lookup_values.meaning%TYPE,

1566: ln_org_id hr_organization_units.organization_id%TYPE := -1;
1567: ln_batch_number NUMBER(5) := 0;
1568: lv_return_value VARCHAR2(80) := NULL;
1569:
1570: TYPE lt_identifier_rec_type IS RECORD (ident_name fnd_lookup_values.meaning%TYPE,
1571: ident_position NUMBER);
1572: lt_identifier_rec lt_identifier_rec_type;
1573:
1574: TYPE lt_identifier_rec_table IS TABLE OF lt_identifier_rec_type INDEX BY BINARY_INTEGER;