DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_ASG_RUN_FED_TAX_RBR_V

Line 588: from PAY_US_ASG_RUN_FED_TAX_RBR_V

584: cv cv_typ; */
585: 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
586: cursor csr_ee_tax_rbr is
587: select user_reporting_name,'1' sub_class,run_val,null,null
588: from PAY_US_ASG_RUN_FED_TAX_RBR_V
589: where assignment_action_id = l_assignment_action_id
590: and ee_or_er_code = 'EE'
591: and tax_type_code <> 'EIC'
592: UNION ALL

Line 1094: from PAY_US_ASG_RUN_FED_TAX_RBR_V

1090: procedure load_ee_credit (l_assignment_action_id number,p_fed_bal_status varchar2, p_state_bal_status varchar2) is
1091:
1092: cursor csr_ee_credit_rbr is
1093: select user_reporting_name,run_val
1094: from PAY_US_ASG_RUN_FED_TAX_RBR_V
1095: where assignment_action_id = l_assignment_action_id
1096: and ee_or_er_code = 'EE'
1097: and tax_type_code = 'EIC'
1098: UNION ALL