[Home] [Help]
96: or_award_id,
97: or_expenditure_org_id,
98: or_expenditure_type
99: FROM psp_payroll_lines ppl,
100: psp_payroll_sub_lines ppsl,
101: per_time_periods ptp,
102: psp_payroll_controls ppc
103: WHERE ppl.payroll_line_id = ppsl.payroll_line_id
104: AND ppl.status_code = 'N'
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
209: and pdl.adjustment_batch_name is null
210: and psl.person_id = payroll_rec.person_id
375: l_no_business_days := 1;
376: END IF;
377: l_daily_rate := round((payroll_rec.pay_amount / l_no_business_days), g_ext_precision); -- Modified to currency extended precision for bug fix 2916848, 3109943
378: -- 4304623
379: update psp_payroll_sub_lines
380: set daily_rate = l_daily_rate
381: where payroll_sub_line_id = payroll_rec.payroll_sub_line_id;
382: ELSE
383: l_daily_rate := round(payroll_rec.daily_rate, g_ext_precision); -- Modified to currency extended precision for bug fix 2916848 ,3109943
5204:
5205: cursor get_control_id is
5206: select ppl.payroll_control_id
5207: from psp_payroll_lines ppl,
5208: psp_payroll_sub_lines ppsl
5209: where ppl.payroll_line_id = ppsl.payroll_line_id
5210: and ppsl.payroll_sub_line_id = g_sub_line_id;
5211:
5212: l_proc_executed varchar2(10);
5266: close autopop_config_cur;
5267:
5268: -- dbms_output.put_line('Entered create master');
5269: select psp_payroll_lines_s.nextval,
5270: psp_payroll_sub_lines_s.nextval,
5271: psp_payroll_controls_s.nextval
5272: into l_line_id,
5273: g_sub_line_id,
5274: l_control_id
5310: and assignment_type = 'E'
5311: and rownum = 1;
5312:
5313: -- dbms_output.put_line('Create master payroll_line rowcount='||sql%rowcount);
5314: insert into psp_payroll_sub_lines
5315: (payroll_sub_line_id,
5316: sub_line_start_date,
5317: sub_line_end_date,
5318: pay_amount,
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,
5397: psp_element_type_accounts peta,
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
6098: WHERE
6099: ppl.payroll_control_id = p_payroll_control_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
6435: ppl.payroll_control_id = p_payroll_control_id
6436: and ppl.assignment_id between p_start_asg_id and p_end_asg_id
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
7006: and pdl.distribution_line_id = p_dist_line_id
7137: psp_element_type_accounts pea,
7138: psp_default_labor_schedules pdls,
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
7191: psp_element_type_accounts pea,
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
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
7529: and ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
7530: and pdl.suspense_org_account_id is null
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
7820: and ppl.assignment_id between p_start_asg_id and p_end_asg_id
7821: and ppl.payroll_line_id = ppsl.payroll_line_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
7861: and ppl.assignment_id between p_start_asg_id and p_end_asg_id
7862: and ppl.payroll_line_id = ppsl.payroll_line_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
7901: and ppl.assignment_id between p_start_asg_id and p_end_asg_id
7902: and ppl.payroll_line_id = ppsl.payroll_line_id
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
8892: AND ppc.payroll_control_id = ppl.payroll_control_id
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
8905: AND ppc.payroll_control_id = ppl.payroll_control_id