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_CA_RL1_AMEND_MAG dependencies on DUAL

Line 195: FROM dual;

191:
192: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
193: SELECT substr(l_transmitter_number,1,2)
194: INTO dummy1
195: FROM dual;
196:
197: IF (dummy1 <> 'NP' OR
198: length(l_transmitter_number) <> 8) THEN
199: RAISE INVALID_NUMBER;

Line 204: FROM dual;

200: END IF;
201:
202: SELECT to_number(substr(l_transmitter_number,3,6))
203: INTO dummy
204: FROM dual;
205:
206: EXCEPTION
207: WHEN INVALID_NUMBER THEN
208: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');

Line 272: select 'B-1' code,to_char(p_cpp_withheld) value from dual

268:
269: cursor cur_further_info(p_cpp_withheld NUMBER,p_cpp_taxable NUMBER) is
270: select substr(ltrim(rtrim(code)),1,60) code, value value
271: from (
272: select 'B-1' code,to_char(p_cpp_withheld) value from dual
273: where p_cpp_withheld <> 0
274: union
275: select 'G-2' code,to_char(p_cpp_taxable) value from dual
276: where p_cpp_taxable <> 0

Line 275: select 'G-2' code,to_char(p_cpp_taxable) value from dual

271: from (
272: select 'B-1' code,to_char(p_cpp_withheld) value from dual
273: where p_cpp_withheld <> 0
274: union
275: select 'G-2' code,to_char(p_cpp_taxable) value from dual
276: where p_cpp_taxable <> 0
277: union
278: select decode(fdi.user_name,'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD','201',
279: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_211_AMT_PER_JD_YTD','211',

Line 721: from dual;

717:
718:
719: select pay_assignment_actions_s.nextval
720: into lockingactid
721: from dual;
722: hr_utility.set_location('pay_ca_rl1_amend_mag.create_assignement_act', 50);
723: hr_utility.trace('New RL1 Amend Action = ' ||
724: to_char(lockingactid));
725:

Line 947: FROM dual;

943:
944: SELECT
945: fnd_global.local_chr(13) || fnd_global.local_chr(10)
946: INTO EOL
947: FROM dual;
948:
949: lAnnee := 1;
950: lTypeEnvoi := 2;
951: lProvenance := 3;

Line 1665: FROM dual;

1661:
1662: SELECT
1663: fnd_global.local_chr(13) || fnd_global.local_chr(10)
1664: INTO EOL
1665: FROM dual;
1666:
1667: lAnnee := 1;
1668: lNoReleve := 2;
1669: lNAS := 3;

Line 2024: FROM dual;

2020: to_number(l_box) <> 0 THEN
2021:
2022: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2023: INTO l_formatted_box
2024: FROM dual;
2025: tab_employee(lA_RevenuEmploi) := '' || l_formatted_box ||
2026: '' || EOL;
2027: tab_xml_employee(lA_RevenuEmploi) := l_formatted_box; --
2028: l_all_box_0 := FALSE;

Line 2056: FROM dual;

2052: l_BoxB := l_box;
2053:
2054: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2055: INTO l_formatted_box
2056: FROM dual;
2057:
2058: tab_employee(lB_CotisationRRQ) := '' || l_formatted_box
2059: || '' || EOL;
2060: tab_xml_employee(lB_CotisationRRQ) := l_formatted_box; --

Line 2090: FROM dual;

2086: to_number(l_box) <> 0 THEN
2087:
2088: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2089: INTO l_formatted_box
2090: FROM dual;
2091:
2092: tab_employee(lC_CotisationAssEmploi) := '' ||
2093: l_formatted_box || '' || EOL;
2094: tab_xml_employee(lC_CotisationAssEmploi) := l_formatted_box; --

Line 2123: FROM dual;

2119: to_number(l_box) <> 0 THEN
2120:
2121: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2122: INTO l_formatted_box
2123: FROM dual;
2124:
2125: tab_employee(lD_CotisationRPA) := '' ||
2126: l_formatted_box || '' || EOL;
2127: tab_xml_employee(lD_CotisationRPA) := l_formatted_box; --

Line 2157: FROM dual;

2153: to_number(l_box) <> 0 THEN
2154:
2155: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2156: INTO l_formatted_box
2157: FROM dual;
2158:
2159: tab_employee(lE_ImpotQue) := '' ||
2160: l_formatted_box || '' || EOL;
2161: tab_xml_employee(lE_ImpotQue) := l_formatted_box ; --

Line 2190: FROM dual;

2186: to_number(l_box) <> 0 THEN
2187:
2188: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2189: INTO l_formatted_box
2190: FROM dual;
2191:
2192: tab_employee(lF_CotisationSyndicale) := '' ||
2193: l_formatted_box || '' || EOL;
2194: tab_xml_employee(lF_CotisationSyndicale) := l_formatted_box; --

Line 2222: FROM dual;

2218: to_number(l_box) <> 0 THEN
2219:
2220: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2221: INTO l_formatted_box
2222: FROM dual;
2223:
2224: tab_employee(lQ_SalaireDiffere) := '' ||
2225: l_formatted_box || '' || EOL;
2226: tab_xml_employee(lQ_SalaireDiffere) := l_formatted_box; --

Line 2257: FROM dual;

2253: to_number(l_box) <> 0 THEN
2254:
2255: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2256: INTO l_formatted_box
2257: FROM dual;
2258:
2259: tab_employee(lU_RetraiteProgressive) := '' ||
2260: l_formatted_box || '' || EOL;
2261: tab_xml_employee(lU_RetraiteProgressive) := l_formatted_box; --

Line 2297: FROM dual;

2293: l_msg_code := 'AMT_GREATER_THAN_RANGE';
2294:
2295: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2296: INTO l_formatted_box
2297: FROM dual;
2298:
2299: tab_employee(lG_SalaireAdmisRRQ) := '' ||
2300: l_formatted_box || '' || EOL;
2301: --tab_xml_employee(lG_SalaireAdmisRRQ) := l_formatted_box; --

Line 2315: FROM dual;

2311: NVL(to_number(l_BoxU),0)) THEN
2312:
2313: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2314: INTO l_formatted_box
2315: FROM dual;
2316:
2317: tab_employee(lG_SalaireAdmisRRQ) := '' ||
2318: l_formatted_box || '' || EOL;
2319:

Line 2331: FROM dual;

2327: --commented for bug 10283923, in this case also Box G value should display
2328: --tab_employee(lG_SalaireAdmisRRQ) := NULL;
2329: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2330: INTO l_formatted_box
2331: FROM dual;
2332:
2333: tab_employee(lG_SalaireAdmisRRQ) := '' ||
2334: l_formatted_box || '' || EOL;
2335:

Line 2370: FROM dual;

2366: to_number(l_box) <> 0 THEN
2367:
2368: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2369: INTO l_formatted_box
2370: FROM dual;
2371:
2372: tab_employee(lV_NourritureLogement) := '' ||
2373: l_formatted_box || '' || EOL;
2374: tab_xml_employee(lV_NourritureLogement) := l_formatted_box; --

Line 2403: FROM dual;

2399: to_number(l_box) <> 0 THEN
2400:
2401: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2402: INTO l_formatted_box
2403: FROM dual;
2404:
2405: tab_employee(lW_Vehicule) := '' ||
2406: l_formatted_box || '' || EOL;
2407: tab_xml_employee(lW_Vehicule) := l_formatted_box; --

Line 2435: FROM dual;

2431: to_number(l_box) <> 0 THEN
2432:
2433: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2434: INTO l_formatted_box
2435: FROM dual;
2436:
2437: tab_employee(lH_CotisationRQAP) := '' ||
2438: l_formatted_box || '' || EOL;
2439: tab_xml_employee(lH_CotisationRQAP) := l_formatted_box; --

Line 2469: FROM dual;

2465: to_number(l_box) <> 0 THEN
2466:
2467: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2468: INTO l_formatted_box
2469: FROM dual;
2470:
2471: tab_employee(lI_SalaireAdmisRQAP) := '' ||
2472: l_formatted_box || '' || EOL;
2473: tab_xml_employee(lI_SalaireAdmisRQAP) := l_formatted_box; --

Line 2503: FROM dual;

2499: to_number(l_box) <> 0 THEN
2500:
2501: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2502: INTO l_formatted_box
2503: FROM dual;
2504:
2505: tab_employee(lJ_RegimeAssMaladie) := '' ||
2506: l_formatted_box || '' || EOL;
2507: tab_xml_employee(lJ_RegimeAssMaladie) := l_formatted_box; --

Line 2536: FROM dual;

2532: to_number(l_box) <> 0 THEN
2533:
2534: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2535: INTO l_formatted_box
2536: FROM dual;
2537:
2538: tab_employee(lK_Voyage) := '' ||
2539: l_formatted_box || '' || EOL;
2540: tab_xml_employee(lK_Voyage) := l_formatted_box; --

Line 2568: FROM dual;

2564: to_number(l_box) <> 0 THEN
2565:
2566: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2567: INTO l_formatted_box
2568: FROM dual;
2569:
2570: tab_employee(lL_AutreAvantage) := '' ||
2571: l_formatted_box || '' || EOL;
2572: tab_xml_employee(lL_AutreAvantage) := l_formatted_box; --

Line 2600: FROM dual;

2596: to_number(l_box) <> 0 THEN
2597:
2598: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2599: INTO l_formatted_box
2600: FROM dual;
2601:
2602: tab_employee(lM_Commission) := '' ||
2603: l_formatted_box || '' || EOL;
2604: tab_xml_employee(lM_Commission) := l_formatted_box; --

Line 2632: FROM dual;

2628: to_number(l_box) <> 0 THEN
2629:
2630: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2631: INTO l_formatted_box
2632: FROM dual;
2633:
2634: tab_employee(lN_DonBienfaisance) := '' ||
2635: l_formatted_box || '' || EOL;
2636: tab_xml_employee(lN_DonBienfaisance) := l_formatted_box; --

Line 2666: FROM dual;

2662:
2663: l_boxO := l_box;
2664: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2665: INTO l_formatted_box
2666: FROM dual;
2667:
2668: tab_employee(lO_AutreRevenu) := '' ||
2669: l_formatted_box || '' || EOL;
2670: tab_xml_employee(lO_AutreRevenu) := l_formatted_box; --

Line 2728: FROM dual;

2724: to_number(l_box) <> 0 THEN
2725:
2726: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2727: INTO l_formatted_box
2728: FROM dual;
2729:
2730: tab_employee(lP_RegimeAssInterEntr) := '' ||
2731: l_formatted_box || '' || EOL;
2732: tab_xml_employee(lP_RegimeAssInterEntr) := l_formatted_box; --

Line 2760: FROM dual;

2756: to_number(l_box) <> 0 THEN
2757:
2758: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2759: INTO l_formatted_box
2760: FROM dual;
2761:
2762: tab_employee(lR_RevenuIndien) := '' ||
2763: l_formatted_box || '' || EOL;
2764: tab_xml_employee(lR_RevenuIndien) := l_formatted_box; --

Line 2792: FROM dual;

2788: to_number(l_box) <> 0 THEN
2789:
2790: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2791: INTO l_formatted_box
2792: FROM dual;
2793:
2794: tab_employee(lS_PourboireRecu) := '' ||
2795: l_formatted_box || '' || EOL;
2796: tab_xml_employee(lS_PourboireRecu) := l_formatted_box; --

Line 2824: FROM dual;

2820: to_number(l_box) <> 0 THEN
2821:
2822: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2823: INTO l_formatted_box
2824: FROM dual;
2825:
2826: tab_employee(lT_PourboireAttribue) := '' ||
2827: l_formatted_box || '' || EOL;
2828: tab_xml_employee(lT_PourboireAttribue) := l_formatted_box; --

Line 2856: FROM dual;

2852: and l_taxation_year = '2011' THEN /*Bug 14701466 here*/
2853:
2854: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2855: INTO l_formatted_box
2856: FROM dual;
2857:
2858: tab_employee(l_ContisationRPC) := '' ||
2859: l_formatted_box || '' || EOL;
2860: l_all_box_0 := FALSE;

Line 2886: FROM dual;

2882: and l_taxation_year = '2011' THEN /*Bug 14701466 here*/
2883:
2884: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2885: INTO l_formatted_box
2886: FROM dual;
2887:
2888: tab_employee(l_FraisGarde) := '' ||
2889: l_formatted_box || '' || EOL;
2890: l_all_box_0 := FALSE;

Line 2919: FROM dual;

2915: and l_taxation_year = '2011' THEN /*Bug 14701466 here*/
2916:
2917: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2918: INTO l_formatted_box
2919: FROM dual;
2920:
2921: tab_employee(l_DeductionForce) := '' ||
2922: l_formatted_box || '' || EOL;
2923: l_all_box_0 := FALSE;

Line 3005: FROM dual;

3001: l_further_amount(l_i) <> '0' and
3002: l_further_code(l_i) <> 'B-1' then
3003: SELECT ltrim(rtrim(to_char(to_number(l_further_amount(l_i)),l_format_mask)))
3004: INTO l_formatted_box
3005: FROM dual;
3006: select decode(l_further_code(l_i),'201','F_1','211','F_2','235','F_3',replace(l_further_code(l_i),'-','_'))
3007: into l_formatted_code
3008: from dual;
3009: l_other_details:=l_other_details||'<'||l_formatted_code||'>'

Line 3008: from dual;

3004: INTO l_formatted_box
3005: FROM dual;
3006: select decode(l_further_code(l_i),'201','F_1','211','F_2','235','F_3',replace(l_further_code(l_i),'-','_'))
3007: into l_formatted_code
3008: from dual;
3009: l_other_details:=l_other_details||'<'||l_formatted_code||'>'
3010: ||l_formatted_box||''||EOL;
3011: end if;
3012: end loop;

Line 3098: FROM dual;

3094: and (NVL(tab_xml_employee(l_SourceCase),'RZ') = 'RZ' or l_further_code(l_i) not like 'RZ%') then
3095: l_k := l_k + 1;
3096: SELECT ltrim(rtrim(to_char(to_number(l_further_amount(l_i)),l_format_mask)))
3097: INTO l_formatted_box
3098: FROM dual;
3099: l_further_info_string:=l_further_info_string||''||EOL
3100: ||''||l_further_code(l_i)||''||EOL
3101: ||''||l_formatted_box||''||EOL
3102: ||'';

Line 3233: FROM dual;

3229: hr_utility.trace('Inside the Employer Main Record proc');
3230: SELECT
3231: fnd_global.local_chr(13) || fnd_global.local_chr(10)
3232: INTO EOL
3233: FROM dual;
3234:
3235: lAnnee := 1;
3236: lNbReleves := 2;
3237: lNoId := 3;

Line 3520: from dual;

3516: hr_utility.trace('l_see_attached = '||l_see_attached);
3517: SELECT
3518: fnd_global.local_chr(13) || fnd_global.local_chr(10)
3519: INTO EOL
3520: from dual;
3521: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
3522: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
3523: open c_get_language(p_assgn_id);
3524: fetch c_get_language into l_person_lang;

Line 3649: FROM dual;

3645:
3646: SELECT
3647: fnd_global.local_chr(13) || fnd_global.local_chr(10)
3648: INTO EOL
3649: FROM dual;
3650:
3651: lNoId := 1;
3652: lNom1 := 2;
3653: lLigne1 := 3;