APPS.PSP_ENC_CREATE_LINES dependencies on HR_ORGANIZATION_UNITS

Line 1628: l_exp_org_name hr_organization_units.name%TYPE;

1624:
1625: l_project_number pa_projects_all.segment1%TYPE;
1626: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; Bug : 16391366 (27/03/2013)
1627: l_award_number gms_awards_all.award_number%TYPE;
1628: l_exp_org_name hr_organization_units.name%TYPE;
1629: l_gl_description VARCHAR2(4000);
1630: l_time_period_id NUMBER;
1631: l_return_status VARCHAR2(1);
1632: l_person_id NUMBER;

Line 1714: FROM hr_organization_units

1710: AND ROWNUM = 1;
1711:
1712: CURSOR org_name_cur IS
1713: SELECT name
1714: FROM hr_organization_units
1715: WHERE organization_id = l_organization_id;
1716:
1717: CURSOR project_number_cur IS
1718: SELECT SEGMENT1

Line 1734: FROM hr_organization_units

1730: WHERE task_id = l_task_id;
1731:
1732: CURSOR exp_org_name_cur IS
1733: SELECT name
1734: FROM hr_organization_units
1735: WHERE organization_id = l_expenditure_org_id;
1736:
1737: PROCEDURE process_all_hier (p_chunk_pointer IN NUMBER,
1738: p_asg_start_date IN DATE,

Line 6798: l_organization_name hr_organization_units.name%TYPE;

6794: l_organization_id NUMBER(15);
6795: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6796: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6797: l_full_name per_all_people_f.full_name%TYPE;
6798: l_organization_name hr_organization_units.name%TYPE;
6799: l_process_mode VARCHAR2(15);
6800: l_enc_begin_date DATE;
6801: l_min_asg_id NUMBER(15);
6802: l_max_asg_id NUMBER(15);

Line 6979: FROM hr_organization_units

6975: AND ROWNUM = 1;
6976:
6977: CURSOR org_name_cur IS
6978: SELECT name
6979: FROM hr_organization_units
6980: WHERE organization_id = l_organization_id;
6981:
6982: CURSOR element_name_cur IS
6983: SELECT element_name

Line 7082: FROM hr_organization_units

7078: WHERE task_id = p_task_id;
7079:
7080: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
7081: SELECT name
7082: FROM hr_organization_units
7083: WHERE organization_id = p_expenditure_org_id;
7084:
7085: l_project_number pa_projects_all.segment1%TYPE;
7086: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; Bug : 16391366 (27/03/2013)

Line 7088: l_exp_org_name hr_organization_units.name%TYPE;

7084:
7085: l_project_number pa_projects_all.segment1%TYPE;
7086: l_task_number VARCHAR2(300); -- pa_tasks.task_number%TYPE; Bug : 16391366 (27/03/2013)
7087: l_award_number gms_awards_all.award_number%TYPE;
7088: l_exp_org_name hr_organization_units.name%TYPE;
7089: l_gl_description VARCHAR2(1000);
7090: BEGIN
7091: FOR recno IN 1..cel_warnings.start_date.COUNT
7092: LOOP

Line 8808: l_organization_name hr_organization_units.name%TYPE;

8804: l_organization_id NUMBER(15);
8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8807: l_full_name per_all_people_f.full_name%TYPE;
8808: l_organization_name hr_organization_units.name%TYPE;
8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8810: l_process_mode VARCHAR2(15);
8811: l_person_id1 NUMBER(15);
8812: l_termination_date1 DATE;

Line 8897: FROM hr_organization_units

8893: AND ROWNUM = 1;
8894:
8895: CURSOR org_name_cur IS
8896: SELECT name
8897: FROM hr_organization_units
8898: WHERE organization_id = l_organization_id;
8899:
8900: CURSOR process_descr_cur IS
8901: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name