DBA Data[Home] [Help]

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 544: , fnd_lookup_values TLOOKUP

540: FROM
541: jg_zz_vat_box_allocs AL
542: , jg_zz_vat_alloc_rules alr
543: , jg_zz_vat_trx_details JG
544: , fnd_lookup_values TLOOKUP
545: , fnd_lookup_values TBLLOOKUP
546: , jg_zz_vat_rep_status JZVRS
547: WHERE
548: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code

Line 545: , fnd_lookup_values TBLLOOKUP

541: jg_zz_vat_box_allocs AL
542: , jg_zz_vat_alloc_rules alr
543: , jg_zz_vat_trx_details JG
544: , fnd_lookup_values TLOOKUP
545: , fnd_lookup_values TBLLOOKUP
546: , jg_zz_vat_rep_status JZVRS
547: WHERE
548: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code
549: AND NVL(AL.tax_box, '99') = TLOOKUP.lookup_code -- brathod, Using AND condition instead of OR

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

586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
588: ,tax_box jg_zz_vat_box_allocs.tax_box%type
589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER

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

587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
588: ,tax_box jg_zz_vat_box_allocs.tax_box%type
589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type

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

607: (
608: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type