APPS.PAY_GTNLOD_PKG dependencies on PAY_US_GTN_EARNINGS_V

Line 383: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)

379: 'Non-payroll Payments',
380: 'Alien/Expat Earnings');
381:
382: cursor csr_earn is
383: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
384: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
385: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
386: */
387: classification_name,

Line 384: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)

380: 'Alien/Expat Earnings');
381:
382: cursor csr_earn is
383: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
384: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
385: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
386: */
387: classification_name,
388: decode(classification_name,'Earnings','1',

Line 385: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)

381:
382: cursor csr_earn is
383: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
384: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
385: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
386: */
387: classification_name,
388: decode(classification_name,'Earnings','1',
389: 'Imputed Earnings','2',

Line 398: from PAY_US_GTN_EARNINGS_V

394: --reporting_name_alt, /* Bug 5918981: element_name is replaced with reporting_name_alt */
395: element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
396: cash_value cash_value,
397: hours_value hours_value
398: from PAY_US_GTN_EARNINGS_V
399: where assignment_action_id = l_assignment_action_id
400: and classification_name in ('Earnings',
401: 'Imputed Earnings',
402: 'Supplemental Earnings',

Line 421: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)

417: -- hr_utility.trace('l_earn_view_name = '|| l_earn_view_name);
418:
419:
420: -- OPEN cv FOR
421: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
422: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
423: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
424: -- */
425: -- classification_name,

Line 422: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)

418:
419:
420: -- OPEN cv FOR
421: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
422: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
423: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
424: -- */
425: -- classification_name,
426: -- decode(classification_name,'||'''Earnings'''||','||'''1'''||','||'''Imputed Earnings'''||','||'''2'''||','||'''Supplemental Earnings'''||','||'''3'''||','||'''Non-payroll Payments'''||','||'''4'''||','||'''9'''||')subclass,

Line 423: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)

419:
420: -- OPEN cv FOR
421: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
422: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
423: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
424: -- */
425: -- classification_name,
426: -- decode(classification_name,'||'''Earnings'''||','||'''1'''||','||'''Imputed Earnings'''||','||'''2'''||','||'''Supplemental Earnings'''||','||'''3'''||','||'''Non-payroll Payments'''||','||'''4'''||','||'''9'''||')subclass,
427: -- element_name,

Line 2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';

2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2651:
2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2654: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2655: l_state_view_name := 'PAY_US_STATE_TAXES_V';
2656: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';
2657: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_V';