eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GTNLOD_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 76: to remove FTS on pay_element_types_f

72: 04-MAY-2004 irgonzal 115.27 Bug fix 3270485. Modified load_data procedure and commented
73: out the insert into rpt totals.
74: 05-May-2004 irgonzal 115.28 Fixed GSCC errors.
75: 22-JUL-2004 saurgupt 115.29 Bug 3369218: Modified cursor er_liab in procedure load_er_liab
76: to remove FTS on pay_element_types_f
77: 29-SEP-2004 saurgupt 115.30 Bug 3873069: Modified cursor er_liab of procedure load_er_liab
78: and cursor wc_er_liab of procedure load_wc_er_liab. The condition
79: pet.element_name = pbt.balance_name is modified to
80: pet.element_information10 = pbt.balance_type_id. This condition will

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 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 533: select /+ index(pay_us_earnings_amounts_v.pet , pay_element_types_f_pk)/

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,

Line 1259: from pay_element_types_f pet,

1255:
1256: cursor csr_er_credit_rbr is
1257: select distinct 'ER Tax Credits' classification_name ,'FUTA CREDIT' balance_name ,
1258: pet.element_name element_name, prb.jurisdiction_code jurisdiction_code
1259: from pay_element_types_f pet,
1260: pay_run_balances prb
1261: where l_effective_date between pet.effective_start_date and pet.effective_end_date
1262: and pet.element_name ='FUTA CREDIT'
1263: and prb.defined_balance_id = p_futa_def_bal_id

Line 1269: from pay_element_types_f pet,

1265:
1266: cursor csr_er_credit is
1267: select distinct 'ER Tax Credits' classification_name ,'FUTA CREDIT' balance_name ,
1268: pet.element_name element_name, prr.jurisdiction_code jurisdiction_code
1269: from pay_element_types_f pet,
1270: pay_run_results prr
1271: where l_effective_date between pet.effective_start_date and pet.effective_end_date
1272: and pet.element_name ='FUTA CREDIT'
1273: and prr.status in ('P','PA')

Line 1305: from pay_element_types_f pet,'

1301: -- Bug 5409416 : Removed prr.jurisdiction_code with
1302: OPEN cv FOR
1303: ' select distinct'||'''ER Tax Credits'''||' classification_name ,'||'''FUTA CREDIT'''||' balance_name ,
1304: pet.element_name element_name,'|| l_tname||'.jurisdiction_code jurisdiction_code
1305: from pay_element_types_f pet,'
1306: || l_futa_from ||
1307: ' where '''||l_effective_date||''' between pet.effective_start_date and pet.effective_end_date
1308: and pet.element_name ='||'''FUTA CREDIT'''||
1309: ' and '||l_futa_where;

Line 1449: pay_element_types_f pet,

1445: select distinct pec.classification_name classification_name,
1446: pbt.balance_name balance_name,
1447: pet.element_name element_name
1448: from pay_balance_types pbt,
1449: pay_element_types_f pet,
1450: pay_element_classifications pec,
1451: pay_run_balances prb,
1452: pay_defined_balances pdb,
1453: pay_balance_dimensions pbd

Line 1477: pay_element_types_f pet,

1473: select distinct pec.classification_name classification_name,
1474: pbt.balance_name balance_name,
1475: pet.element_name element_name
1476: from pay_balance_types pbt,
1477: pay_element_types_f pet,
1478: pay_element_classifications pec,
1479: pay_run_results prr
1480: where pec.classification_name ='Employer Liabilities'
1481: and pec.legislation_code ='US'

Line 1508: pay_element_types_f pet,

1504: pbt.balance_name balance_name,
1505: pet.element_name element_name
1506: from
1507: pay_balance_types pbt,
1508: pay_element_types_f pet,
1509: pay_element_classifications pec,'
1510: || l_er_liab_from||
1511: ' where pec.classification_name ='||'''Employer Liabilities'''||
1512: ' and pec.legislation_code ='||'''US'''||

Line 1516: and '''|| l_effective_date||''' between pet.effective_start_date -- remove FTS on pay_element_types_f

1512: ' and pec.legislation_code ='||'''US'''||
1513: ' and pet.classification_id = pec.classification_id
1514: and pet.business_group_id = '||l_business_group_id||
1515: ' and pet.element_type_id >= 0 -- Bug 3369218: Added to enforce index to
1516: and '''|| l_effective_date||''' between pet.effective_start_date -- remove FTS on pay_element_types_f
1517: and pet.effective_end_date
1518: and pet.element_information10 = pbt.balance_type_id
1519: and pbt.business_group_id ='|| l_business_group_id ||
1520: ' and '||l_er_liab_where;

Line 2076: pay_element_types_f pet,

2072: pftr.sui_jurisdiction_code jurisdiction_code,
2073: pst.state_name state_name
2074: from
2075: pay_balance_types pbt,
2076: pay_element_types_f pet,
2077: pay_element_classifications pec,
2078: pay_assignment_actions paa,
2079: per_all_assignments_f paf,
2080: pay_us_emp_fed_tax_rules_F pftr,

Line 2123: pay_element_types_f pet,

2119: pftr.sui_jurisdiction_code jurisdiction_code,
2120: pst.state_name state_name
2121: from
2122: pay_balance_types pbt,
2123: pay_element_types_f pet,
2124: pay_element_classifications pec,
2125: pay_assignment_actions paa,
2126: per_all_assignments_f paf,
2127: pay_us_emp_fed_tax_rules_F pftr,

Line 2171: pay_element_types_f pet,

2167: pftr.sui_jurisdiction_code jurisdiction_code,
2168: pst.state_name state_name
2169: from
2170: pay_balance_types pbt,
2171: pay_element_types_f pet,
2172: pay_element_classifications pec,
2173: pay_assignment_actions paa,
2174: per_all_assignments_f paf,
2175: pay_us_emp_fed_tax_rules_F pftr,