[Home] [Help]
2811: pel.assignment_id,
2812: pel.encumbrance_date,
2813: pel.suspense_org_account_id,
2814: pel.gl_code_combination_id
2815: FROM hr_organization_units hou,
2816: per_assignments_f paf,
2817: psp_enc_lines pel
2818: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
2819: AND pel.assignment_id = paf.assignment_id
4617: pesl.gms_batch_name,
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
4895:
4896: IF r_interface.exp_org_name(recno) IS NULL THEN
4897: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4900: fnd_msg_pub.add;
4901: l_raise_error := TRUE;
4902: END IF;
4903:
5302: pel.rowid,
5303: pel.assignment_id,
5304: pel.encumbrance_date,
5305: pel.suspense_org_account_id
5306: FROM hr_organization_units hou,
5307: per_assignments_f paf,
5308: psp_enc_lines pel,
5309: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
5310: AND pel.assignment_id = paf.assignment_id
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);
6064:
6065: CURSOR project_number_cur IS
6066: SELECT SEGMENT1
6078: WHERE task_id = l_task_id;
6079:
6080: CURSOR exp_org_name_cur IS
6081: SELECT name
6082: FROM hr_organization_units
6083: WHERE organization_id = l_expenditure_organization_id;
6084:
6085: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6086: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
7084: l_organization_id NUMBER(15);
7085: l_assignment_number per_all_assignments_f.assignment_number%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;
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);
7095: l_return_status VARCHAR2(1);
7096:
7097: CURSOR asg_number_cur (p_assignment_id IN NUMBER,
7121: AND ROWNUM = 1;
7122:
7123: CURSOR org_name_cur IS
7124: SELECT name
7125: FROM hr_organization_units
7126: WHERE organization_id = l_organization_id;
7127:
7128: CURSOR project_number_cur (p_project_id IN NUMBER) IS
7129: SELECT SEGMENT1
7141: WHERE task_id = p_task_id;
7142:
7143: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
7144: SELECT name
7145: FROM hr_organization_units
7146: WHERE organization_id = p_expenditure_org_id;
7147:
7148: CURSOR element_name_cur (p_element_type_id IN NUMBER) IS
7149: SELECT element_name