APPS.JG_ZZ_VAT_REP_UTILITY dependencies on JG_ZZ_VAT_FINAL_REPORTS

Line 981: from jg_zz_vat_final_reports fin,jg_zz_vat_rep_status rep

977: /* check if final rep has been done before */
978: begin
979: select 'Y'
980: into lf_final_flag
981: from jg_zz_vat_final_reports fin,jg_zz_vat_rep_status rep
982: where fin.REPORT_NAME = pv_report_name
983: and NVL(fin.vat_register_id, -1) = NVL(pv_vat_register_id, -1)
984: and fin.REPORTING_STATUS_ID = rep.reporting_status_id
985: and rep.vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 1048: insert into jg_zz_vat_final_reports

1044: ,pv_tax_calendar_period
1045: ,pv_tax_calendar_year
1046: ,lv_source)
1047: loop
1048: insert into jg_zz_vat_final_reports
1049: (
1050: FINAL_REPORT_ID
1051: , REPORTING_STATUS_ID
1052: , REPORT_NAME

Line 1067: jg_zz_vat_final_reports_s.NEXTVAL

1063: , OBJECT_VERSION_NUMBER
1064: )
1065: values
1066: (
1067: jg_zz_vat_final_reports_s.NEXTVAL
1068: , i.reporting_status_id
1069: , pv_report_name
1070: , pv_vat_register_id
1071: , nvl(fnd_profile.value('USER_ID'),1)