APPS.PSP_ENC_CREATE_LINES dependencies on HR_ORGANIZATION_UNITS

Line 1413: l_exp_org_name hr_organization_units.name%TYPE;

1409:
1410: l_project_number pa_projects_all.segment1%TYPE;
1411: l_task_number pa_tasks.task_number%TYPE;
1412: l_award_number gms_awards_all.award_number%TYPE;
1413: l_exp_org_name hr_organization_units.name%TYPE;
1414: l_gl_description VARCHAR2(4000);
1415: l_time_period_id NUMBER;
1416: l_return_status VARCHAR2(1);
1417: l_person_id NUMBER;

Line 1499: FROM hr_organization_units

1495: AND ROWNUM = 1;
1496:
1497: CURSOR org_name_cur IS
1498: SELECT name
1499: FROM hr_organization_units
1500: WHERE organization_id = l_organization_id;
1501:
1502: CURSOR project_number_cur IS
1503: SELECT SEGMENT1

Line 1519: FROM hr_organization_units

1515: WHERE task_id = l_task_id;
1516:
1517: CURSOR exp_org_name_cur IS
1518: SELECT name
1519: FROM hr_organization_units
1520: WHERE organization_id = l_expenditure_org_id;
1521:
1522: PROCEDURE process_all_hier (p_chunk_pointer IN NUMBER,
1523: p_asg_start_date IN DATE,

Line 6541: l_organization_name hr_organization_units.name%TYPE;

6537: l_organization_id NUMBER(15);
6538: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6539: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6540: l_full_name per_all_people_f.full_name%TYPE;
6541: l_organization_name hr_organization_units.name%TYPE;
6542: l_process_mode VARCHAR2(15);
6543: l_enc_begin_date DATE;
6544: l_min_asg_id NUMBER(15);
6545: l_max_asg_id NUMBER(15);

Line 6702: FROM hr_organization_units

6698: AND ROWNUM = 1;
6699:
6700: CURSOR org_name_cur IS
6701: SELECT name
6702: FROM hr_organization_units
6703: WHERE organization_id = l_organization_id;
6704:
6705: CURSOR element_name_cur IS
6706: SELECT element_name

Line 6805: FROM hr_organization_units

6801: WHERE task_id = p_task_id;
6802:
6803: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
6804: SELECT name
6805: FROM hr_organization_units
6806: WHERE organization_id = p_expenditure_org_id;
6807:
6808: l_project_number pa_projects_all.segment1%TYPE;
6809: l_task_number pa_tasks.task_number%TYPE;

Line 6811: l_exp_org_name hr_organization_units.name%TYPE;

6807:
6808: l_project_number pa_projects_all.segment1%TYPE;
6809: l_task_number pa_tasks.task_number%TYPE;
6810: l_award_number gms_awards_all.award_number%TYPE;
6811: l_exp_org_name hr_organization_units.name%TYPE;
6812: l_gl_description VARCHAR2(1000);
6813: BEGIN
6814: FOR recno IN 1..cel_warnings.start_date.COUNT
6815: LOOP

Line 8485: l_organization_name hr_organization_units.name%TYPE;

8481: l_organization_id NUMBER(15);
8482: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8484: l_full_name per_all_people_f.full_name%TYPE;
8485: l_organization_name hr_organization_units.name%TYPE;
8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8487: l_process_mode VARCHAR2(15);
8488: l_person_id1 NUMBER(15);
8489: l_termination_date1 DATE;

Line 8573: FROM hr_organization_units

8569: AND ROWNUM = 1;
8570:
8571: CURSOR org_name_cur IS
8572: SELECT name
8573: FROM hr_organization_units
8574: WHERE organization_id = l_organization_id;
8575:
8576: CURSOR process_descr_cur IS
8577: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name