DBA Data[Home] [Help]

APPS.PAY_US_MAGW2_REPORTING dependencies on HR_US_W2_REP

Line 858: AND nvl(hr_us_w2_rep.get_w2_arch_bal(

854: AND fai.value = ppa1.report_qualifier
855: AND paf.effective_start_date <= ppa.effective_date
856: AND paf.effective_end_date >= ppa.start_date
857: AND paa.action_status = ''C''
858: AND nvl(hr_us_w2_rep.get_w2_arch_bal(
859: paa.assignment_action_id,
860: ''A_W2_STATE_WAGES'',
861: paa.tax_unit_id,
862: faic.context , 2),0) > 0

Line 918: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

914: paf.assignment_id,
915: paa.tax_unit_id,
916: paf.effective_end_date,
917: paa.assignment_action_id,
918: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
919: 'A_W2_STATE_WAGES',
920: paa.tax_unit_id,
921: faic.context , 2),0)
922: FROM ff_archive_item_contexts faic,

Line 946: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

942: and paf.effective_start_date <= ppa.effective_date
943: and paf.effective_end_date >= ppa.start_date
944: and paa.action_status = 'C'
945: and paf.person_id BETWEEN p_stperson AND p_endperson
946: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
947: 'A_W2_STATE_WAGES',
948: paa.tax_unit_id,
949: faic.context , 2),0) > 0
950: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */