DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_ASG_RUN_FED_LIAB_RBR_V

Line 1048: from PAY_US_ASG_RUN_FED_LIAB_RBR_V

1044: 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
1045:
1046: cursor csr_er_tax_rbr is
1047: select user_reporting_name,'1' sub_class,run_val
1048: from PAY_US_ASG_RUN_FED_LIAB_RBR_V
1049: where assignment_action_id = l_assignment_action_id
1050: and ee_or_er_code = 'ER'
1051: and database_item_suffix = decode(upper(user_reporting_name),
1052: 'ER FUTA LIABILITY' ,'_ASG_JD_GRE_RUN' ,

Line 1112: if l_fed_liab_view_name = 'PAY_US_ASG_RUN_FED_LIAB_RBR_V' then

1108: from ' || l_fed_liab_view_name ||
1109: ' where assignment_action_id ='|| l_assignment_action_id||
1110: ' and ee_or_er_code = ''ER'' ';
1111:
1112: if l_fed_liab_view_name = 'PAY_US_ASG_RUN_FED_LIAB_RBR_V' then
1113: lv_sql_query := lv_sql_query || ' and database_item_suffix = decode
1114: (
1115: upper(user_reporting_name),
1116: ''ER FUTA LIABILITY'' ,