eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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

1771: AND ppgd.assignment_id = paf.assignment_id
1772: AND ppgd.distribution_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1773: AND paf.organization_id = hou.organization_id;
1774:
1775: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1776: l_orig_org_id number;
1777:
1778: -- End of Get org id cursor Ravindra
1779:

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

1812: AND p_distribution_date BETWEEN poa.start_date_active AND
1813: nvl(poa.end_date_active,p_distribution_date); Bug 2056877.*/
1814: organization_account_id = p_organization_account_id; --Added for bug 2056877.
1815:
1816: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1817: l_organization_id NUMBER(15);
1818: l_rowid ROWID;
1819: l_assignment_id NUMBER(15);
1820: l_distribution_date DATE;

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

1842: l_dr_summary_amount NUMBER := 0;
1843: l_cr_summary_amount NUMBER := 0;
1844: l_dr_cr_flag VARCHAR2(1);
1845: l_effective_date DATE;
1846: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1847: x_susp_failed_status VARCHAR2(50);
1848: x_susp_failed_date DATE;
1849: x_lines_glccid NUMBER(15);
1850: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

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

1846: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1847: x_susp_failed_status VARCHAR2(50);
1848: x_susp_failed_date DATE;
1849: x_lines_glccid NUMBER(15);
1850: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1851: x_susp_nf_date DATE;
1852: l_return_status VARCHAR2(10);
1853: x_line_id NUMBER;
1854: l_no_run number;

Line 1874: l_auto_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

1870: l_assignment_number varchar2(100);
1871: l_element_type varchar2(200);
1872: l_person_name varchar2(300);
1873: l_account varchar2(1000);
1874: l_auto_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1875:
1876: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
1877:
1878: cursor get_element_type is

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

3520: gms_interface_rec gms_interface_cursor%ROWTYPE;
3521: l_transaction_source VARCHAR2(30);
3522: l_expenditure_comment VARCHAR2(240);
3523: l_employee_number VARCHAR2(30);
3524: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3525: l_segment1 VARCHAR2(25);
3526: l_task_number VARCHAR2(25);
3527: l_gms_batch_name VARCHAR2(10);
3528: l_expenditure_ending_date DATE;

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

4110: AND hou.organization_id = paf.organization_id
4111: AND ppgdl.pre_gen_dist_line_id = p_line_id
4112: AND ppgdl.distribution_date between paf.effective_start_date and paf.effective_end_date;
4113:
4114: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4115: l_orig_org_id1 number;
4116:
4117: CURSOR org_susp_ac_cur(P_ORGANIZATION_ID IN NUMBER,
4118: P_DISTRIBUTION_DATE IN DATE) IS

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

4149: AND p_distribution_date BETWEEN poa.start_date_active AND
4150: nvl(poa.end_date_active,p_distribution_date);Bug 2056877 */
4151: organization_account_id = p_organization_account_id; --Added for bug 2056877.
4152:
4153: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4154: l_organization_id NUMBER(15);
4155: l_rowid ROWID;
4156: l_assignment_id NUMBER(15);
4157: l_distribution_date DATE;

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

4178: l_trx_reject_code VARCHAR2(30);
4179: l_orig_trx_reference VARCHAR2(30);
4180: l_effective_date DATE;
4181:
4182: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4183: x_susp_failed_reject_code VARCHAR2(30);
4184: x_susp_failed_date DATE;
4185: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4186: x_susp_nf_date DATE;

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

4181:
4182: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4183: x_susp_failed_reject_code VARCHAR2(30);
4184: x_susp_failed_date DATE;
4185: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4186: x_susp_nf_date DATE;
4187: l_return_status VARCHAR2(10);
4188: x_line_id NUMBER;
4189: l_no_run NUMBER;

Line 4216: l_auto_org_name hr_all_organization_units_tl.name%TYPE;

4212: l_assignment_number varchar2(100);
4213: l_element_type varchar2(200);
4214: l_person_name varchar2(300);
4215: l_account varchar2(1000);
4216: l_auto_org_name hr_all_organization_units_tl.name%TYPE;
4217: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
4218:
4219: cursor get_element_type is
4220: select ppl.element_type_id,