APPS.PSP_PAYTRN dependencies on PA_PROJECTS_ALL

Line 577: FROM pa_projects_all

573: WHERE organization_id = l_or_expenditure_org_id;
574:
575: CURSOR project_id_cur IS
576: SELECT segment1
577: FROM pa_projects_all
578: WHERE project_id = l_or_project_id;
579:
580: CURSOR org_id_cur IS
581: SELECT org_id

Line 582: FROM pa_projects_all

578: WHERE project_id = l_or_project_id;
579:
580: CURSOR org_id_cur IS
581: SELECT org_id
582: FROM pa_projects_all
583: WHERE project_id = l_or_project_id;
584:
585: CURSOR task_id_cur IS
586: SELECT task_number

Line 1028: l_table := 'PA_PROJECTS_ALL';

1024: FROM per_people_f
1025: WHERE person_id = l_person_id
1026: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1027: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1028: l_table := 'PA_PROJECTS_ALL';
1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);

Line 1048: l_table := 'PA_PROJECTS_ALL';

1044: FROM per_people_f
1045: WHERE person_id = l_person_id
1046: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1047: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1048: l_table := 'PA_PROJECTS_ALL';
1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);