[Home] [Help]
200: pdl.attribute8,
201: pdl.attribute9,
202: pdl.attribute10
203: from psp_summary_lines psl,
204: psp_distribution_lines_history pdl,
205: psp_payroll_lines ppl,
206: psp_payroll_sub_lines ppsl
207: where pdl.summary_line_id = psl.summary_line_id
208: and pdl.reversal_entry_flag is null
492: l_adj_dff_flag := 'Y';
493: else
494: l_adj_dff_flag := 'N';
495: end if;
496: INSERT INTO PSP_DISTRIBUTION_LINES(
497: DISTRIBUTION_LINE_ID,
498: PAYROLL_SUB_LINE_ID,
499: DISTRIBUTION_DATE,
500: EFFECTIVE_DATE,
521: CAP_EXCESS_TASK_ID,
522: CAP_EXCESS_EXP_ORG_ID,
523: CAP_EXCESS_EXP_TYPE)
524: VALUES(
525: PSP_DISTRIBUTION_LINES_S.NEXTVAL,
526: payroll_rec.PAYROLL_SUB_LINE_ID,
527: L_payroll_start_DATE,
528: L_EFFECTIVE_DATE,
529: L_DIST_AMOUNT,
662: END LOOP;
663:
664: if payroll_rec.pay_amount <> g_tot_dist_amount
665: then
666: UPDATE psp_distribution_lines
667: SET distribution_amount = distribution_amount +
668: (payroll_rec.pay_amount - g_tot_dist_amount)
669: WHERE distribution_line_id = (select max(distribution_line_id) -- 2470954 added this SQL
670: from psp_distribution_lines
666: UPDATE psp_distribution_lines
667: SET distribution_amount = distribution_amount +
668: (payroll_rec.pay_amount - g_tot_dist_amount)
669: WHERE distribution_line_id = (select max(distribution_line_id) -- 2470954 added this SQL
670: from psp_distribution_lines
671: where payroll_rec.payroll_sub_line_id = payroll_sub_line_id);
672: end if;
673: -- total of pay_amout to check at the end for the
674: -- difference amount
1010: IF l_gl_code_combination_id IS NOT NULL THEN
1011: -- l_effective_date := p_effective_date; Bug 1874696
1012: l_gl_project_flag := 'G';
1013:
1014: -- insert the record in psp_distribution_lines
1015: insert_into_distribution_lines(
1016: P_SUB_LINE_ID, -- payroll sub-lines id
1017: P_PAYROLL_START_DATE, -- distribution date
1018: g_gl_EFFECTIVE_DATE, -- replaced p_effective_date -- Bug 2663344
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF; */
1208: l_gl_project_flag := 'P';
1209:
1210: -- insert the record in psp_distribution_lines
1211: insert_into_distribution_lines(
1212: P_SUB_LINE_ID, -- payroll sub-lines id
1213: P_PAYROLL_START_DATE, -- distribution date
1214: P_EFFECTIVE_DATE, -- effective date changed from l_effective_date Bug 1874696
1540: IF l_gl_code_combination_id IS NOT NULL THEN
1541: -- l_effective_date := p_effective_date; Bug 1874696
1542: l_gl_project_flag := 'G';
1543:
1544: -- insert the record in psp_distribution_lines
1545: insert_into_distribution_lines(
1546: P_SUB_LINE_ID, -- payroll sub-lines id
1547: P_PAYROLL_START_DATE, -- distribution date
1548: G_GL_EFFECTIVE_DATE, -- changed from p_effective_date Bug 2663344
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END IF; */
1744: l_gl_project_flag := 'P';
1745:
1746: -- insert the record in psp_distribution_lines
1747: insert_into_distribution_lines(
1748: P_SUB_LINE_ID, -- payroll sub-lines id
1749: P_PAYROLL_START_DATE, -- distribution date
1750: P_EFFECTIVE_DATE, -- effective date Changed from l_effective_date Bug 1874696
2136: ELSIF l_gl_code_combination_id IS NULL THEN
2137: --IF g_auto_population = 'Y' THEN
2138:
2139: IF (g_asg_ele_group_autopop = 'Y')THEN --- 5080403
2140: -- insert the record in psp_distribution_lines bug 2023955
2141: l_gl_project_flag:='P';
2142:
2143: insert_into_distribution_lines(
2144: P_SUB_LINE_ID, -- payroll sub-lines id
2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2329: END IF; */
2330: l_gl_project_flag := 'P';
2331:
2332: -- insert the record in psp_distribution_lines
2333: insert_into_distribution_lines(
2334: P_SUB_LINE_ID, -- payroll sub-lines id
2335: P_PAYROLL_START_DATE, -- distribution date
2336: P_EFFECTIVE_DATE, -- effective date Changed from l_effective_date Bug 1874696
2668: IF l_gl_code_combination_id IS NOT NULL THEN
2669: --- l_effective_date := p_effective_date; 1874696
2670: l_gl_project_flag := 'G';
2671:
2672: -- insert the record in psp_distribution_lines
2673: insert_into_distribution_lines(
2674: P_SUB_LINE_ID, -- payroll sub-lines id
2675: P_PAYROLL_START_DATE, -- distribution date
2676: G_GL_EFFECTIVE_DATE, -- changed fron p_effective date --- Bug 2663344
2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2876: END IF; */
2877: l_gl_project_flag := 'P';
2878:
2879: -- insert the record in psp_distribution_lines
2880: insert_into_distribution_lines(
2881: P_SUB_LINE_ID, -- payroll sub-line_id
2882: P_PAYROLL_START_DATE, -- distribution date
2883: P_EFFECTIVE_DATE, -- effective date Bug 1874696 Changed from l_Effective_date
3214: IF l_gl_code_combination_id IS NOT NULL THEN
3215: --- l_effective_date := p_effective_date; Bug 1874696
3216: l_gl_project_flag := 'G';
3217:
3218: -- insert the record in psp_distribution_lines
3219: hr_utility.trace('inserting dist line for g_org_schedule_autopop ='||g_org_schedule_autopop);
3220: insert_into_distribution_lines(
3221: P_SUB_LINE_ID, -- payroll sub-lines id
3222: P_PAYROLL_START_DATE, -- distribution date
3269:
3270: -- bug fix 2023955
3271: l_gl_project_flag:='P';
3272:
3273: ---- Insert the record into psp_distribution_lines
3274:
3275: insert_into_distribution_lines(
3276: P_SUB_LINE_ID, -- payroll sub-lines id
3277: P_PAYROLL_START_DATE, -- distribution date
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3425: END IF; */
3426: l_gl_project_flag := 'P';
3427:
3428: -- insert the record in psp_distribution_lines
3429: insert_into_distribution_lines(
3430: P_SUB_LINE_ID, -- payroll sub-lines id
3431: P_PAYROLL_START_DATE, -- distribution date
3432: P_EFFECTIVE_DATE, -- effective date Bug 1874696
3703: IF l_gl_code_combination_id IS NOT NULL THEN
3704: --l_effective_date := p_effective_date; commented for bug 1874696
3705: l_gl_project_flag := 'G';
3706:
3707: -- insert the record in psp_distribution_lines
3708: insert_into_distribution_lines(
3709: P_SUB_LINE_ID, -- payroll sub-lines id
3710: P_PAYROLL_START_DATE, -- distribution date
3711: G_GL_EFFECTIVE_DATE, -- effective date Changed from p_effective_date Bug 2663344
3905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3906: END IF; */
3907: l_gl_project_flag := 'P';
3908:
3909: -- insert the record in psp_distribution_lines
3910: insert_into_distribution_lines(
3911: P_SUB_LINE_ID, -- payroll sub-lines id
3912: P_PAYROLL_START_DATE, -- distribution date
3913: P_EFFECTIVE_DATE, -- effective date Bug 1874696 changed from l_Effective_date
4241: if p_dist_line_id is not null then
4242: -- commented first check and introduced above for bug fix 2463092
4243: hr_utility.trace('CDL process --> suspense account --> dist line not null ='||p_dist_line_id);
4244:
4245: update psp_distribution_lines set
4246: suspense_org_account_id = l_organization_account_id,
4247: suspense_reason_code= p_suspense_reason_code,
4248: gl_project_flag = l_gl_project_flag,
4249: effective_date = g_gl_effective_date, --- added for 2663344
4261: where distribution_line_id = p_dist_line_id;
4262:
4263: else
4264:
4265: -- insert rows into psp_distribution_lines
4266: insert_into_distribution_lines(
4267: P_SUB_LINE_ID, -- payroll sub-lines id
4268: P_PAYROLL_START_DATE, -- distribution date
4269: G_GL_EFFECTIVE_DATE, -- effective_date changed from p_Effective_date Bug 2663344
4356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: END IF;
4359: else
4360: update psp_distribution_lines set
4361: suspense_reason_code= p_suspense_reason_code,
4362: suspense_org_Account_id= l_organization_account_id,
4363: gl_project_flag = l_gl_project_flag,
4364: effective_date = p_effective_date,
4471:
4472: -- commented above and introduced if condition below for bug fix 2463092
4473:
4474: if p_dist_line_id is not null then
4475: update psp_distribution_lines set
4476: suspense_reason_code= p_suspense_reason_code,
4477: suspense_org_Account_id= l_organization_account_id,
4478: gl_project_flag = l_gl_project_flag,
4479: effective_date = p_effective_date, --- added for 2663344
4492:
4493:
4494:
4495: else
4496: -- insert rows into psp_distribution_lines
4497: insert_into_distribution_lines(
4498: P_SUB_LINE_ID, -- payroll sub-lines id
4499: P_PAYROLL_START_DATE, -- distribution date
4500: P_EFFECTIVE_DATE, -- effective_date Bug 1874696
4712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4713: END IF;
4714:
4715: ELSIF l_auto_pop_status = FND_API.G_RET_STS_SUCCESS THEN
4716: -- insert the record in psp_distribution_lines
4717: insert_into_distribution_lines(
4718: P_SUB_LINE_ID, -- payroll sub-lines id
4719: P_PAYROLL_START_DATE, -- distribution date
4720: P_EFFECTIVE_DATE, -- effective date
4921: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4922: -- END IF;
4923: l_gl_project_flag := 'P';
4924:
4925: -- insert the record in psp_distribution_lines
4926: insert_into_distribution_lines(
4927: P_SUB_LINE_ID, -- payroll sub-lines id
4928: P_PAYROLL_START_DATE, -- distribution date
4929: P_EFFECTIVE_DATE, -- effective date, changed from l_Effective_date for 1874696
5053: BEGIN
5054: -- dbms_output.put_line('inserting into dist lines table');
5055: --- inserting into table for PSB mode also, 3813688
5056: g_tot_dist_amount := g_tot_dist_amount + l_distribution_amount;
5057: INSERT INTO PSP_DISTRIBUTION_LINES(
5058: DISTRIBUTION_LINE_ID,
5059: PAYROLL_SUB_LINE_ID,
5060: DISTRIBUTION_DATE,
5061: EFFECTIVE_DATE,
5089: CAP_EXCESS_TASK_ID,
5090: CAP_EXCESS_EXP_ORG_ID,
5091: CAP_EXCESS_EXP_TYPE)
5092: VALUES(
5093: PSP_DISTRIBUTION_LINES_S.NEXTVAL,
5094: L_PAYROLL_SUB_LINE_ID,
5095: L_DISTRIBUTION_DATE,
5096: L_EFFECTIVE_DATE,
5097: L_DISTRIBUTION_AMOUNT,
5151: P_DISTRIBUTION_LINE_ID,
5152: P_NEW_EXPENDITURE_TYPE,
5153: P_NEW_GL_CODE_COMBINATION_ID);
5154: -- ***************************************************************************
5155: UPDATE PSP_DISTRIBUTION_LINES
5156: SET auto_expenditure_type = p_new_expenditure_type,
5157: auto_gl_code_combination_id = p_new_gl_code_combination_id
5158: WHERE distribution_line_id = p_distribution_line_id;
5159:
5388: nvl(poa.expenditure_organization_id,
5389: nvl(peta.expenditure_organization_id,
5390: pdls.expenditure_organization_id))),
5391: poa2.expenditure_organization_id), NULL) exp_org_id
5392: FROM Psp_distribution_lines pdl,
5393: psp_payroll_sub_lines ppsl,
5394: psp_payroll_lines ppl,
5395: psp_schedule_lines psl,
5396: psp_organization_accounts poa,
6089: psl.gl_code_combination_id,
6090: pdl.schedule_line_id schedule_line_id,
6091: ppl.cost_id,
6092: ppl.payroll_action_type
6093: FROM psp_distribution_lines pdl,
6094: psp_payroll_lines ppl,
6095: psp_payroll_sub_lines ppsl,
6096: psp_Schedule_lines psl,
6097: psp_schedule_hierarchy psh
6125:
6126: autopop_exc_rec autopop_exc_cur%ROWTYPE;
6127:
6128: CURSOR dist_line_psl_cur(p_payroll_sub_line_id in number , p_schedule_line_id in number ) is
6129: select distribution_line_id , effective_date, distribution_amount from psp_distribution_lines pdl
6130: where payroll_sub_line_id= p_payroll_sub_line_id and
6131: schedule_line_id= p_schedule_line_id
6132: and suspense_org_account_id is null
6133: order by effective_date;
6338:
6339:
6340: */
6341: -- added following update for 5080403
6342: update psp_distribution_lines set auto_expenditure_type = l_new_expenditure_type
6343: where distribution_line_id=l_dist_line_id;
6344: suspense_account(
6345: x_proc_executed,
6346: autopop_exc_rec.person_id,
6372: else -- linkage status is successful
6373:
6374: --dbms_output.put_line(' linkage status is successful');
6375:
6376: update psp_distribution_lines set auto_expenditure_type = l_new_expenditure_type
6377: where
6378: distribution_line_id=l_dist_line_id;
6379: --- check the above that it is necessary and sufficient
6380: -- commit; ---- after -- to debug -- will be removed later
6388:
6389:
6390: ---dbms_output.put_line(' oops -- this is natural account');
6391:
6392: update psp_distribution_lines set auto_gl_code_combination_id = l_new_gl_code_combination_id
6393: where
6394: payroll_sub_line_id=autopop_exc_rec.payroll_sub_line_id
6395: and schedule_line_id =
6396: autopop_exc_rec.schedule_line_id and suspense_org_account_id is null;
6426: pdls.gl_code_combination_id,
6427: pdls.org_schedule_id,
6428: ppl.cost_id,
6429: ppl.payroll_action_type
6430: FROM psp_distribution_lines pdl,
6431: psp_payroll_lines ppl,
6432: psp_payroll_sub_lines ppsl,
6433: psp_default_labor_schedules pdls
6434: WHERE
6457:
6458: autopop_odls_rec autopop_odls_cur%ROWTYPE;
6459:
6460: CURSOR dist_line_odls_cur(p_payroll_sub_line_id in number ,p_org_schedule_id in number) is
6461: select distribution_line_id , effective_date, distribution_amount from psp_distribution_lines pdl
6462: where payroll_sub_line_id= autopop_odls_rec.payroll_sub_line_id and
6463: org_schedule_id= autopop_odls_rec.org_schedule_id
6464: and suspense_org_account_id is null
6465: order by effective_date;
6685: -- fetch dist_line_odls_cur into l_dist_line_id , l_effective_date, l_dist_amount;
6686:
6687:
6688: --- added for 5080403
6689: update psp_distribution_lines set auto_expenditure_type = l_new_expenditure_type
6690: where distribution_line_id =l_dist_line_id;
6691:
6692: suspense_account(
6693: x_proc_executed,
6717: -- close dist_line_odls_cur;
6718:
6719: else -- linkage status is successful
6720:
6721: update psp_distribution_lines set auto_expenditure_type = l_new_expenditure_type
6722: where
6723: distribution_line_id =l_dist_line_id;
6724: --- check the above that it is necessary and sufficient
6725: -- commit; ---- after -- to debug -- will be removed later
6730: close dist_line_odls_cur;
6731:
6732: else -- if natural account then
6733:
6734: update psp_distribution_lines set auto_gl_code_combination_id = l_new_gl_code_combination_id
6735: where
6736: payroll_sub_line_id=autopop_odls_rec.payroll_sub_line_id
6737: and org_schedule_id =
6738: autopop_odls_rec.org_schedule_id and suspense_org_account_id is null;
6997: pdl.distribution_amount,
6998: pdl.business_group_id,
6999: psl.payroll_sub_line_id,
7000: pdl.distribution_line_id
7001: from psp_distribution_lines pdl,
7002: psp_payroll_sub_lines psl,
7003: psp_payroll_lines ppl
7004: where pdl.gl_projecT_flag = 'P'
7005: and psl.payroll_sub_line_id = pdl.payroll_sub_line_id
7139: psp_payroll_controls ppc,
7140: psp_payroll_lines ppl,
7141: psp_payroll_sub_lines ppsl,
7142: gms_awards_all awd,
7143: psp_distribution_lines pdl
7144: where pdl.status_code = '||''''||'N'||''''||'
7145: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
7146: and ppsl.payroll_line_id = ppl.payroll_line_id
7147: and ppl.payroll_control_id = ppc.payroll_control_id
7192: psp_default_labor_schedules pdls,
7193: psp_payroll_controls ppc,
7194: psp_payroll_lines ppl,
7195: psp_payroll_sub_lines ppsl,
7196: psp_distribution_lines pdl,
7197: gms_awards_all awd
7198: where pdl.status_code = '||''''||'N'||''''||'
7199: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
7200: AND ppsl.payroll_line_id = ppl.payroll_line_id
7322: end loop;
7323:
7324: for i in 1..t_dist_line_id.count
7325: loop
7326: select psp_distribution_lines_s.nextval
7327: into t_excess_line_id(i)
7328: from dual;
7329: end loop;
7330:
7328: from dual;
7329: end loop;
7330:
7331: forall i in 1..t_dist_line_id.count
7332: Insert into psp_distribution_lines(distribution_line_id,
7333: distribution_date,
7334: distribution_amount,
7335: effective_date,
7336: status_code,
7362: exc.expenditure_organization_id,
7363: exc.expenditure_type,
7364: cap_rec.funding_source_code,
7365: cap_rec.annual_salary_cap
7366: from psp_distribution_lines pdl,
7367: psp_organization_accounts exc
7368: where pdl.distribution_line_id = t_dist_line_id(i)
7369: and exc.organization_account_id = t_excess_account(i);
7370:
7368: where pdl.distribution_line_id = t_dist_line_id(i)
7369: and exc.organization_account_id = t_excess_account(i);
7370:
7371: forall i in 1..t_dist_line_id.count
7372: update psp_distribution_lines pdl
7373: set distribution_amount = t_cap_sched_amount(i),
7374: cap_excess_dist_line_id = t_excess_line_id(i),
7375: funding_source_code = cap_rec.funding_source_code,
7376: annual_salary_cap = cap_rec.annual_salary_cap
7520: pdl.cap_excess_award_id award_id,
7521: pdl.cap_excess_glccid gl_code_combination_id,
7522: ppl.cost_id,
7523: ppl.payroll_action_type
7524: from psp_distribution_lines pdl,
7525: psp_payroll_lines ppl,
7526: psp_payroll_sub_lines ppsl
7527: where ppl.payroll_control_id = p_payroll_control_id
7528: and ppl.payroll_line_id = ppsl.payroll_line_id
7557:
7558: select distribution_line_id,
7559: effective_date,
7560: distribution_amount
7561: from psp_distribution_lines pdl
7562: where payroll_sub_line_id = p_payroll_sub_line_id
7563: and (( p_cap_excess_glccid is not null
7564: and p_cap_excess_glccid = pdl.cap_excess_glccid)
7565: or
7763: END IF;
7764:
7765: else -- linkage status is successful
7766:
7767: update psp_distribution_lines set auto_expenditure_type = l_new_expenditure_type
7768: where distribution_line_id=l_dist_line_id;
7769:
7770: end if; -- patc status
7771: end if ; -- dist_line_csr not found;
7773: close dist_line_exc_cur;
7774:
7775: else -- if natural account then
7776:
7777: update psp_distribution_lines set auto_gl_code_combination_id = l_new_gl_code_combination_id
7778: where payroll_sub_line_id = autopop_exc_rec.payroll_sub_line_id
7779: and cap_excess_glccid = autopop_exc_rec.gl_code_combination_id
7780: and suspense_org_account_id is null;
7781:
7811: poa.gl_code_combination_id,
7812: poa.organization_account_id,
7813: ppl.payroll_action_type,
7814: ppl.cost_id
7815: from psp_distribution_lines pdl,
7816: psp_payroll_lines ppl,
7817: psp_payroll_sub_lines ppsl,
7818: psp_organization_accounts poa
7819: where ppl.payroll_control_id = p_payroll_control_id
7852: poa.gl_code_combination_id,
7853: poa.organization_account_id,
7854: ppl.payroll_action_type,
7855: ppl.cost_id
7856: from psp_distribution_lines pdl,
7857: psp_payroll_lines ppl,
7858: psp_payroll_sub_lines ppsl,
7859: psp_organization_accounts poa
7860: where ppl.payroll_control_id = p_payroll_control_id
7892: ele.gl_code_combination_id,
7893: ele.element_account_id,
7894: ppl.payroll_action_type,
7895: ppl.cost_id
7896: from psp_distribution_lines pdl,
7897: psp_payroll_lines ppl,
7898: psp_payroll_sub_lines ppsl,
7899: psp_element_type_accounts ele
7900: where ppl.payroll_control_id = p_payroll_control_id
8030: l_dist_sql_string :=
8031: 'select pdl.distribution_line_id,
8032: pdl.effective_date,
8033: pdl.distribution_amount
8034: from psp_distribution_lines pdl
8035: where pdl.payroll_sub_line_id = :1
8036: and pdl.default_org_account_id = :2
8037: and pdl.suspense_org_account_id is null';
8038: elsif p_schedule_type = 'GLOBAL_ELEMENT' then
8039: l_dist_sql_string :=
8040: 'select pdl.distribution_line_id,
8041: pdl.effective_date,
8042: pdl.distribution_amount
8043: from psp_distribution_lines pdl
8044: where pdl.payroll_sub_line_id = :1
8045: and pdl.element_account_id = :2
8046: and pdl.suspense_org_account_id is null';
8047: else
8048: l_dist_sql_string :=
8049: 'select pdl.distribution_line_id,
8050: pdl.effective_date,
8051: pdl.distribution_amount
8052: from psp_distribution_lines pdl
8053: where pdl.payroll_sub_line_id = :1
8054: and pdl.suspense_org_account_id = :2';
8055: ---#fnd_file.put_line(fnd_file.log, 'Suspense sql string l_dist_sql_string='||l_dist_sql_string||', count='||t_payroll_sub_line_id.count);
8056: end if;
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;
8218: raise suspense_autopop_fail;
8219: else
8220: update psp_distribution_lines
8221: set auto_expenditure_type = l_new_expenditure_type
8222: where distribution_line_id=l_dist_line_id;
8223: suspense_account(
8224: x_proc_executed,
8244: END IF;
8245: end if;
8246: else -- linkage status is successful
8247: if p_schedule_type = 'SUSPENSE' then
8248: update psp_distribution_lines
8249: set suspense_auto_exp_type = l_new_expenditure_type
8250: where distribution_line_id=l_dist_line_id;
8251: else
8252: update psp_distribution_lines
8248: update psp_distribution_lines
8249: set suspense_auto_exp_type = l_new_expenditure_type
8250: where distribution_line_id=l_dist_line_id;
8251: else
8252: update psp_distribution_lines
8253: set auto_expenditure_type = l_new_expenditure_type
8254: where distribution_line_id=l_dist_line_id;
8255: end if;
8256:
8261:
8262: else -- if natural account then
8263: ----fnd_file.put_line(fnd_file.log,'SUCCESS-NA in autopop main in generic_account_autopop code='||l_auto_status);
8264: if p_schedule_type = 'SUSPENSE' then
8265: update psp_distribution_lines
8266: set suspense_auto_glccid = l_new_gl_code_combination_id
8267: where payroll_sub_line_id = t_payroll_sub_line_id(i)
8268: and suspense_org_account_id = t_account_id(i);
8269: elsif p_schedule_type = 'GLOBAL_ELEMENT' then
8266: set suspense_auto_glccid = l_new_gl_code_combination_id
8267: where payroll_sub_line_id = t_payroll_sub_line_id(i)
8268: and suspense_org_account_id = t_account_id(i);
8269: elsif p_schedule_type = 'GLOBAL_ELEMENT' then
8270: update psp_distribution_lines
8271: set auto_gl_code_combination_id = l_new_gl_code_combination_id
8272: where payroll_sub_line_id = t_payroll_sub_line_id(i)
8273: and element_account_id = t_account_id(i)
8274: and suspense_org_account_id is null;
8272: where payroll_sub_line_id = t_payroll_sub_line_id(i)
8273: and element_account_id = t_account_id(i)
8274: and suspense_org_account_id is null;
8275: else
8276: update psp_distribution_lines
8277: set auto_gl_code_combination_id = l_new_gl_code_combination_id
8278: where payroll_sub_line_id = t_payroll_sub_line_id(i)
8279: and default_org_account_id= t_account_id(i)
8280: and suspense_org_account_id is null;
8883: exit;
8884: end if;
8885: SELECT nvl(sum(distribution_amount),0)
8886: INTO l_total_dist_dr_amount
8887: FROM psp_distribution_lines pdl,
8888: psp_payroll_sub_lines ppsl,
8889: psp_payroll_lines ppl,
8890: psp_payroll_controls ppc
8891: WHERE ppc.payroll_control_id = payroll_control_rec.payroll_control_id
8896: AND ppl.dr_cr_flag = 'D';
8897:
8898: SELECT nvl(sum(distribution_amount),0)
8899: INTO l_total_dist_cr_amount
8900: FROM psp_distribution_lines pdl,
8901: psp_payroll_sub_lines ppsl,
8902: psp_payroll_lines ppl,
8903: psp_payroll_controls ppc
8904: WHERE ppc.payroll_control_id = payroll_control_rec.payroll_control_id