[Home] [Help]
441: total_deductions, discount_amount from igi_cis_mth_ret_pay_gt;*/
442: -- get the reporting entity information
443: Cursor C_rep_entity is
444: Select UNIQUE_TAX_REFERENCE_NUM,ACCOUNTS_OFFICE_REFERENCE,
445: TAX_OFFICE_NUMBER,PAYE_REFERENCE,fnd_profile.value('ORG_ID') ORG_ID,
446: CIS_SENDER_ID
447: From AP_REPORTING_ENTITIES
448: Where UNIQUE_TAX_REFERENCE_NUM is not null;
449: Cursor C_prev_return is
541: From AP_OTHER_PERIODS aop,
542: (SELECT decode(SIGN(to_number(to_char(sysdate, 'DD')) -6), -1, add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')), 'DD-MM-YYYY'), 3),
543: add_months(to_date(('05-' || to_char(sysdate, 'MM-YYYY')),'DD-MM-YYYY'), 4)) end_date_criteria from dual) temp
544: where aop.period_type =
545: fnd_profile.value('IGI_CIS2007_CALENDAR')
546: and aop.period_year <= 2099
547: and aop.end_date between to_date('05-05-2007', 'DD-MM-YYYY')
548: AND
549: temp.end_date_criteria
641: -- get the start_date and end_date from ap_other_periods
642: select start_date,end_date
643: into l_period_start_date,l_period_end_date
644: from ap_other_periods
645: where period_type = fnd_profile.value('IGI_CIS2007_CALENDAR')
646: and period_name = p_period_name;
647:
648: -- Throw error if there is a nil return already.
649: For C_prev_return_rec in C_prev_return loop