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 1885: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

1881: AND ppgd.assignment_id = paf.assignment_id
1882: AND ppgd.distribution_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1883: AND paf.organization_id = hou.organization_id;
1884:
1885: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1886: l_orig_org_id number;
1887:
1888: -- End of Get org id cursor Ravindra
1889:

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

1922: AND p_distribution_date BETWEEN poa.start_date_active AND
1923: nvl(poa.end_date_active,p_distribution_date); Bug 2056877.*/
1924: organization_account_id = p_organization_account_id; --Added for bug 2056877.
1925:
1926: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1927: l_organization_id NUMBER(15);
1928: l_rowid ROWID;
1929: l_assignment_id NUMBER(15);
1930: l_distribution_date DATE;

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

1952: l_dr_summary_amount NUMBER := 0;
1953: l_cr_summary_amount NUMBER := 0;
1954: l_dr_cr_flag VARCHAR2(1);
1955: l_effective_date DATE;
1956: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1957: x_susp_failed_status VARCHAR2(50);
1958: x_susp_failed_date DATE;
1959: x_lines_glccid NUMBER(15);
1960: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

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

1956: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1957: x_susp_failed_status VARCHAR2(50);
1958: x_susp_failed_date DATE;
1959: x_lines_glccid NUMBER(15);
1960: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1961: x_susp_nf_date DATE;
1962: l_return_status VARCHAR2(10);
1963: x_line_id NUMBER;
1964: l_no_run number;

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

1980: l_assignment_number varchar2(100);
1981: l_element_type varchar2(200);
1982: l_person_name varchar2(300);
1983: l_account varchar2(1000);
1984: l_auto_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1985:
1986: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
1987:
1988: cursor get_element_type is

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

3711: gms_interface_rec gms_interface_cursor%ROWTYPE;
3712: l_transaction_source VARCHAR2(30);
3713: l_expenditure_comment VARCHAR2(240);
3714: l_employee_number VARCHAR2(30);
3715: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3716: l_segment1 VARCHAR2(25);
3717: l_task_number VARCHAR2(300); -- Bug 16391366 (27/03/2013)
3718: l_gms_batch_name VARCHAR2(10);
3719: l_expenditure_ending_date DATE;

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

4373: AND hou.organization_id = paf.organization_id
4374: AND ppgdl.pre_gen_dist_line_id = p_line_id
4375: AND ppgdl.distribution_date between paf.effective_start_date and paf.effective_end_date;
4376:
4377: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4378: l_orig_org_id1 number;
4379:
4380: CURSOR org_susp_ac_cur(P_ORGANIZATION_ID IN NUMBER,
4381: P_DISTRIBUTION_DATE IN DATE) IS

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

4412: AND p_distribution_date BETWEEN poa.start_date_active AND
4413: nvl(poa.end_date_active,p_distribution_date);Bug 2056877 */
4414: organization_account_id = p_organization_account_id; --Added for bug 2056877.
4415:
4416: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4417: l_organization_id NUMBER(15);
4418: l_rowid ROWID;
4419: l_assignment_id NUMBER(15);
4420: l_distribution_date DATE;

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

4441: l_trx_reject_code VARCHAR2(30);
4442: l_orig_trx_reference VARCHAR2(30);
4443: l_effective_date DATE;
4444:
4445: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4446: x_susp_failed_reject_code VARCHAR2(30);
4447: x_susp_failed_date DATE;
4448: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4449: x_susp_nf_date DATE;

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

4444:
4445: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4446: x_susp_failed_reject_code VARCHAR2(30);
4447: x_susp_failed_date DATE;
4448: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
4449: x_susp_nf_date DATE;
4450: l_return_status VARCHAR2(10);
4451: x_line_id NUMBER;
4452: l_no_run NUMBER;

Line 4479: l_auto_org_name hr_all_organization_units_tl.name%TYPE;

4475: l_assignment_number varchar2(100);
4476: l_element_type varchar2(200);
4477: l_person_name varchar2(300);
4478: l_account varchar2(1000);
4479: l_auto_org_name hr_all_organization_units_tl.name%TYPE;
4480: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
4481:
4482: cursor get_element_type is
4483: select ppl.element_type_id,