APPS.PAY_GTNLOD_PKG dependencies on PAY_US_GTN_EARNINGS_V

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

350: 'Supplemental Earnings',
351: 'Non-payroll Payments');
352:
353: cursor csr_earn is
354: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
355: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
356: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
357: */
358: classification_name,

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

351: 'Non-payroll Payments');
352:
353: cursor csr_earn is
354: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
355: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
356: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
357: */
358: classification_name,
359: decode(classification_name,'Earnings','1',

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

352:
353: cursor csr_earn is
354: select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
355: INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
356: INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
357: */
358: classification_name,
359: decode(classification_name,'Earnings','1',
360: 'Imputed Earnings','2',

Line 367: from PAY_US_GTN_EARNINGS_V

363: '9')subclass,
364: element_name,
365: cash_value cash_value,
366: hours_value hours_value
367: from PAY_US_GTN_EARNINGS_V
368: where assignment_action_id = l_assignment_action_id
369: and classification_name in ('Earnings',
370: 'Imputed Earnings',
371: 'Supplemental Earnings',

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

385: -- hr_utility.trace('l_earn_view_name = '|| l_earn_view_name);
386:
387:
388: -- OPEN cv FOR
389: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
390: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
391: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
392: -- */
393: -- classification_name,

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

386:
387:
388: -- OPEN cv FOR
389: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
390: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
391: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
392: -- */
393: -- classification_name,
394: -- decode(classification_name,'||'''Earnings'''||','||'''1'''||','||'''Imputed Earnings'''||','||'''2'''||','||'''Supplemental Earnings'''||','||'''3'''||','||'''Non-payroll Payments'''||','||'''4'''||','||'''9'''||')subclass,

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

387:
388: -- OPEN cv FOR
389: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)
390: -- INDEX(pay_us_gtn_earnings_v.ernv.PETTL PAY_ELEMENT_TYPES_F_TL_PK)
391: -- INDEX(pay_us_gtn_earnings_v.ernv.pet PAY_ELEMENT_TYPES_F_pk)
392: -- */
393: -- classification_name,
394: -- decode(classification_name,'||'''Earnings'''||','||'''1'''||','||'''Imputed Earnings'''||','||'''2'''||','||'''Supplemental Earnings'''||','||'''3'''||','||'''Non-payroll Payments'''||','||'''4'''||','||'''9'''||')subclass,
395: -- element_name,

Line 2458: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';

2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2458: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2459: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2460: l_state_view_name := 'PAY_US_STATE_TAXES_V';
2461: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';
2462: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_V';