APPS.PSP_PEE_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_external_effort_lines pee
     where pee.external_effort_line_id = p_external_effort_line_id
       and pbg.business_group_id = pee.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , psp_external_effort_lines pee
     where pee.external_effort_line_id = p_external_effort_line_id
       and pbg.business_group_id = pee.business_group_id;

Line: 304

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

Line: 328

End chk_non_updateable_args;

Line: 344

  SELECT business_group_id
  FROM   per_business_groups
  where  business_group_id = p_business_group_id
  AND    p_distribution_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));

Line: 392

  SELECT set_of_books_id
  FROM   gl_sets_of_books
  WHERE  set_of_books_id = p_set_of_books_id;

Line: 437

  SELECT person_id
  FROM   per_all_people_f
  WHERE  person_id = p_person_id
  AND    current_employee_flag = 'Y'
  AND    business_group_id = p_business_group_id
  AND    p_distribution_date between effective_start_date and effective_end_date;

Line: 500

  SELECT assignment_id
  FROM   per_all_assignments_f paaf,
         pay_all_payrolls_f papf
  WHERE  paaf.payroll_id = papf.payroll_id
  AND    paaf.assignment_id = p_assignment_id
  AND    paaf.person_id = p_person_id
  AND    paaf.business_group_id = p_business_group_id
  AND    p_distribution_date between paaf.effective_start_date and paaf.effective_end_date
  AND    p_distribution_date between papf.effective_start_date and papf.effective_end_date;

Line: 568

  SELECT fc.currency_code
  FROM   fnd_currencies fc,
         per_business_groups pbg
  WHERE  fc.currency_code =pbg.currency_code
  AND    fc.enabled_flag = 'Y'
  AND    fc.currency_flag = 'Y'
  AND    fc.currency_code = p_currency_code
  AND    p_distribution_date between nvl(fc.start_date_active,p_distribution_date) and nvl(fc.end_date_active ,to_date('31/12/4712','DD/MM/RRRR'))
  AND    p_distribution_date between date_from and nvl(pbg.DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));

Line: 657

  SELECT code_combination_id
  FROM   gl_code_combinations
  WHERE  code_combination_id = p_gl_code_combination_id
  AND    enabled_flag ='Y';

Line: 702

  SELECT project_id
  FROM   pa_projects_all
  WHERE  project_id = p_project_id
  AND    p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));

Line: 752

  SELECT task_id
  FROM   pa_tasks
  WHERE  task_id = p_task_id
  AND    p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));

Line: 802

  SELECT award_id
  FROM   gms_awards_all
  WHERE  award_id = p_award_id
  AND    p_distribution_date between nvl(start_date_active,trunc(p_distribution_date)) and nvl(end_date_active,to_date('31/12/4712','DD/MM/RRRR'));

Line: 853

  SELECT organization_id
  FROM   psp_organizations_expend_v
  WHERE  organization_id = p_expenditure_organization_id
  AND    trunc(p_distribution_date) between date_from and nvl(date_to,trunc(p_distribution_date));

Line: 906

  SELECT per.effort_report_id, prth.selection_match_level
  FROM   psp_eff_reports per,
         psp_report_templates_h prth
  WHERE  per.request_id = prth.request_id
  AND    per.PERSON_ID = p_person_id
  AND    p_distribution_date between per.start_date and per.end_date
  AND    per.STATUS_CODE IN ('N','A');

Line: 915

  SELECT assignment_id
  FROM   psp_eff_report_details perd
  WHERE  effort_report_id = p_effort_report_id
  AND    ASSIGNMENT_ID = p_assignment_id;

Line: 921

  l_selection_match_level VARCHAR2(30);

Line: 930

  FETCH person_effort_report_csr INTO l_effort_report_id, l_selection_match_level;

Line: 934

    IF l_selection_match_level = 'EMP' THEN
      RAISE person_effort_report_exist;

Line: 936

    ELSIF l_selection_match_level = 'ASG' THEN
      OPEN assignment_effort_report_csr(l_effort_report_id, p_assignment_id);

Line: 969

  SELECT per.effort_report_id, prth.selection_match_level
  FROM   psp_eff_reports per,
         psp_report_templates_h prth
  WHERE  per.request_id = prth.request_id
  AND    per.PERSON_ID = p_person_id
  AND    p_distribution_date between per.start_date and per.end_date
  AND    per.STATUS_CODE IN ('N','A');

Line: 978

  SELECT assignment_id
  FROM   psp_eff_report_details perd
  WHERE  effort_report_id = p_effort_report_id
  AND    ASSIGNMENT_ID = p_assignment_id;

Line: 984

  SELECT business_group_id
  FROM   per_business_groups
  where  business_group_id = p_business_group_id
  AND    p_distribution_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));

Line: 990

  SELECT set_of_books_id
  FROM   gl_sets_of_books
  WHERE  set_of_books_id = p_set_of_books_id;

Line: 995

  SELECT person_id
  FROM   per_all_people_f
  WHERE  person_id = p_person_id
  AND    current_employee_flag = 'Y'
  AND    business_group_id = p_business_group_id
  AND    p_distribution_date between effective_start_date and effective_end_date;

Line: 1003

  SELECT assignment_id
  FROM   per_all_assignments_f paaf,
         pay_all_payrolls_f papf
  WHERE  paaf.payroll_id = papf.payroll_id
  AND    paaf.assignment_id = p_assignment_id
  AND    paaf.person_id = p_person_id
  AND    paaf.business_group_id = p_business_group_id
  AND    p_distribution_date between paaf.effective_start_date and paaf.effective_end_date
  AND    p_distribution_date between papf.effective_start_date and papf.effective_end_date;

Line: 1014

  SELECT fc.currency_code
  FROM   fnd_currencies fc,
         per_business_groups pbg
  WHERE  fc.currency_code =pbg.currency_code
  AND    fc.enabled_flag = 'Y'
  AND    fc.currency_flag = 'Y'
  AND    fc.currency_code = p_currency_code
  AND    p_distribution_date between nvl(fc.start_date_active,p_distribution_date) and nvl(fc.end_date_active ,to_date('31/12/4712','DD/MM/RRRR'))
  AND    p_distribution_date between date_from and nvl(pbg.DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));

Line: 1025

  SELECT code_combination_id
  FROM   gl_code_combinations
  WHERE  code_combination_id = p_gl_code_combination_id
  AND    enabled_flag ='Y';

Line: 1031

  SELECT project_id
  FROM   pa_projects_all
  WHERE  project_id = p_project_id
  AND    p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));

Line: 1037

  SELECT task_id
  FROM   pa_tasks
  WHERE  task_id = p_task_id
  AND    p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));

Line: 1043

  SELECT award_id
  FROM   gms_awards_all
  WHERE  award_id = p_award_id
  AND    p_distribution_date between nvl(start_date_active,trunc(p_distribution_date)) and nvl(end_date_active,to_date('31/12/4712','DD/MM/RRRR'));

Line: 1049

  SELECT organization_id
  FROM   psp_organizations_expend_v
  WHERE  organization_id = p_expenditure_organization_id
  AND    trunc(p_distribution_date) between date_from and nvl(date_to,trunc(p_distribution_date));

Line: 1056

  l_selection_match_level VARCHAR2(30);

Line: 1091

  FETCH person_effort_report_csr INTO l_effort_report_id, l_selection_match_level;

Line: 1095

    IF l_selection_match_level = 'EMP' THEN
      RAISE person_effort_report_exist;

Line: 1097

    ELSIF l_selection_match_level = 'ASG' THEN
      OPEN assignment_effort_report_csr(l_effort_report_id, p_rec.assignment_id);

Line: 1281

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

Line: 1367

End insert_validate;

Line: 1372

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

Line: 1454

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1462

End update_validate;

Line: 1467

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

Line: 1482

End delete_validate;