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

Line 163: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

159: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
160: -- retro salary diff(adjusted amount to pay actually)
161: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)
162: nvl(sum(decode(FEED.balance_type_id,
163: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
164: * FEED.scale
165: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_3,1,0)
166: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,-1,0)))),0),
167: nvl(sum(decode(FEED.balance_type_id,

Line 168: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

164: * FEED.scale
165: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_3,1,0)
166: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,-1,0)))),0),
167: nvl(sum(decode(FEED.balance_type_id,
168: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
169: * FEED.scale
170: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_2,1,0)
171: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,-1,0)))),0),
172: nvl(sum(decode(FEED.balance_type_id,

Line 173: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

169: * FEED.scale
170: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_2,1,0)
171: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,-1,0)))),0),
172: nvl(sum(decode(FEED.balance_type_id,
173: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
174: * FEED.scale
175: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_1,1,0)
176: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,-1,0)))),0),
177: -- retro salary paid(actual paid retro salary at the month)(PACT)

Line 179: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

175: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_1,1,0)
176: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,-1,0)))),0),
177: -- retro salary paid(actual paid retro salary at the month)(PACT)
178: nvl(sum(decode(FEED.balance_type_id,
179: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
180: * FEED.scale
181: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,1))),0),
182: nvl(sum(decode(FEED.balance_type_id,
183: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

Line 183: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

179: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
180: * FEED.scale
181: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,1))),0),
182: nvl(sum(decode(FEED.balance_type_id,
183: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
184: * FEED.scale
185: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,1))),0),
186: nvl(sum(decode(FEED.balance_type_id,
187: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

Line 187: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

183: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
184: * FEED.scale
185: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,1))),0),
186: nvl(sum(decode(FEED.balance_type_id,
187: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)
188: * FEED.scale
189: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,1))),0),
190: -- retro salary materials diff
191: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)

Line 193: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

189: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,1))),0),
190: -- retro salary materials diff
191: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)
192: nvl(sum(decode(FEED.balance_type_id,
193: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
194: * FEED.scale
195: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_3,1,0)
196: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,-1,0)))),0),
197: nvl(sum(decode(FEED.balance_type_id,

Line 198: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

194: * FEED.scale
195: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_3,1,0)
196: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,-1,0)))),0),
197: nvl(sum(decode(FEED.balance_type_id,
198: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
199: * FEED.scale
200: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_2,1,0)
201: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,-1,0)))),0),
202: nvl(sum(decode(FEED.balance_type_id,

Line 203: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

199: * FEED.scale
200: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_2,1,0)
201: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,-1,0)))),0),
202: nvl(sum(decode(FEED.balance_type_id,
203: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
204: * FEED.scale
205: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_1,1,0)
206: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,-1,0)))),0),
207: -- retro salary materials paid(actual paid retro salary at the month)(PACT)

Line 209: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

205: * (decode(to_char(BACT.effective_date,'YYYY-MM'),l_apply_mth_1,1,0)
206: + decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,-1,0)))),0),
207: -- retro salary materials paid(actual paid retro salary at the month)(PACT)
208: nvl(sum(decode(FEED.balance_type_id,
209: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
210: * FEED.scale
211: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,1))),0),
212: nvl(sum(decode(FEED.balance_type_id,
213: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

Line 213: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

209: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
210: * FEED.scale
211: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_3,1))),0),
212: nvl(sum(decode(FEED.balance_type_id,
213: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
214: * FEED.scale
215: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,1))),0),
216: nvl(sum(decode(FEED.balance_type_id,
217: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

Line 217: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)

213: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
214: * FEED.scale
215: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_2,1))),0),
216: nvl(sum(decode(FEED.balance_type_id,
217: g_material_id,fnd_number.canonical_to_number(TARGET.result_value)
218: * FEED.scale
219: * decode(to_char(PACT.effective_date,'YYYY-MM'),l_apply_mth_1,1))),0),
220: -- Minimum Action Sequence of Retro assact(not Target assact)
221: min(decode(balance_type_id, g_sal_id, BACT.effective_date, g_material_id, BACT.effective_date)),

Line 302: nvl(sum(fnd_number.canonical_to_number(target.result_value)),0)

298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
301: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
302: nvl(sum(fnd_number.canonical_to_number(target.result_value)),0)
303: INTO g_retro_diff_value
304: FROM pay_assignment_actions BACT_ASSACT,
305: pay_entry_process_details PEPD,
306: pay_payroll_actions BACT,