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

Line 1744: FROM hr_all_organization_units hou, psp_organization_accounts poa

1740: -- Get the Organization details ...
1741:
1742: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
1743: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
1744: FROM hr_all_organization_units hou, psp_organization_accounts poa
1745: WHERE hou.organization_id = poa.organization_id
1746: AND poa.business_group_id = p_business_group_id
1747: AND poa.set_of_books_id = p_set_of_books_id
1748: AND poa.organization_account_id = p_org_id;

Line 1752: FROM hr_all_organization_units hou,

1748: AND poa.organization_account_id = p_org_id;
1749:
1750: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
1751: SELECT hou.organization_id, hou.name
1752: FROM hr_all_organization_units hou,
1753: per_assignments_f paf,
1754: psp_payroll_lines ppl,
1755: psp_payroll_sub_lines ppsl,
1756: psp_distribution_lines pdl

Line 1767: FROM hr_all_organization_units hou,

1763: AND pdl.distribution_date between
1764: hou.date_from and nvl(hou.date_to,pdl.distribution_date)
1765: UNION
1766: SELECT hou.organization_id, hou.name
1767: FROM hr_all_organization_units hou,
1768: per_assignments_f paf,
1769: psp_pre_gen_dist_lines ppgd
1770: WHERE ppgd.pre_gen_dist_line_id = p_line_id
1771: AND ppgd.assignment_id = paf.assignment_id

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 1903: hr_all_organization_units hou

1899: hou.name
1900: from per_all_people_f ppf,
1901: per_all_assignments_f paf,
1902: pay_element_types_f pet,
1903: hr_all_organization_units hou
1904: where ppf.person_id = l_person_id
1905: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
1906: and paf.assignment_id = l_assignment_id
1907: and l_distribution_date between paf.effective_start_date and paf.effective_end_date

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 3717: FROM hr_all_organization_units hou

3713: BEGIN
3714: -- SELECT substr(name,1,60) Commented for bug fix 2447912
3715: SELECT name -- Removed SUBSTR for bug fix 2447912
3716: INTO l_org_name
3717: FROM hr_all_organization_units hou
3718: WHERE organization_id = gms_interface_rec.expenditure_organization_id;
3719: EXCEPTION
3720: WHEN NO_DATA_FOUND THEN
3721: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);

Line 4085: FROM hr_all_organization_units hou, psp_organization_accounts poa

4081: WHERE ppgd.summary_line_id = p_summary_line_id;
4082:
4083: CURSOR get_susp_org_cur1 (P_ORG_ID IN VARCHAR2) IS
4084: SELECT hou.organization_id, hou.name
4085: FROM hr_all_organization_units hou, psp_organization_accounts poa
4086: WHERE hou.organization_id = poa.organization_id
4087: AND poa.business_group_id = p_business_group_id
4088: AND poa.set_of_books_id = p_set_of_books_id
4089: AND poa.organization_account_id = p_org_id;

Line 4093: FROM hr_all_organization_units hou,

4089: AND poa.organization_account_id = p_org_id;
4090:
4091: CURSOR get_org_id_cur1 (P_LINE_ID IN NUMBER) IS
4092: SELECT hou.organization_id, hou.name
4093: FROM hr_all_organization_units hou,
4094: per_assignments_f paf,
4095: psp_payroll_lines ppl,
4096: psp_payroll_sub_lines ppsl,
4097: psp_distribution_lines pdl

Line 4106: FROM hr_all_organization_units hou,

4102: AND ppl.payroll_line_id = ppsl.payroll_line_id
4103: AND pdl.distribution_date between paf.effective_start_date and paf.effective_end_date
4104: UNION
4105: SELECT hou.organization_id, hou.name
4106: FROM hr_all_organization_units hou,
4107: per_assignments_f paf,
4108: psp_pre_gen_dist_lines ppgdl
4109: WHERE paf.assignment_id = ppgdl.assignment_id
4110: AND hou.organization_id = paf.organization_id

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,

Line 4244: hr_all_organization_units hou

4240: hou.name
4241: from per_all_people_f ppf,
4242: per_all_assignments_f paf,
4243: pay_element_types_f pet,
4244: hr_all_organization_units hou
4245: where ppf.person_id = l_person_id
4246: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
4247: and paf.assignment_id = l_assignment_id
4248: and l_distribution_date between paf.effective_start_date and paf.effective_end_date