APPS.PSP_ENC_SUM_TRAN dependencies on HR_ORGANIZATION_UNITS

Line 2773: FROM hr_organization_units hou,

2769: pel.assignment_id,
2770: pel.encumbrance_date,
2771: pel.suspense_org_account_id,
2772: pel.gl_code_combination_id
2773: FROM hr_organization_units hou,
2774: per_assignments_f paf,
2775: psp_enc_lines pel
2776: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
2777: AND pel.assignment_id = paf.assignment_id

Line 4516: hr_organization_units hou,

4512: pesl.effective_date,
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

Line 4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');

4771:
4772: IF r_interface.exp_org_name(recno) IS NULL THEN
4773: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4774: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4776: fnd_msg_pub.add;
4777: l_raise_error := TRUE;
4778: END IF;
4779:

Line 5123: FROM hr_organization_units hou,

5119: pel.rowid,
5120: pel.assignment_id,
5121: pel.encumbrance_date,
5122: pel.suspense_org_account_id
5123: FROM hr_organization_units hou,
5124: per_assignments_f paf,
5125: psp_enc_lines pel,
5126: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
5127: AND pel.assignment_id = paf.assignment_id

Line 5879: l_exp_org_name hr_organization_units.name%TYPE;

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);
5881:
5882: CURSOR project_number_cur IS
5883: SELECT SEGMENT1

Line 5899: FROM hr_organization_units

5895: WHERE task_id = l_task_id;
5896:
5897: CURSOR exp_org_name_cur IS
5898: SELECT name
5899: FROM hr_organization_units
5900: WHERE organization_id = l_expenditure_organization_id;
5901:
5902: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5903: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 6852: l_organization_name hr_organization_units.name%TYPE;

6848: l_organization_id NUMBER(15);
6849: l_assignment_number per_all_assignments_f.assignment_number%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;

Line 6857: l_exp_org_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);
6859: l_return_status VARCHAR2(1);
6860:
6861: CURSOR asg_number_cur (p_assignment_id IN NUMBER,

Line 6889: FROM hr_organization_units

6885: AND ROWNUM = 1;
6886:
6887: CURSOR org_name_cur IS
6888: SELECT name
6889: FROM hr_organization_units
6890: WHERE organization_id = l_organization_id;
6891:
6892: CURSOR project_number_cur (p_project_id IN NUMBER) IS
6893: SELECT SEGMENT1

Line 6909: FROM hr_organization_units

6905: WHERE task_id = p_task_id;
6906:
6907: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
6908: SELECT name
6909: FROM hr_organization_units
6910: WHERE organization_id = p_expenditure_org_id;
6911:
6912: CURSOR element_name_cur (p_element_type_id IN NUMBER) IS
6913: SELECT element_name