[Home] [Help]
3621: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, poa.attribute8)) attribute8,
3622: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, poa.attribute9)) attribute9,
3623: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, poa.attribute10)) attribute10
3624: FROM per_assignments_f paf,
3625: psp_organization_accounts poa
3626: WHERE poa.business_group_id = p_business_group_id
3627: AND poa.set_of_books_id = p_set_of_books_id
3628: and paf.assignment_type = 'E'
3629: AND paf.assignment_id = p_assignment_id
4033: decode(g_dff_grouping_option, 'Y',poa.attribute7),
4034: decode(g_dff_grouping_option, 'Y',poa.attribute8),
4035: decode(g_dff_grouping_option, 'Y',poa.attribute9),
4036: decode(g_dff_grouping_option, 'Y',poa.attribute10)
4037: FROM psp_organization_accounts poa
4038: WHERE business_group_id = p_business_group_id
4039: AND set_of_books_id = p_set_of_books_id
4040: AND poa.organization_id = l_organization_id
4041: AND poa.account_type_code = l_account_type_code
4056: poa.task_id,
4057: poa.award_id,
4058: poa.expenditure_type,
4059: poa.expenditure_organization_id
4060: FROM psp_organization_accounts poa
4061: WHERE poa.account_type_code = 'G'
4062: AND p_payroll_start_date BETWEEN poa.start_date_active AND
4063: nvl(poa.end_date_active,p_payroll_start_date);
4064: */
4195: l_attribute7,
4196: l_attribute8,
4197: l_attribute9,
4198: l_attribute10
4199: FROM psp_organization_accounts
4200: WHERE organization_account_id = l_organization_account_id;
4201:
4202: EXCEPTION
4203: WHEN OTHERS THEN
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,
5399: psp_organization_accounts poa2
5400: WHERE ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
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(+)
5403: AND pdl.default_org_account_id = poa.organization_account_id(+)
6946: cursor org_excess_act(p_asg_id integer,
6947: p_dist_date date,
6948: p_funding_source_code varchar2) is
6949: select org.organization_account_id
6950: from psp_organization_accounts org,
6951: per_all_assignments_f paf
6952: where org.account_type_code in ( 'ORG_EXCESS')
6953: and p_dist_date between org.start_date_active and nvl(org.end_date_active, fnd_date.canonical_to_date('4000/01/31'))
6954: and paf.assignment_type = 'E'
6960: cursor generic_excess_act(p_dist_date date,
6961: p_excess_org_id number,
6962: p_funding_source_code varchar2) is
6963: select organization_account_id
6964: from psp_organization_accounts
6965: where p_dist_date between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'))
6966: and account_type_code = 'ORG_EXCESS'
6967: and organization_id = p_excess_org_id
6968: and p_funding_source_code = funding_source_code;
7132: :t_assignment_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,
7186: :t_assignment_id,
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,
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:
7371: forall i in 1..t_dist_line_id.count
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
7822: and ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
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
7863: and ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
8456: cursor check_generic_excess(p_date in date,
8457: p_excess_org_id in number,
8458: p_business_group_id in number) is
8459: select count(*)
8460: from psp_organization_accounts
8461: where account_type_code = 'ORG_EXCESS'
8462: and p_date between trunc(start_date_active) and trunc(end_date_active)
8463: and organization_id = p_excess_org_id
8464: and business_group_id = p_business_group_id ;