APPS.PSP_ENC_SUM_TRAN dependencies on PA_PROJECTS_ALL

Line 4517: pa_projects_all ppa,

4513: pesl.gms_batch_name,
4514: DECODE(pec.uom, 'H', DECODE(SIGN(summary_amount), -1, 'Y')) unmatched_nve_txn_flag --6242618
4515: FROM psp_enc_summary_lines pesl,
4516: hr_organization_units hou,
4517: pa_projects_all ppa,
4518: pa_tasks pt,
4519: per_time_periods ptp,
4520: psp_enc_controls pec
4521: WHERE pec.payroll_action_id = p_payroll_action_id

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

4779:
4780: IF r_interface.operating_unit(recno) IS NULL THEN
4781: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4782: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4783: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4784: fnd_msg_pub.add;
4785: l_raise_error := TRUE;
4786: END IF;
4787:

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

4787:
4788: IF r_interface.project_number(recno) IS NULL THEN
4789: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4790: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4791: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4792: fnd_msg_pub.add;
4793: l_raise_error := TRUE;
4794: END IF;
4795:

Line 5876: l_project_number pa_projects_all.segment1%TYPE;

5872: l_award_id NUMBER(15);
5873: l_task_id NUMBER(15);
5874: l_return_status VARCHAR2(1);
5875: l_cnt_gms_interface NUMBER;
5876: l_project_number pa_projects_all.segment1%TYPE;
5877: l_task_number pa_tasks.task_number%TYPE;
5878: l_award_number gms_awards_all.award_number%TYPE;
5879: l_exp_org_name hr_organization_units.name%TYPE;
5880: l_gl_description VARCHAR2(4000);

Line 5884: FROM pa_projects_all

5880: l_gl_description VARCHAR2(4000);
5881:
5882: CURSOR project_number_cur IS
5883: SELECT SEGMENT1
5884: FROM pa_projects_all
5885: WHERE project_id = l_project_id;
5886:
5887: CURSOR award_number_cur IS
5888: SELECT award_number

Line 6514: pa_projects_all pa

6510: DECODE(g_dff_grouping_option, 'Y', pel.attribute9, NULL) attribute9,
6511: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
6512: pa.org_id
6513: FROM PSP_ENC_LINES pel,
6514: pa_projects_all pa
6515: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
6516: AND pel.payroll_action_id = p_payroll_action_id
6517: AND (g_suspense_failed = 'TRUE' OR pel.suspense_reason_code LIKE 'ES:%')
6518: AND (g_suspense_failed = 'TRUE' OR enc_start_date <= g_def_end_date)

Line 6854: l_project_number pa_projects_all.segment1%TYPE;

6850: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6851: l_full_name per_all_people_f.full_name%TYPE;
6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;
6854: l_project_number pa_projects_all.segment1%TYPE;
6855: l_task_number pa_tasks.task_number%TYPE;
6856: l_award_number gms_awards_all.award_number%TYPE;
6857: l_exp_org_name hr_organization_units.name%TYPE;
6858: l_gl_description VARCHAR2(4000);

Line 6894: FROM pa_projects_all

6890: WHERE organization_id = l_organization_id;
6891:
6892: CURSOR project_number_cur (p_project_id IN NUMBER) IS
6893: SELECT SEGMENT1
6894: FROM pa_projects_all
6895: WHERE project_id = p_project_id;
6896:
6897: CURSOR award_number_cur (p_award_id IN NUMBER) IS
6898: SELECT award_number