APPS.PAY_GTNLOD_PKG dependencies on PAY_US_EARNINGS_AMOUNTS_V

Line 565: select /*+ index(pay_us_earnings_amounts_v.pet , pay_element_types_f_pk)*/

561: -- procedure name : load_alien_earnings
562: --------------------------------------------------------------
563: procedure load_alien_earnings (l_assignment_action_id number) is
564: cursor ee_earn is
565: select /*+ index(pay_us_earnings_amounts_v.pet , pay_element_types_f_pk)*/
566: classification_name,
567: 5 sub_class,
568: --reporting_name_alt, /* Bug 5918981: element_name is replaced with reporting_name_alt */
569: element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */

Line 572: from pay_us_earnings_amounts_v

568: --reporting_name_alt, /* Bug 5918981: element_name is replaced with reporting_name_alt */
569: element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
570: run_val cash_value,
571: hours_run_val hours_value
572: from pay_us_earnings_amounts_v
573: where assignment_action_id = l_assignment_action_id
574: and classification_name = 'Alien/Expat Earnings';
575:
576: ee_earn_rec ee_earn%rowtype;