APPS.PSP_SUM_ADJ dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1592: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

1588: AND run_id = nvl(g_run_id, run_id);
1589:
1590: gl_tie_back_rec gl_tie_back_cur%ROWTYPE;
1591:
1592: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1593: l_orig_org_id number;
1594:
1595: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1596: l_organization_id NUMBER(15);

Line 1595: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

1591:
1592: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1593: l_orig_org_id number;
1594:
1595: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1596: l_organization_id NUMBER(15);
1597: l_rowid ROWID;
1598: l_assignment_id NUMBER(9);
1599: l_distribution_date DATE;

Line 2762: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

2758: gms_interface_rec gms_interface_cursor%ROWTYPE;
2759: l_transaction_source VARCHAR2(30);
2760: l_expenditure_comment VARCHAR2(240);
2761: l_employee_number VARCHAR2(30);
2762: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2763: l_segment1 VARCHAR2(25);
2764: l_task_number VARCHAR2(25);
2765: l_gms_batch_name VARCHAR2(10);
2766: l_expenditure_ending_date DATE;

Line 2814: FROM hr_all_organization_units hou

2810: WHERE task_id = gms_interface_rec.task_id;
2811:
2812: CURSOR emp_org_name_cur IS
2813: SELECT name -- Bug 2447912: Removed SUBSTR function
2814: FROM hr_all_organization_units hou
2815: WHERE organization_id = gms_interface_rec.expenditure_organization_id;
2816:
2817: CURSOR project_number_cur IS
2818: SELECT segment1, org_id

Line 3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3405: from psp_summary_lines
3406: where payroll_control_id = p_payroll_control_id
3407: and gms_batch_name = p_gms_batch_name);
3408:
3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3410: l_orig_org_id1 number;
3411:
3412: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3413: l_organization_id NUMBER(15);

Line 3412: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3408:
3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3410: l_orig_org_id1 number;
3411:
3412: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3413: l_organization_id NUMBER(15);
3414: l_rowid ROWID;
3415: l_assignment_id NUMBER(9);
3416: l_distribution_date DATE;

Line 3441: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3437: l_trx_reject_code VARCHAR2(30);
3438: l_orig_trx_reference VARCHAR2(30);
3439: l_effective_date DATE;
3440:
3441: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3442: x_susp_failed_reject_code VARCHAR2(30);
3443: x_susp_failed_date DATE;
3444: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3445: x_susp_nf_date DATE;

Line 3444: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3440:
3441: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3442: x_susp_failed_reject_code VARCHAR2(30);
3443: x_susp_failed_date DATE;
3444: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3445: x_susp_nf_date DATE;
3446: l_return_status VARCHAR2(10);
3447: l_msg_id number(9);
3448: x_update_count number(9);