APPS.PAY_GTNLOD_PKG dependencies on PAY_US_ASG_RUN_FED_LIAB_RBR_V

Line 879: from PAY_US_ASG_RUN_FED_LIAB_RBR_V

875: procedure load_er_tax (l_assignment_action_id number, p_fed_liab_bal_status varchar2,p_state_liab_bal_status varchar2,p_local_bal_status varchar2) is
876:
877: cursor csr_er_tax_rbr is
878: select user_reporting_name,'1' sub_class,run_val
879: from PAY_US_ASG_RUN_FED_LIAB_RBR_V
880: where assignment_action_id = l_assignment_action_id
881: and ee_or_er_code = 'ER'
882: and database_item_suffix = decode(upper(user_reporting_name),
883: 'ER FUTA LIABILITY' ,'_ASG_JD_GRE_RUN' ,

Line 943: if l_fed_liab_view_name = 'PAY_US_ASG_RUN_FED_LIAB_RBR_V' then

939: from ' || l_fed_liab_view_name ||
940: ' where assignment_action_id ='|| l_assignment_action_id||
941: ' and ee_or_er_code = ''ER'' ';
942:
943: if l_fed_liab_view_name = 'PAY_US_ASG_RUN_FED_LIAB_RBR_V' then
944: lv_sql_query := lv_sql_query || ' and database_item_suffix = decode
945: (
946: upper(user_reporting_name),
947: ''ER FUTA LIABILITY'' ,