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

Line 229: FROM dual;

225:
226: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
227: SELECT substr(l_transmitter_number,1,2)
228: INTO dummy1
229: FROM dual;
230:
231: IF (dummy1 <> 'NP' OR
232: length(l_transmitter_number) <> 8) THEN
233: RAISE INVALID_NUMBER;

Line 238: FROM dual;

234: END IF;
235:
236: SELECT to_number(substr(l_transmitter_number,3,6))
237: INTO dummy
238: FROM dual;
239:
240: EXCEPTION
241: WHEN INVALID_NUMBER THEN
242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');

Line 650: from dual;

646: /* Create an assignment action for this person */
647:
648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||
653: to_char(lockingactid));
654:

Line 916: FROM dual;

912:
913: SELECT
914: fnd_global.local_chr(13) || fnd_global.local_chr(10)
915: INTO EOL
916: FROM dual;
917:
918: lAnnee := 1;
919: lTypeEnvoi := 2;
920: lProvenance := 3;

Line 1680: FROM dual;

1676: l_original_slpno := '0';
1677: SELECT
1678: fnd_global.local_chr(13) || fnd_global.local_chr(10)
1679: INTO EOL
1680: FROM dual;
1681:
1682: lAnnee := 1;
1683: lNoReleve := 2;
1684: lNAS := 3;

Line 2028: FROM dual;

2024: to_number(l_rl2_box_a) <> 0 THEN
2025:
2026: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_a),l_format_mask)))
2027: INTO l_formatted_box
2028: FROM dual;
2029: -- changed to for bug 13083624
2030: tab_employee(lA_PrestRPA_RPNA) := '' || l_formatted_box ||
2031: '' || EOL;
2032: l_all_box_0 := FALSE;

Line 2052: FROM dual;

2048: to_number(l_rl2_box_b) <> 0 THEN
2049:
2050: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_b),l_format_mask)))
2051: INTO l_formatted_box
2052: FROM dual;
2053:
2054: tab_employee(lB_PrestREER_FERR_RPDB) := '' || l_formatted_box
2055: || '' || EOL;
2056: l_all_box_0 := FALSE;

Line 2078: FROM dual;

2074: to_number(l_rl2_box_c) <> 0 THEN
2075:
2076: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_c),l_format_mask)))
2077: INTO l_formatted_box
2078: FROM dual;
2079:
2080: tab_employee(lC_AutrePaiement ) := '' ||
2081: l_formatted_box || '' || EOL;
2082: l_all_box_0 := FALSE;

Line 2103: FROM dual;

2099: to_number(l_rl2_box_d) <> 0 THEN
2100:
2101: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_d),l_format_mask)))
2102: INTO l_formatted_box
2103: FROM dual;
2104:
2105: tab_employee(lD_RembPrimeConjoint) := '' ||
2106: l_formatted_box || '' || EOL;
2107:

Line 2128: FROM dual;

2124: to_number(l_rl2_box_e) <> 0 THEN
2125:
2126: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_e),l_format_mask)))
2127: INTO l_formatted_box
2128: FROM dual;
2129:
2130: tab_employee(lE_PrestDeces) := '' ||
2131: l_formatted_box || '' || EOL;
2132:

Line 2154: FROM dual;

2150: to_number(l_rl2_box_f) <> 0 THEN
2151:
2152: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_f),l_format_mask)))
2153: INTO l_formatted_box
2154: FROM dual;
2155:
2156: tab_employee(lF_RembCotisInutilise) := '' ||
2157: l_formatted_box || '' || EOL;
2158:

Line 2179: FROM dual;

2175: to_number(l_rl2_box_g) <> 0 THEN
2176:
2177: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_g),l_format_mask)))
2178: INTO l_formatted_box
2179: FROM dual;
2180:
2181: tab_employee(lG_RevocationREER_FERR ) := '' ||
2182: l_formatted_box || '' || EOL;
2183:

Line 2203: FROM dual;

2199: to_number(l_rl2_box_h) <> 0 THEN
2200:
2201: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_h),l_format_mask)))
2202: INTO l_formatted_box
2203: FROM dual;
2204:
2205: tab_employee(lH_AutreRevenu) := '' ||
2206: l_formatted_box || '' || EOL;
2207:

Line 2229: FROM dual;

2225: to_number(l_rl2_box_i) <> 0 THEN
2226:
2227: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_i),l_format_mask)))
2228: INTO l_formatted_box
2229: FROM dual;
2230:
2231: tab_employee(lI_DroitDeduction ) := '' ||
2232: l_formatted_box || '' || EOL;
2233:

Line 2254: FROM dual;

2250: to_number(l_rl2_box_j) <> 0 THEN
2251:
2252: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_j),l_format_mask)))
2253: INTO l_formatted_box
2254: FROM dual;
2255:
2256: tab_employee(lJ_ImpotQueRetenuSource ) := '' ||
2257: l_formatted_box || '' || EOL;
2258:

Line 2279: FROM dual;

2275: to_number(l_rl2_box_k) <> 0 THEN
2276:
2277: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_k),l_format_mask)))
2278: INTO l_formatted_box
2279: FROM dual;
2280:
2281: tab_employee(lK_RevenuApresDeces ) := '' ||
2282: l_formatted_box || '' || EOL;
2283:

Line 2304: FROM dual;

2300: to_number(l_rl2_box_l) <> 0 THEN
2301:
2302: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_l),l_format_mask)))
2303: INTO l_formatted_box
2304: FROM dual;
2305:
2306: tab_employee(lL_RetraitREEP ) := '' ||
2307: l_formatted_box || '' || EOL;
2308:

Line 2329: FROM dual;

2325: to_number(l_rl2_box_m) <> 0 THEN
2326:
2327: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_m),l_format_mask)))
2328: INTO l_formatted_box
2329: FROM dual;
2330:
2331: tab_employee(lM_LibereImpot) := '' ||
2332: l_formatted_box || '' || EOL;
2333:

Line 2372: FROM dual;

2368: to_number(l_rl2_box_o) <> 0 THEN
2369:
2370: SELECT ltrim(rtrim(to_char(to_number(l_rl2_box_o),l_format_mask)))
2371: INTO l_formatted_box
2372: FROM dual;
2373:
2374: tab_employee(lO_RetraitRAP ) := '' ||
2375: l_formatted_box || '' || EOL;
2376:

Line 2500: FROM dual;

2496: if rec.value is not null then
2497: if(rec.code <> '201' and to_number(rec.value) <> 0) then
2498: SELECT ltrim(rtrim(to_char(rec.value,l_format_mask)))
2499: INTO l_formatted_box
2500: FROM dual;
2501:
2502: select decode(rec.code,'235','F_2','210','F_3',replace(rec.code,'-','_')) --Bug 14701748
2503: into l_formatted_code
2504: from dual;

Line 2504: from dual;

2500: FROM dual;
2501:
2502: select decode(rec.code,'235','F_2','210','F_3',replace(rec.code,'-','_')) --Bug 14701748
2503: into l_formatted_code
2504: from dual;
2505: l_other_details:=l_other_details||'<'||l_formatted_code||'>'
2506: ||l_formatted_box||''||EOL;
2507: elsif rec.code = '201' then
2508: l_other_details:=l_other_details||''

Line 2648: FROM dual;

2644: if ( counter <= 4 ) then
2645: if(l_further_code(l_i) <> '201' and to_number(l_further_amount(l_i)) <> 0) then
2646: SELECT ltrim(rtrim(to_char(l_further_amount(l_i),l_format_mask)))
2647: INTO l_formatted_box
2648: FROM dual;
2649:
2650:
2651: further_info_details:= further_info_details || '' ||EOL ||
2652: '' || l_further_code(l_i) || '' ||EOL ||

Line 2731: FROM dual;

2727: if l_further_amount(l_i) is not null then
2728: if(l_further_code(l_i) <> '201' and to_number(l_further_amount(l_i)) <> 0) then
2729: SELECT ltrim(rtrim(to_char(l_further_amount(l_i),l_format_mask)))
2730: INTO l_formatted_box
2731: FROM dual;
2732:
2733:
2734: further_info_details:= further_info_details || '' ||EOL ||
2735: '' || l_further_code(l_i) || '' ||EOL ||

Line 2896: FROM dual;

2892:
2893: SELECT
2894: fnd_global.local_chr(13) || fnd_global.local_chr(10)
2895: INTO EOL
2896: FROM dual;
2897:
2898: lAnnee := 1;
2899: lNbReleves := 2;
2900: lNold := 3;