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.PSP_SUM_ADJ dependencies on PSP_PAYROLL_CONTROLS

Line 190: FROM psp_payroll_controls ppc,

186: p_return_status OUT NOCOPY VARCHAR2) IS
187: --- replaced p_run_type with g_run_type for 244657
188: CURSOR pc_batch_cur IS
189: SELECT distinct ppc.batch_name
190: FROM psp_payroll_controls ppc,
191: psp_adjustment_control_table pact
192: WHERE ppc.status_code = decode(g_run_type, 'N', 'N', 'R', 'I')
193: AND ppc.source_type = 'A'
194: AND ppc.batch_name = pact.adjustment_batch_name

Line 213: FROM psp_payroll_controls

209: payroll_source_code,
210: time_period_id,
211: batch_name,
212: gms_phase
213: FROM psp_payroll_controls
214: WHERE source_type = 'A'
215: AND ((adj_sum_batch_name is null) OR
216: (adj_sum_batch_name is not null and run_id is not null))
217: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)

Line 226: from psp_payroll_controls

222:
223: --- added cursor for 2444657
224: CURSOR derive_run_mode IS
225: select decode(count(*), 0, 'N', 'R')
226: from psp_payroll_controls
227: where source_type = 'A'
228: and adj_sum_batch_name = p_adj_sum_batch_name
229: and status_code = 'I';
230:

Line 233: FROM psp_payroll_controls

229: and status_code = 'I';
230:
231: CURSOR batch_name_exist_cur IS
232: SELECT count(*)
233: FROM psp_payroll_controls
234: WHERE adj_sum_batch_name = p_adj_sum_batch_name
235: AND source_type = 'A' -- Bug 2133056
236: AND g_run_type <> 'R';
237:

Line 319: UPDATE psp_payroll_controls

315: CLOSE payroll_control_cur;
316: EXIT;
317: else
318: if g_run_type = 'N' then
319: UPDATE psp_payroll_controls
320: SET status_code = 'I',
321: adj_sum_batch_name = p_adj_sum_batch_name,
322: run_id = g_run_id
323: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;

Line 325: UPDATE psp_payroll_controls

321: adj_sum_batch_name = p_adj_sum_batch_name,
322: run_id = g_run_id
323: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
324: else
325: UPDATE psp_payroll_controls
326: SET run_id = g_run_id
327: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
328: end if;
329: end if;

Line 350: FROM psp_payroll_controls

346: p_return_status OUT NOCOPY VARCHAR2) IS
347:
348: CURSOR pc_batch_cur IS
349: SELECT distinct batch_name
350: FROM psp_payroll_controls
351: WHERE source_type = 'A'
352: AND adj_sum_batch_name = p_adj_sum_batch_name
353: AND (dist_dr_amount is not null or dist_cr_amount is not null)
354: -- AND (gl_phase = 'GL_Tie_Back' OR gms_phase = 'GMS_Tie_Back') : Bug 1776606 : Commented out

Line 373: FROM psp_payroll_controls

369: time_period_id,
370: batch_name,
371: gl_phase,
372: gms_phase
373: FROM psp_payroll_controls
374: WHERE source_type = 'A'
375: AND batch_name = p_batch_name
376: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
377: AND status_code = 'I'

Line 447: FROM psp_payroll_controls

443: -- WHERE batch_name = g_gms_batch_name
444: WHERE batch_name IN (SELECT GMS_BATCH_NAME
445: FROM psp_summary_lines
446: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
447: FROM psp_payroll_controls
448: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
449: ---AND transaction_status_code = 'A' delete 'R' also, for 2445196
450: AND transaction_source in ('OLD', 'GOLD');
451:

Line 458: FROM psp_payroll_controls

454: -- where batch_name = g_gms_batch_name
455: WHERE batch_name IN (SELECT GMS_BATCH_NAME
456: FROM psp_summary_lines
457: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
458: FROM psp_payroll_controls
459: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
460: and transaction_source = 'GOLD';
461:
462: OPEN pc_batch_cur;

Line 491: UPDATE psp_payroll_controls

487: FETCH adj_lines_cur INTO l_adj_count;
488: CLOSE adj_lines_cur;
489:
490: IF (l_sum_count =0) and (l_adj_count =0) THEN
491: UPDATE psp_payroll_controls
492: SET status_code = 'P'
493: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
494: END IF;
495:

Line 519: FROM psp_payroll_controls

515: p_return_status OUT NOCOPY VARCHAR2) IS
516:
517: CURSOR pc_batch_cur IS
518: SELECT distinct batch_name
519: FROM psp_payroll_controls
520: WHERE source_type = 'A'
521: AND status_code = 'I'
522: AND run_id = nvl(g_run_id, run_id)
523: AND gl_phase is null

Line 538: FROM psp_payroll_controls

534: payroll_source_code,
535: time_period_id,
536: batch_name,
537: gl_posting_override_date
538: FROM psp_payroll_controls
539: WHERE batch_name = p_batch_name
540: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
541: AND source_type = 'A'
542: AND status_code = 'I'

Line 715: update psp_payroll_controls

711: FETCH gl_sum_lines_cursor INTO gl_sum_lines_rec;
712: l_rec_count := l_rec_count + 1;
713: IF gl_sum_lines_cursor%NOTFOUND THEN
714: if (l_rec_count > 1) then
715: update psp_payroll_controls
716: set gl_phase = 'Summarize_GL_Lines'
717: where payroll_control_id = payroll_control_rec.payroll_control_id;
718: end if;
719: CLOSE gl_sum_lines_cursor;

Line 1096: FROM psp_payroll_controls

1092: p_return_status OUT NOCOPY VARCHAR2) IS
1093:
1094: CURSOR pc_batch_cur IS
1095: SELECT distinct batch_name
1096: FROM psp_payroll_controls
1097: WHERE adj_sum_batch_name = p_adj_sum_batch_name
1098: AND source_type = 'A'
1099: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
1100: AND status_code = 'I'

Line 1115: FROM psp_payroll_controls

1111: time_period_id,
1112: batch_name,
1113: -- Introduced for bug fix 2916848
1114: currency_code
1115: FROM psp_payroll_controls
1116: WHERE batch_name = p_batch_name
1117: AND source_type = 'A'
1118: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
1119: AND status_code = 'I'

Line 1422: update psp_payroll_controls

1418: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1419: fnd_msg_pub.add;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSE
1422: update psp_payroll_controls
1423: set gl_phase = 'Submitted_Import_Request'
1424: --where payroll_control_id = gl_batch_rec.payroll_control_id; Replaced this line for Bug 2133056
1425: where source_type = 'A'
1426: and batch_name = pc_batch_rec.batch_name;

Line 1552: FROM psp_payroll_controls

1548: p_return_status OUT NOCOPY VARCHAR2) IS
1549:
1550: CURSOR pc_batch_cur IS
1551: SELECT distinct batch_name
1552: FROM psp_payroll_controls
1553: WHERE adj_sum_batch_name = p_adj_sum_batch_name
1554: AND (dist_dr_amount is not null and dist_cr_amount is not null)
1555: AND source_type = 'A'
1556: AND status_code = 'I'

Line 1580: FROM psp_payroll_controls

1576:
1577: CURSOR gl_tie_back_cur(p_batch_name IN VARCHAR2) IS
1578: SELECT payroll_control_id,
1579: source_type
1580: FROM psp_payroll_controls
1581: WHERE batch_name = p_batch_name
1582: AND (dist_dr_amount is not null and dist_cr_amount is not null)
1583: AND source_type = 'A'
1584: AND status_code = 'I'

Line 1642: psp_payroll_controls PPC

1638: -- Included the following cursors here for accessing local varibales for bug fix 1765678
1639: CURSOR summary_group_cur IS
1640: SELECT PSL.group_id
1641: FROM psp_summary_lines PSL,
1642: psp_payroll_controls PPC
1643: WHERE PPC.payroll_control_id = PSL.payroll_control_id
1644: -- WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id
1645: AND PPC.batch_name = pc_batch_rec.batch_name
1646: AND PPC.source_type = 'A'

Line 1698: update psp_payroll_controls

1694: END IF;
1695: CLOSE gl_interface_status_cur;
1696:
1697: if l_status_new > 0 then
1698: update psp_payroll_controls
1699: set gl_phase = 'Summarize_GL_Lines'
1700: where gl_phase = 'Submitted_Import_Request'
1701: and batch_name = pc_batch_rec.batch_name; --- 3184075
1702: ---and adj_sum_batch_name = p_adj_sum_batch_name;

Line 1728: UPDATE psp_payroll_controls

1724: IF gl_tie_back_cur%NOTFOUND then
1725: CLOSE gl_tie_back_cur;
1726: EXIT;
1727: END IF;
1728: UPDATE psp_payroll_controls
1729: SET gl_phase = 'GL_Tie_Back'
1730: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1731:
1732: -- Replaced the earlier 'select stmt.' code with new 'cursor' code for bug fix 1765678

Line 1825: UPDATE psp_payroll_controls

1821: AND summary_line_id = l_summary_line_id;
1822:
1823: END LOOP;
1824:
1825: UPDATE psp_payroll_controls
1826: SET gl_dr_amount = nvl(gl_dr_amount,0) + l_dr_summary_amount,
1827: gl_cr_amount = nvl(gl_cr_amount,0) + l_cr_summary_amount
1828: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1829:

Line 1942: FROM psp_payroll_controls

1938: (l_control_rec_credit <> l_control_rec_debit) then /* Bug 1977893 */
1939: IF p_source_type = 'A' THEN
1940:
1941: SELECT payroll_id INTO l_payroll_id
1942: FROM psp_payroll_controls
1943: WHERE payroll_control_id = p_payroll_control_id;
1944:
1945: BEGIN
1946: -- Replaced the earlier 'select stmt.' code with new 'cursor' code , inserted new code for bug fix 1765678

Line 2244: FROM psp_payroll_controls

2240: p_return_status OUT NOCOPY VARCHAR2) IS
2241:
2242: CURSOR pc_batch_cur IS
2243: SELECT distinct batch_name
2244: FROM psp_payroll_controls
2245: WHERE adj_sum_batch_name = p_adj_sum_batch_name
2246: AND source_type = 'A'
2247: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2248: AND status_code = 'I'

Line 2262: FROM psp_payroll_controls

2258: source_type,
2259: payroll_source_code,
2260: time_period_id,
2261: batch_name
2262: FROM psp_payroll_controls
2263: WHERE batch_name = p_batch_name
2264: AND source_type = 'A'
2265: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2266: AND status_code = 'I'

Line 2445: UPDATE psp_payroll_controls

2441: l_rec_count := l_rec_count + 1;
2442: IF gms_sum_lines_cursor%NOTFOUND THEN
2443: if (l_rec_count > 1 ) then
2444: g_gms_avail := 'Y';
2445: UPDATE psp_payroll_controls
2446: SET gms_phase = 'Summarize_GMS_Lines'
2447: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
2448: end if;
2449: CLOSE gms_sum_lines_cursor;

Line 2686: FROM psp_payroll_controls

2682: p_return_status OUT NOCOPY VARCHAR2) IS
2683:
2684: CURSOR pc_batch_cur IS
2685: SELECT distinct batch_name
2686: FROM psp_payroll_controls
2687: WHERE adj_sum_batch_name = p_adj_sum_batch_name
2688: AND source_type = 'A'
2689: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2690: AND gms_phase = 'Summarize_GMS_Lines'

Line 2706: FROM psp_payroll_controls

2702: time_period_id,
2703: batch_name,
2704: -- Introduced the following for bug fix 2916848
2705: currency_code
2706: FROM psp_payroll_controls
2707: WHERE batch_name = p_batch_name
2708: AND source_type = 'A'
2709: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2710: AND gms_phase = 'Summarize_GMS_Lines'

Line 2859: FROM psp_payroll_controls ppc,

2855: call_status_tab call_status_type;
2856:
2857: CURSOR operating_unit_csr IS
2858: SELECT distinct org_id
2859: FROM psp_payroll_controls ppc,
2860: psp_summary_lines psl
2861: WHERE ppc.payroll_control_id = psl.payroll_control_id
2862: AND ppc.adj_sum_batch_name = p_adj_sum_batch_name
2863: AND ppc.source_type = 'A'

Line 3007: -- UPDATE psp_payroll_controls

3003: LOOP
3004: FETCH gms_interface_cursor INTO gms_interface_rec;
3005: IF gms_interface_cursor%NOTFOUND THEN
3006: -- if (l_rec_count > 0) then
3007: -- UPDATE psp_payroll_controls
3008: -- SET gms_phase = 'Transfer_GMS_Lines'
3009: -- WHERE payroll_control_id = gms_batch_rec.payroll_control_id;
3010: -- end if;
3011: CLOSE gms_interface_cursor;

Line 3286: update psp_payroll_controls

3282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3283:
3284: -- ELSE
3285: /***** Converted the following statement into BULK FETCH for R12 performance fixes (bug 4507892)
3286: update psp_payroll_controls
3287: set gms_phase = 'Submitted_Import_Request'
3288: -- where gms_phase = 'Transfer_GMS_Lines'
3289: where payroll_control_id in
3290: (select distinct payroll_control_id

Line 3305: UPDATE psp_payroll_controls

3301: FETCH payroll_control_id_cur BULK COLLECT INTO r_payroll_controls.payroll_control_id;
3302: CLOSE payroll_control_id_cur;
3303:
3304: FORALL I IN 1..r_payroll_controls.payroll_control_id.COUNT
3305: UPDATE psp_payroll_controls
3306: SET gms_phase = 'Submitted_Import_Request'
3307: WHERE payroll_control_id = r_payroll_controls.payroll_control_id(I);
3308: Commit;
3309:

Line 3359: FROM psp_payroll_controls

3355: p_return_status OUT NOCOPY VARCHAR2) IS
3356:
3357: CURSOR pc_batch_cur IS
3358: SELECT distinct batch_name
3359: FROM psp_payroll_controls
3360: WHERE adj_sum_batch_name = p_adj_sum_batch_name
3361: AND (dist_dr_amount is not null and dist_cr_amount is not null)
3362: AND source_type = 'A'
3363: AND status_code = 'I'

Line 3377: FROM psp_payroll_controls

3373: source_type,
3374: payroll_source_code,
3375: time_period_id,
3376: batch_name
3377: FROM psp_payroll_controls
3378: WHERE batch_name = p_batch_name
3379: AND (dist_dr_amount is not null and dist_cr_amount is not null)
3380: AND source_type = 'A'
3381: AND status_code = 'I'

Line 3557: update psp_payroll_controls

3553: where gms_batch_name = l_gms_batch_name
3554: and payroll_control_id = gms_tie_back_rec.payroll_control_id;
3555: */
3556: -- Added following update for 2133056
3557: update psp_payroll_controls
3558: set gms_phase = 'Summarize_GMS_Lines'
3559: where gms_phase is not null
3560: and adj_sum_batch_name = p_adj_sum_batch_name;
3561:

Line 3617: from psp_payroll_controls

3613:
3614: delete psp_summary_lines
3615: where payroll_control_id in
3616: (select payroll_control_id
3617: from psp_payroll_controls
3618: where source_type = 'A'
3619: and adj_sum_batch_name = p_adj_sum_batch_name);
3620:
3621: update psp_payroll_controls

Line 3621: update psp_payroll_controls

3617: from psp_payroll_controls
3618: where source_type = 'A'
3619: and adj_sum_batch_name = p_adj_sum_batch_name);
3620:
3621: update psp_payroll_controls
3622: set gms_phase = null
3623: where gms_phase is not null
3624: and source_type = 'A'
3625: and adj_sum_batch_name = p_adj_sum_batch_name;

Line 3740: update psp_payroll_controls

3736: -- fnd_message.set_token('ERR_NAME', l_trx_rejection_code);
3737: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3738: fnd_msg_pub.add;
3739: /* 1685685 added update statement...to clean pa tables in cleanup_batch_details..Venkat.*/
3740: update psp_payroll_controls
3741: set gms_phase = 'GMS_Tie_Back'
3742: where payroll_control_id = gms_tie_back_rec.payroll_control_id;
3743: cleanup_batch_details(gms_tie_back_rec.payroll_control_id,null);
3744: close gms_tie_back_cur;

Line 3779: UPDATE psp_payroll_controls

3775: close gms_tie_back_success_cur;
3776: exit;
3777: ELSIF gms_tie_back_success_cur%NOTFOUND THEN
3778:
3779: UPDATE psp_payroll_controls
3780: SET gms_phase = 'GMS_Tie_Back'
3781: WHERE payroll_control_id = l_control_id;
3782:
3783: CLOSE gms_tie_back_success_cur;

Line 3844: UPDATE psp_payroll_controls

3840: AND transaction_source = l_txn_source; */
3841:
3842: END LOOP; -- End loop for gms_tie_back_success_cur
3843:
3844: UPDATE psp_payroll_controls
3845: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
3846: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
3847: WHERE payroll_control_id = gms_tie_back_rec.payroll_control_id;
3848:

Line 4013: psp_payroll_controls ppc

4009: cursor adj_batch_cur (p_batch_name IN VARCHAR2) IS
4010: select orig_source_type,
4011: orig_line_id
4012: from psp_adjustment_lines pal,
4013: psp_payroll_controls ppc
4014: WHERE ppc.source_type ='A'
4015: AND ppc.batch_name = p_batch_name
4016: AND pal.payroll_control_id = ppc.payroll_control_id
4017: AND pal.reversal_entry_flag IS NULL

Line 4022: psp_payroll_controls ppc

4018: UNION ALL -- added hist table for 2133056
4019: SELECT palh.orig_source_type,
4020: palh.orig_line_id
4021: FROM psp_adjustment_lines_history palh,
4022: psp_payroll_controls ppc
4023: WHERE palh.reversal_entry_flag IS NULL
4024: AND ppc.source_type ='A'
4025: AND ppc.batch_name = p_batch_name
4026: AND palh.payroll_control_id = ppc.payroll_control_id

Line 4034: FROM psp_payroll_controls

4030:
4031: -- Included the following cursors for bug fix 1765678
4032: CURSOR gl_gms_phase_batch_name_cur IS
4033: SELECT gl_phase, gms_phase, batch_name
4034: FROM psp_payroll_controls
4035: WHERE payroll_control_id = p_payroll_control_id;
4036:
4037: -- Tuned following stmt 2133056
4038: CURSOR group_name_cur IS

Line 4081: from psp_payroll_controls

4077: (select to_char(summary_line_id)
4078: from psp_summary_lines
4079: where payroll_control_id in
4080: (select payroll_control_id
4081: from psp_payroll_controls
4082: where batch_name = l_batch_name
4083: and source_type='A'))); ----- Added this delete for Bug 2133056
4084:
4085:

Line 4093: from psp_payroll_controls

4089: (select to_char(summary_line_id)
4090: from psp_summary_lines
4091: where payroll_control_id in
4092: (select payroll_control_id
4093: from psp_payroll_controls
4094: where batch_name = l_batch_name
4095: and source_type='A')); --Added for bug 1685685
4096:
4097: /***********************************************************************

Line 4107: from psp_payroll_controls

4103: (select to_char(summary_line_id)
4104: from psp_summary_lines
4105: where payroll_control_id in
4106: (select payroll_control_id
4107: from psp_payroll_controls
4108: where batch_name = l_batch_name
4109: and source_type = 'A'));
4110: ********************************************************************************/
4111:

Line 4123: from psp_payroll_controls PPC

4119: (select to_char(PSL.summary_line_id)
4120: from psp_summary_lines PSL
4121: where PSL.payroll_control_id in
4122: (select PPC.payroll_control_id
4123: from psp_payroll_controls PPC
4124: where PPC.batch_name=l_batch_name
4125: and PPC.source_type='A')))
4126: and 0 = (select count(*)
4127: from pa_expenditure_items_all ITEMS

Line 4140: from psp_payroll_controls

4136: (select to_char(summary_line_id)
4137: from psp_summary_lines
4138: where payroll_control_id in
4139: (select payroll_control_id
4140: from psp_payroll_controls
4141: where batch_name = l_batch_name
4142: and source_type = 'A'));
4143: ******************************************************************************/
4144: -- 1662816 start

Line 4199: FROM psp_payroll_controls ppc

4195:
4196: delete from psp_adjustment_lines_history
4197: where payroll_control_id in --- Corrected this statment 2133056
4198: ( SELECT ppc.payroll_control_id
4199: FROM psp_payroll_controls ppc
4200: WHERE ppc.batch_name = l_batch_name
4201: AND ppc.source_type = 'A');
4202:
4203:

Line 4209: from psp_payroll_controls

4205: where batch_name = l_batch_name;
4206:
4207: delete from psp_summary_lines
4208: where payroll_control_id in (select payroll_control_id
4209: from psp_payroll_controls
4210: where batch_name = l_batch_name
4211: and source_type = 'A'); --- added this condn 2133056
4212:
4213: delete from psp_payroll_controls

Line 4213: delete from psp_payroll_controls

4209: from psp_payroll_controls
4210: where batch_name = l_batch_name
4211: and source_type = 'A'); --- added this condn 2133056
4212:
4213: delete from psp_payroll_controls
4214: where batch_name = l_batch_name and
4215: source_type = 'A'; --- added this condn 2133056
4216:
4217: delete from psp_adjustment_control_table

Line 4230: FROM psp_payroll_controls

4226: PROCEDURE check_interface_status(p_target_name IN VARCHAR2,
4227: p_adj_sum_batch_name IN VARCHAR2) IS
4228: CURSOR pc_batch_cur IS
4229: SELECT distinct batch_name
4230: FROM psp_payroll_controls
4231: WHERE source_type = 'A'
4232: AND adj_sum_batch_name = p_adj_sum_batch_name
4233: AND status_code = 'I';
4234:

Line 4237: FROM psp_payroll_controls

4233: AND status_code = 'I';
4234:
4235: CURSOR payroll_control_cur(p_batch_name IN VARCHAR2) IS
4236: SELECT payroll_control_id
4237: FROM psp_payroll_controls
4238: WHERE batch_name = p_batch_name
4239: AND status_code = 'I'
4240: AND decode(p_target_name, 'GL', gl_phase, gms_phase) = 'Submitted_Import_Request'
4241: AND source_type = 'A';

Line 4325: update psp_payroll_controls

4321: END IF;
4322: CLOSE gl_interface_status_cur;
4323:
4324: if l_status_new > 0 then
4325: update psp_payroll_controls
4326: set gl_phase = 'Summarize_GL_Lines'
4327: where gl_phase = 'Submitted_Import_Request'
4328: and payroll_control_id = payroll_control_rec.payroll_control_id;
4329:

Line 4364: update psp_payroll_controls

4360: END IF;
4361: CLOSE pa_txn_int_status_p_cur;
4362:
4363: if (l_status_p > 0) then
4364: update psp_payroll_controls
4365: set gms_phase = NULL
4366: where payroll_control_id = payroll_control_rec.payroll_control_id
4367: and gms_phase = 'Submitted_Import_Request';
4368:

Line 4431: l_currency_code psp_payroll_controls.currency_code%TYPE;

4427: l_distribution_start_date DATE;
4428: l_distribution_end_date DATE;
4429: l_person_name VARCHAR2(80);
4430: l_error VARCHAR2(200);
4431: l_currency_code psp_payroll_controls.currency_code%TYPE;
4432:
4433: -- Included the following cursors here for accessing local variables for bug fix 1765678
4434: CURSOR adjustment_control_cur IS
4435: SELECT adjustment_batch_name, person_id, assignment_id, element_type_id,