APPS.PSP_ENC_SUM_TRAN dependencies on PA_PROJECTS_ALL

Line 4622: pa_projects_all ppa,

4618: DECODE(pec.uom, 'H', DECODE(SIGN(summary_amount), -1, 'Y')) unmatched_nve_txn_flag, --6242618
4619: papf.employee_number --Added for Bug 10126350
4620: FROM psp_enc_summary_lines pesl,
4621: hr_organization_units hou,
4622: pa_projects_all ppa,
4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
4624: per_time_periods ptp,
4625: psp_enc_controls pec
4626: ,per_all_people_f papf --Added for Bug 10126350

Line 4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

4903:
4904: IF r_interface.operating_unit(recno) IS NULL THEN
4905: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4908: fnd_msg_pub.add;
4909: l_raise_error := TRUE;
4910: END IF;
4911:

Line 4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

4911:
4912: IF r_interface.project_number(recno) IS NULL THEN
4913: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4916: fnd_msg_pub.add;
4917: l_raise_error := TRUE;
4918: END IF;
4919:

Line 6059: l_project_number pa_projects_all.segment1%TYPE;

6055: l_award_id NUMBER(15);
6056: l_task_id NUMBER(15);
6057: l_return_status VARCHAR2(1);
6058: l_cnt_gms_interface NUMBER;
6059: l_project_number pa_projects_all.segment1%TYPE;
6060: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)
6061: l_award_number gms_awards_all.award_number%TYPE;
6062: l_exp_org_name hr_organization_units.name%TYPE;
6063: l_gl_description VARCHAR2(4000);

Line 6067: FROM pa_projects_all

6063: l_gl_description VARCHAR2(4000);
6064:
6065: CURSOR project_number_cur IS
6066: SELECT SEGMENT1
6067: FROM pa_projects_all
6068: WHERE project_id = l_project_id;
6069:
6070: CURSOR award_number_cur IS
6071: SELECT award_number

Line 6748: pa_projects_all pa

6744: DECODE(g_dff_grouping_option, 'Y', pel.attribute9, NULL) attribute9,
6745: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
6746: pa.org_id
6747: FROM PSP_ENC_LINES pel,
6748: pa_projects_all pa
6749: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
6750: AND pel.payroll_action_id = p_payroll_action_id
6751: AND (g_suspense_failed = 'TRUE' OR pel.suspense_reason_code LIKE 'ES:%')
6752: AND (g_suspense_failed = 'TRUE' OR enc_start_date <= g_def_end_date)

Line 7090: l_project_number pa_projects_all.segment1%TYPE;

7086: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
7087: l_full_name per_all_people_f.full_name%TYPE;
7088: l_organization_name hr_organization_units.name%TYPE;
7089: l_element_name pay_element_types_f.element_name%TYPE;
7090: l_project_number pa_projects_all.segment1%TYPE;
7091: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; -- Bug 16391366 (27/03/2013)
7092: l_award_number gms_awards_all.award_number%TYPE;
7093: l_exp_org_name hr_organization_units.name%TYPE;
7094: l_gl_description VARCHAR2(4000);

Line 7130: FROM pa_projects_all

7126: WHERE organization_id = l_organization_id;
7127:
7128: CURSOR project_number_cur (p_project_id IN NUMBER) IS
7129: SELECT SEGMENT1
7130: FROM pa_projects_all
7131: WHERE project_id = p_project_id;
7132:
7133: CURSOR award_number_cur (p_award_id IN NUMBER) IS
7134: SELECT award_number