[Home] [Help]
3080: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, pdls.attribute8)) attribute8,
3081: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, pdls.attribute9)) attribute9,
3082: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, pdls.attribute10)) attribute10
3083: FROM per_assignments_f paf,
3084: psp_default_labor_schedules pdls
3085: WHERE pdls.business_group_id = p_business_group_id
3086: AND pdls.set_of_books_id = p_set_of_books_id
3087: and paf.assignment_type = 'E'
3088: AND pdls.organization_id = paf.organization_id
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
5402: AND pdl.schedule_line_id = psl.schedule_line_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
6437: AND ppl.payroll_line_id = ppsl.payroll_line_id
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,
7142: gms_awards_all awd,
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,
7196: psp_distribution_lines pdl,