DBA Data[Home] [Help]

APPS.PAY_US_REPORTING_UTILS_PKG dependencies on HR_US_W2_REP

Line 2488: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL

2484:
2485:
2486: hr_utility.trace('before Call to retrieve state_wages');
2487:
2488: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2489: (p_assignment_action_id,'A_W2_STATE_WAGES',
2490: p_tax_unit_id,l_jurisdiction_code,2);
2491:
2492: hr_utility.trace('l_state_wage = '||l_state_wage);

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

3052: and fai.context1 = paa.assignment_action_id
3053: and fai.value = p_state
3054: and paa.tax_unit_id = p_tax_unit_id
3055: and paa.action_status = 'C'
3056: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3057: 'A_W2_STATE_WAGES',
3058: paa.tax_unit_id,
3059: faic.context , 2),0) > 0
3060: and not exists

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

3091: and fai.context1 = paa.assignment_action_id
3092: and fai.value = p_state
3093: and paa.tax_unit_id = p_tax_unit_id
3094: and paa.action_status = 'C'
3095: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3096: 'A_W2_STATE_WAGES',
3097: paa.tax_unit_id,
3098: faic.context , 2),0) > 0
3099: and not exists