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_YEAR_END_EXTRACT dependencies on FND_NUMBER

Line 138: AND pay.tax_district_reference = NVL(FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_tax_district_ref,1,3)), pay.tax_district_reference);

134: AND pay.business_group_id = p_business_group_id
135: AND pay.tax_year = p_year
136: AND pay.permit_number = NVL(p_permit,pay.permit_number)
137: AND pay.tax_reference_number = NVL(SUBSTR(p_tax_district_ref,4,8), pay.tax_reference_number)
138: AND pay.tax_district_reference = NVL(FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_tax_district_ref,1,3)), pay.tax_district_reference);
139: RETURN l_count;
140: END check_data;
141:
142: /* ----------------------------------------------------------------------------*/

Line 243: l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));

239:
240: begin
241: hr_utility.set_location('PAY_YEAR_END_EXTRACT.TRASH',2);
242: --
243: l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));
244: l_tax_reference_number := substr(ltrim(substr(p_tax_district_ref,
245: 4,8),'/') ,1,7);
246: -- set up the statutory start and end year
247: l_start_year := to_date('06-04-'||(p_year - 1),'dd-mm-yyyy');

Line 454: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) able,

450: pay_year_end_extract.get_nearest_scon(
451: max(EV_SCON.element_entry_id),'S',max(PACT.effective_date))),
452: null)),1,9) scon,
453: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
454: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) able,
455: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
456: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Total,
457: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
458: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employee,

Line 456: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Total,

452: null)),1,9) scon,
453: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',
454: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) able,
455: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
456: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Total,
457: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
458: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employee,
459: --
460: -- Bug Fix 678573 Start

Line 458: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employee,

454: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) able,
455: 100*nvl(sum(decode(substr(bal.balance_name,6),'Total',
456: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Total,
457: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employee',
458: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employee,
459: --
460: -- Bug Fix 678573 Start
461: --
462: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employer',

Line 463: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employer,

459: --
460: -- Bug Fix 678573 Start
461: --
462: 100*nvl(sum(decode(substr(bal.balance_name,6),'Employer',
463: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) Employer,
464: --
465: -- Bug Fix 678573 End
466: --
467: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO Able',

Line 468: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO_able,

464: --
465: -- Bug Fix 678573 End
466: --
467: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO Able',
468: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO_able,
469: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO',
470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO
471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL

Line 470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO

466: --
467: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO Able',
468: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO_able,
469: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO',
470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO
471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL
473: ,pay_run_result_values TARGET
474: ,pay_run_results RR

Line 624: l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));

620: plog('_ Request('||to_char(p_request_id)||')');
621: --
622: -- Check tax_district_reference input is valid (ie. numeric) else raise error
623: begin
624: l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));
625: if l_tax_district_reference < 0 then raise value_error; end if;
626: exception
627: when value_error then
628: raise tax_dist_ref_error;

Line 642: -- l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));

638: --
639: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',2);
640:
641: p_retcode := 1; -- default extract to success
642: -- l_tax_district_reference := fnd_number.canonical_to_number(substr(p_tax_district_ref,1,3));
643: l_tax_reference_number := substr(ltrim(substr(p_tax_district_ref,
644: 4,8),'/') ,1,7);
645:
646: -- set up the statutory start and end year

Line 1704: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',

1700: update pay_gb_year_end_assignments ye_asg set
1701: ( TAX_CODE, W1_M1_INDICATOR,PREVIOUS_TAXABLE_PAY,PREVIOUS_TAX_PAID) =
1702: (select max(decode(iv.name,'Tax Code',SCREEN_ENTRY_VALUE,null)) Tax_code,
1703: max(decode(iv.name,'Tax Basis',SCREEN_ENTRY_VALUE,null)) Tax_Basis,
1704: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
1705: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1706: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1707: SCREEN_ENTRY_VALUE,null))) Tax_previous
1708: from pay_element_entries_f e,

Line 1706: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',

1702: (select max(decode(iv.name,'Tax Code',SCREEN_ENTRY_VALUE,null)) Tax_code,
1703: max(decode(iv.name,'Tax Basis',SCREEN_ENTRY_VALUE,null)) Tax_Basis,
1704: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
1705: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1706: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1707: SCREEN_ENTRY_VALUE,null))) Tax_previous
1708: from pay_element_entries_f e,
1709: pay_element_entry_values_f v,
1710: pay_gb_year_end_payrolls ye_roll,

Line 1740: 100 * fnd_number.canonical_to_number(max(decode(name,'Pay Previous',result_value,null))) Pay_previous,

1736: update pay_gb_year_end_assignments ye_asg set
1737: ( TAX_CODE, W1_M1_INDICATOR,PREVIOUS_TAXABLE_PAY,PREVIOUS_TAX_PAID) =
1738: (select max(decode(name,'Tax Code',result_value,null)) Tax_code,
1739: max(decode(name,'Tax Basis',result_value,null)) Tax_Basis,
1740: 100 * fnd_number.canonical_to_number(max(decode(name,'Pay Previous',result_value,null))) Pay_previous,
1741: 100 * fnd_number.canonical_to_number(max(decode(name,'Tax Previous',result_value,null))) Tax_previous
1742: from pay_input_values_f v,
1743: pay_run_result_values rrv
1744: where rrv.RUN_RESULT_ID = ye_asg.TAX_RUN_RESULT_ID

Line 1741: 100 * fnd_number.canonical_to_number(max(decode(name,'Tax Previous',result_value,null))) Tax_previous

1737: ( TAX_CODE, W1_M1_INDICATOR,PREVIOUS_TAXABLE_PAY,PREVIOUS_TAX_PAID) =
1738: (select max(decode(name,'Tax Code',result_value,null)) Tax_code,
1739: max(decode(name,'Tax Basis',result_value,null)) Tax_Basis,
1740: 100 * fnd_number.canonical_to_number(max(decode(name,'Pay Previous',result_value,null))) Pay_previous,
1741: 100 * fnd_number.canonical_to_number(max(decode(name,'Tax Previous',result_value,null))) Tax_previous
1742: from pay_input_values_f v,
1743: pay_run_result_values rrv
1744: where rrv.RUN_RESULT_ID = ye_asg.TAX_RUN_RESULT_ID
1745: and v.INPUT_VALUE_ID = rrv.INPUT_VALUE_ID

Line 1760: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',

1756: update pay_gb_year_end_assignments ye_asg set
1757: ( TAX_CODE, W1_M1_INDICATOR,PREVIOUS_TAXABLE_PAY,PREVIOUS_TAX_PAID) =
1758: (select max(decode(iv.name,'Tax Code',SCREEN_ENTRY_VALUE,null)) Tax_code,
1759: max(decode(iv.name,'Tax Basis',SCREEN_ENTRY_VALUE,null)) Tax_Basis,
1760: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
1761: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1762: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1763: SCREEN_ENTRY_VALUE,null))) Tax_previous
1764: from pay_element_entries_f e,

Line 1762: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',

1758: (select max(decode(iv.name,'Tax Code',SCREEN_ENTRY_VALUE,null)) Tax_code,
1759: max(decode(iv.name,'Tax Basis',SCREEN_ENTRY_VALUE,null)) Tax_Basis,
1760: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
1761: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1762: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1763: SCREEN_ENTRY_VALUE,null))) Tax_previous
1764: from pay_element_entries_f e,
1765: pay_element_entry_values_f v,
1766: pay_gb_year_end_payrolls ye_roll,