DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_REP_FINAL_REPORTING dependencies on GL_PERIODS

Line 32: pv_tax_calendar_period in gl_periods.period_name%type,

28: (
29: xv_errbuf out nocopy varchar2, /* out parameter for concurrent program */
30: xv_retcode out nocopy varchar2, /* out parameter for concurrent program */
31: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
32: pv_tax_calendar_period in gl_periods.period_name%type,
33: pv_source in varchar2
34: )
35: is
36:

Line 102: ,gl_periods glp

98: AND RPS.period_start_date >
99: NVL((SELECT glp.end_date
100: FROM jg_zz_vat_rep_entities legal
101: ,jg_zz_vat_rep_entities acct
102: ,gl_periods glp
103: WHERE acct.entity_type_code='ACCOUNTING'
104: AND acct.vat_reporting_entity_id = pn_vat_reporting_entity_id
105: AND acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id
106: AND glp.period_set_name = legal.tax_calendar_name