eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_AUDIT_GL_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;

57: l_contact hz_parties.party_name%TYPE;
58: l_phone_number hz_contact_points.phone_number%TYPE;
59: l_period_year NUMBER;
60:
61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;
62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;

Line 62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;

58: l_phone_number hz_contact_points.phone_number%TYPE;
59: l_period_year NUMBER;
60:
61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;
62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;
66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;

Line 63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;

59: l_period_year NUMBER;
60:
61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;
62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;
66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;
67: -- Added for Glob-006 ER

Line 64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;

60:
61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;
62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;
66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;
67: -- Added for Glob-006 ER
68: l_province VARCHAR2(120);

Line 65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;

61: l_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%TYPE;
62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;
66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;
67: -- Added for Glob-006 ER
68: l_province VARCHAR2(120);
69: l_comm_num VARCHAR2(30);

Line 66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;

62: l_enable_register_flag jg_zz_vat_rep_entities.enable_registers_flag%TYPE;
63: l_enable_report_seq_flag jg_zz_vat_rep_entities.enable_report_sequence_flag%TYPE;
64: l_enable_alloc_flag jg_zz_vat_rep_entities.enable_allocations_flag%TYPE;
65: l_enable_annual_alloc_flag jg_zz_vat_rep_entities.enable_annual_allocation_flag%TYPE;
66: l_threshold_amt jg_zz_vat_rep_entities.threshold_amount%TYPE;
67: -- Added for Glob-006 ER
68: l_province VARCHAR2(120);
69: l_comm_num VARCHAR2(30);
70: l_vat_reg_num VARCHAR2(50);

Line 77: FROM jg_zz_vat_rep_entities cfg,

73:
74: CURSOR c_get_ledger_id
75: IS
76: SELECT NVL(cfg.ledger_id,glp.ledger_id)
77: FROM jg_zz_vat_rep_entities cfg,
78: jg_zz_vat_rep_entities cfgd,
79: gl_ledger_le_v glp
80: WHERE cfg.vat_reporting_entity_id = 10001
81: AND ( ( cfg.entity_type_code = 'ACCOUNTING'

Line 78: jg_zz_vat_rep_entities cfgd,

74: CURSOR c_get_ledger_id
75: IS
76: SELECT NVL(cfg.ledger_id,glp.ledger_id)
77: FROM jg_zz_vat_rep_entities cfg,
78: jg_zz_vat_rep_entities cfgd,
79: gl_ledger_le_v glp
80: WHERE cfg.vat_reporting_entity_id = 10001
81: AND ( ( cfg.entity_type_code = 'ACCOUNTING'
82: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id