[Home] [Help]
95: or_task_id,
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
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
209: and pdl.adjustment_batch_name is null
5203: l_payroll_control_id integer;
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:
5265: g_excess_account_autopop;
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,
5273: g_sub_line_id,
5274: l_control_id
5275: from dual;
5276:
5277: insert into psp_payroll_lines
5278: (payroll_line_id,
5279: set_of_books_id,
5280: assignment_id,
5281: person_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,
5398: psp_default_labor_Schedules pdls,
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
6098: WHERE
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
6435: ppl.payroll_control_id = p_payroll_control_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
7007: and psl.payroll_line_id = ppl.payroll_line_id;
7136: psp_organization_accounts pod,
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'||''''||'
7190: psp_organization_accounts pod,
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'||''''||'
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
7529: and ppsl.payroll_sub_line_id = pdl.payroll_sub_line_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
7820: and ppl.assignment_id between p_start_asg_id and p_end_asg_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
7861: and ppl.assignment_id between p_start_asg_id and p_end_asg_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
7901: and ppl.assignment_id between p_start_asg_id and p_end_asg_id
8658: g_payroll_id := nvl(g_payroll_id, -999);
8659:
8660: --- introduced distinct for 4614640
8661: sqlstr := 'select distinct ppl.assignment_id
8662: from psp_payroll_lines ppl,
8663: psp_payroll_controls ppc
8664: where ppc.payroll_control_id = ppl.payroll_control_id
8665: and ppc.cdl_payroll_action_id = :payroll_action_id
8666: order by ppl.assignment_id';
8759: cursor get_assignments(p_pactid number, stasg number, endasg number,
8760: p_time_period_id number) is
8761: select distinct ppl.assignment_id
8762: FROM psp_payroll_controls ppc,
8763: psp_payroll_lines ppl
8764: WHERE ppc.business_group_id = g_business_group_id
8765: AND ppc.set_of_books_id = g_set_of_books_id
8766: AND ppc.source_type = nvl(g_source_type,ppc.source_type)
8767: AND ppc.payroll_source_code = nvl(g_source_code,ppc.payroll_source_code)
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
8893: AND ppl.payroll_line_id = ppsl.payroll_line_id
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
8906: AND ppl.payroll_line_id = ppsl.payroll_line_id