529: -- procedure name : load_alien_earnings
530: --------------------------------------------------------------
531: procedure load_alien_earnings (l_assignment_action_id number) is
532: cursor ee_earn is
533: select /*+ index(pay_us_earnings_amounts_v.pet , pay_element_types_f_pk)*/
534: classification_name,
535: 5 sub_class,
536: element_name,
537: run_val cash_value,
535: 5 sub_class,
536: element_name,
537: run_val cash_value,
538: hours_run_val hours_value
539: from pay_us_earnings_amounts_v
540: where assignment_action_id = l_assignment_action_id
541: and classification_name = 'Alien/Expat Earnings';
542:
543: ee_earn_rec ee_earn%rowtype;