APPS.PAY_US_REPORTING_UTILS_PKG dependencies on HR_US_W2_REP

Line 2505: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL

2501:
2502:
2503: hr_utility.trace('before Call to retrieve state_wages');
2504:
2505: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2506: (p_assignment_action_id,'A_W2_STATE_WAGES',
2507: p_tax_unit_id,l_jurisdiction_code,2);
2508:
2509: hr_utility.trace('l_state_wage = '||l_state_wage);

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

3071: and fai.context1 = paa.assignment_action_id
3072: and fai.value = p_state
3073: and paa.tax_unit_id = p_tax_unit_id
3074: and paa.action_status = 'C'
3075: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3076: 'A_W2_STATE_WAGES',
3077: paa.tax_unit_id,
3078: faic.context , 2),0) > 0
3079: and not exists

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

3118: and fai.context1 = paa.assignment_action_id
3119: and fai.value = p_state
3120: and paa.tax_unit_id = p_tax_unit_id
3121: and paa.action_status = 'C'
3122: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3123: 'A_W2_STATE_WAGES',
3124: paa.tax_unit_id,
3125: faic.context , 2),0) > 0
3126: and not exists

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

3186: and fai.context1 = paa.assignment_action_id
3187: and fai.value = p_state
3188: and paa.tax_unit_id = p_tax_unit_id
3189: and paa.action_status = 'C'
3190: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3191: 'A_W2_STATE_WAGES',
3192: paa.tax_unit_id,
3193: faic.context , 2),0) > 0
3194: and not exists

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

3256: and fai.context1 = paa.assignment_action_id
3257: and fai.value = p_state
3258: and paa.tax_unit_id = p_tax_unit_id
3259: and paa.action_status = 'C'
3260: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
3261: 'A_W2_STATE_WAGES',
3262: paa.tax_unit_id,
3263: faic.context , 2),0) > 0
3264: and not exists