DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on FND_LOOKUPS

Line 502: FROM fnd_lookups

498: CURSOR c_get_lookup_values (p_trx_type VARCHAR2)
499: IS
500: SELECT meaning
501: ,description
502: FROM fnd_lookups
503: WHERE lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
504: AND lookup_code = p_trx_type;
505:
506: CURSOR c_company_details

Line 1101: from fnd_lookups

1097:
1098: --- Bug 12773668 ---
1099: select meaning
1100: into l_reporting_status_1
1101: from fnd_lookups
1102: where lookup_type = 'JGZZ_REPORT_TYPE'
1103: and lookup_code = decode(l_reporting_status, 'COPY', 'R','FINAL','F','P');
1104: --- End Bug 12773668 ---
1105:

Line 1996: FROM fnd_lookups

1992: FUNCTION get_prepayments_meaning RETURN VARCHAR2 IS
1993: CURSOR c_prepay_meaning
1994: IS
1995: SELECT meaning
1996: FROM fnd_lookups
1997: WHERE lookup_code = P_INC_PREPAYMENTS
1998: AND lookup_type = 'YES_NO';
1999:
2000: BEGIN