APPS.PSP_PAYTRN dependencies on PA_PROJECTS_ALL

Line 579: FROM pa_projects_all

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

Line 584: FROM pa_projects_all

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

Line 1061: l_table := 'PA_PROJECTS_ALL';

1057: FROM per_people_f
1058: WHERE person_id = l_person_id
1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);

Line 1081: l_table := 'PA_PROJECTS_ALL';

1077: FROM per_people_f
1078: WHERE person_id = l_person_id
1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);