DBA Data[Home] [Help]

APPS.PSP_POA_BUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , psp_organization_accounts poa
     where poa.organization_account_id = p_organization_account_id
       and pbg.business_group_id = poa.business_group_id;
Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , psp_organization_accounts poa
     where poa.organization_account_id = p_organization_account_id
       and pbg.business_group_id = poa.business_group_id;
Line: 306

Procedure chk_non_updateable_args
  (p_rec in psp_poa_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';
Line: 330

End chk_non_updateable_args;
Line: 353

	CURSOR date_selection_csr IS
	SELECT start_date_active, end_date_active
	FROM   psp_organization_accounts
	WHERE  organization_id = p_organization_id
	AND    account_type_code = p_account_type
	AND    business_group_id = p_per_business_group_id
	AND    set_of_books_id   = p_gl_set_of_bks_id
	AND    organization_account_id <> NVL(p_organization_account_id,-999)
	AND    funding_source_code = p_funding_source_code;
Line: 364

	SELECT name
	FROM   hr_organization_units
	WHERE  business_group_id = p_per_business_group_id
	AND    organization_id = p_organization_id
	AND    trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate));
Line: 375

	OPEN date_selection_csr;
Line: 377

		fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
Line: 378

		EXIT WHEN date_selection_csr%NOTFOUND;
Line: 397

	CLOSE date_selection_csr;
Line: 400

		OPEN date_selection_csr;
Line: 402

			fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
Line: 403

			EXIT WHEN date_selection_csr%NOTFOUND;
Line: 409

		CLOSE date_selection_csr;
Line: 417

	OPEN date_selection_csr;
Line: 419

		fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
Line: 420

		EXIT WHEN date_selection_csr%NOTFOUND ;
Line: 455

	CLOSE date_selection_csr;
Line: 490

	SELECT start_date, completion_date
	FROM   gms_projects_expend_v
	WHERE  project_id = p_project_id;
Line: 495

	SELECT start_date, completion_date
	FROM   pa_tasks_expend_v
	WHERE  task_id = p_task_id;
Line: 500

	SELECT count(*)
	FROM   gms_awards_basic_v
	WHERE  project_id = p_project_id
	AND    award_id = p_award_id;
Line: 506

	SELECT  date_from, date_to
	FROM    pa_all_organizations p,hr_all_organization_units h
	WHERE   p.organization_id = h.organization_id
    AND     p.pa_org_use_type = 'EXPENDITURES'
    AND     h.organization_id = p_expenditure_organization_id
    AND     h.business_group_id = l_business_group_id
--    AND     nvl(p.org_id, -9999) = nvl(l_operating_unit, -9999)
    AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(p.org_id) = 'Y')
        or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ))
    AND     NVL(inactive_date,to_date('31/12/4712','DD/MM/RRRR')) > p_start_date_active;
Line: 603

Procedure insert_validate
  (p_rec                          in psp_poa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';
Line: 649

End insert_validate;
Line: 654

Procedure update_validate
  (p_rec                          in psp_poa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';
Line: 697

  chk_non_updateable_args
    (p_rec              => p_rec
    );
Line: 705

End update_validate;
Line: 710

Procedure delete_validate
  (p_rec                          in psp_poa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';
Line: 722

End delete_validate;