DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_ASG_RUN_FED_TAX_RBR_V

Line 686: from PAY_US_ASG_RUN_FED_TAX_RBR_V

682: cv cv_typ; */
683: procedure load_ee_tax (l_assignment_action_id number,p_fed_bal_status varchar2,p_state_bal_status varchar2,p_local_bal_status varchar2) is
684: cursor csr_ee_tax_rbr is
685: select user_reporting_name,'1' sub_class,run_val,null,null
686: from PAY_US_ASG_RUN_FED_TAX_RBR_V
687: where assignment_action_id = l_assignment_action_id
688: and ee_or_er_code = 'EE'
689: and tax_type_code <> 'EIC'
690: UNION ALL

Line 1263: from PAY_US_ASG_RUN_FED_TAX_RBR_V

1259: procedure load_ee_credit (l_assignment_action_id number,p_fed_bal_status varchar2, p_state_bal_status varchar2) is
1260:
1261: cursor csr_ee_credit_rbr is
1262: select user_reporting_name,run_val
1263: from PAY_US_ASG_RUN_FED_TAX_RBR_V
1264: where assignment_action_id = l_assignment_action_id
1265: and ee_or_er_code = 'EE'
1266: and tax_type_code = 'EIC'
1267: UNION ALL