APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_LOOKUP_VALUES

Line 114: -- In the query used the column "language" instead of "source_lang" for the table "fnd_lookup_values"

110: -- 120.26 20-DEC-2006 RJREDDY Bug 5718147: Changed the c_belgian_vat cursor query in JEBEVA06 procedure,
111: -- so that the Tax and Taxable amounts for the transactions will be multiplied with
112: -- -1 or 1 when the allocated Box sign is -ve or +ve respectively.
113: -- 120.27 24-JUL-2007 ASHDAS Bug 6189243: Changed the query "c_belgian_vat" in the procedure "jebeva06".
114: -- In the query used the column "language" instead of "source_lang" for the table "fnd_lookup_values"
115: -- 120.28 27-AUG-2008 ASHDAS Bug 7344931 Changed the c_belgian_vat and instead of Transaction date now GL_date is fetched.
116: -- 120.35 29-JAN-2009 RAHULKUM Bug 7633948 Modified the JEITPSSR_AMOUNT_TO_PAY and added a new function JEITPSSR_AMOUNT_TO_PAY_UPDATE.
117: -- 120.36 10-FEB-2009 RAHULKUM BUG:8237932 Modified the JEITPSSR_AMOUNT_TO_PAY.Added NVL function to CARRY_OVER.Replicating the changes of bug 7380506.
118: -- 120.37 16-FEB-2009 RAHULKUM BUG:8237932 Modified the JEITPSSR_AMOUNT_TO_PAY.Revertback the changes done for replicating the changes of bug 7380506.

Line 727: , fnd_lookup_values TLOOKUP

723: FROM
724: jg_zz_vat_box_allocs AL
725: , jg_zz_vat_alloc_rules alr
726: , jg_zz_vat_trx_details JG
727: , fnd_lookup_values TLOOKUP
728: , fnd_lookup_values TBLLOOKUP
729: , Jg_Zz_Vat_Rep_Status Jzvrs
730: , ZX_lines zx
731: WHERE

Line 728: , fnd_lookup_values TBLLOOKUP

724: jg_zz_vat_box_allocs AL
725: , jg_zz_vat_alloc_rules alr
726: , jg_zz_vat_trx_details JG
727: , fnd_lookup_values TLOOKUP
728: , fnd_lookup_values TBLLOOKUP
729: , Jg_Zz_Vat_Rep_Status Jzvrs
730: , ZX_lines zx
731: WHERE
732: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code

Line 784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)

780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
782: ,tax_box jg_zz_vat_box_allocs.tax_box%type
783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER

Line 785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)

781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
782: ,tax_box jg_zz_vat_box_allocs.tax_box%type
783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type

Line 812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)

808: (
809: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type