[Home] [Help]
877: decode(g_dff_grouping_option, 'Y', NVL(p_attribute7, peta.attribute7)) attribute7,
878: decode(g_dff_grouping_option, 'Y', NVL(p_attribute8, peta.attribute8)) attribute8,
879: decode(g_dff_grouping_option, 'Y', NVL(p_attribute9, peta.attribute9)) attribute9,
880: decode(g_dff_grouping_option, 'Y', NVL(p_attribute10, peta.attribute10)) attribute10
881: FROM psp_element_type_accounts peta
882: WHERE business_group_id = p_business_group_id
883: AND set_of_books_id = p_set_of_books_id
884: AND peta.element_type_id = p_element_type_id
885: AND p_payroll_start_date BETWEEN peta.start_date_active AND
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,
5399: psp_organization_accounts poa2
5400: WHERE ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
5401: AND ppsl.payroll_line_id = ppl.payroll_line_id
7133: :t_excess_account,
7134: :t_excess_line_id
7135: From psp_schedule_lines psl,
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,
7187: :t_excess_account,
7188: :t_excess_line_id
7189: From psp_schedule_lines psl,
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,
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
7903: and ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id