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.PAY_NO_EERR_CONTINUOUS dependencies on HR_ORGANIZATION_INFORMATION

Line 53: g_legal_employer_org_no hr_organization_information.org_information1%type;

49: g_hour_change_limit number := 0;
50: g_absence_termination_limit number := 0;
51: g_report_mode varchar2 (80);
52: g_legal_employer_name hr_all_organization_units.name%type;
53: g_legal_employer_org_no hr_organization_information.org_information1%type;
54: g_no_hours_change_weeks number;
55: /* GET PARAMETER */
56: function get_parameter (
57: p_parameter_string in varchar2,

Line 208: hr_organization_information hoi1

204: legal_employer_name, org.location_id,
205: hoi1.org_information1
206: legal_employer_org_no
207: from hr_all_organization_units org,
208: hr_organization_information hoi1
209: where org.organization_id = p_legal_employer_id
210: and hoi1.organization_id(+) = org.organization_id
211: and hoi1.org_information_context(+) = 'NO_LEGAL_EMPLOYER_DETAILS';
212:

Line 216: csr_v_legal_employer_id hr_organization_information.organization_id%type

212:
213: l_legal_employer_rec csr_legal_employers%rowtype;
214:
215: cursor csr_all_local_unit_details (
216: csr_v_legal_employer_id hr_organization_information.organization_id%type
217: ) is
218: select hoi_le.org_information1 local_unit_id,
219: hou_lu.name
220: local_unit_name,

Line 224: hr_organization_information hoi_le,

220: local_unit_name,
221: hoi_lu.org_information1
222: local_unit_org_no, hou_lu.location_id
223: from hr_all_organization_units hou_le,
224: hr_organization_information hoi_le,
225: hr_all_organization_units hou_lu,
226: hr_organization_information hoi_lu
227: where hoi_le.organization_id = hou_le.organization_id
228: and hou_le.organization_id = csr_v_legal_employer_id

Line 226: hr_organization_information hoi_lu

222: local_unit_org_no, hou_lu.location_id
223: from hr_all_organization_units hou_le,
224: hr_organization_information hoi_le,
225: hr_all_organization_units hou_lu,
226: hr_organization_information hoi_lu
227: where hoi_le.organization_id = hou_le.organization_id
228: and hou_le.organization_id = csr_v_legal_employer_id
229: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
230: and hou_lu.organization_id = hoi_le.org_information1

Line 335: csr_v_legal_employer_id hr_organization_information.organization_id%type

331: and p_effective_date between effective_start_date and effective_end_date ;
332:
333: /* Cursor to get Local Unit Details based on the Legal Employers */
334: cursor csr_all_local_unit_details (
335: csr_v_legal_employer_id hr_organization_information.organization_id%type
336: ) is
337: select hoi_le.org_information1 local_unit_id,
338: hou_lu.name
339: local_unit_name,

Line 343: hr_organization_information hoi_le,

339: local_unit_name,
340: hoi_lu.org_information1
341: local_unit_org_no, hou_lu.location_id
342: from hr_all_organization_units hou_le,
343: hr_organization_information hoi_le,
344: hr_all_organization_units hou_lu,
345: hr_organization_information hoi_lu
346: where hoi_le.organization_id = hou_le.organization_id
347: and hou_le.organization_id = csr_v_legal_employer_id

Line 345: hr_organization_information hoi_lu

341: local_unit_org_no, hou_lu.location_id
342: from hr_all_organization_units hou_le,
343: hr_organization_information hoi_le,
344: hr_all_organization_units hou_lu,
345: hr_organization_information hoi_lu
346: where hoi_le.organization_id = hou_le.organization_id
347: and hou_le.organization_id = csr_v_legal_employer_id
348: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
349: and hou_lu.organization_id = hoi_le.org_information1

Line 662: from hr_organization_information hoi, hr_soft_coding_keyflex hsc

658: cursor csr_get_org_no (
659: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type
660: ) is
661: select org_information1
662: from hr_organization_information hoi, hr_soft_coding_keyflex hsc
663: where org_information_context = 'NO_LOCAL_UNIT_DETAILS'
664: and hsc.segment2 = organization_id
665: and soft_coding_keyflex_id = p_soft_coding_keyflex_id;
666:

Line 923: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi

919: cursor curr_lu_org_number (
920: p_assignment_id per_all_assignments_f.assignment_id%type,
921: p_effective_date date ) is
922: select org_information1
923: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc,hr_organization_information hoi
924: where paaf.assignment_id = p_assignment_id
925: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
926: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
927: and hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS'

Line 1000: l_lu_org_no hr_organization_information.org_information1%type;

996: l_hour_value_reported number := 0;
997: l_user_status per_assignment_status_types.PER_SYSTEM_STATUS%type;
998: l_last_update_date date;
999: l_alter_change char (1);
1000: l_lu_org_no hr_organization_information.org_information1%type;
1001: l_hour_element_entry_id number;
1002: l_new_job_value varchar2 (100);
1003: l_old_job_value varchar2 (100);
1004: l_normal_hours number;

Line 1038: l_local_unit_org_no hr_organization_information.org_information1%type; /* 5519990 */

1034: l_hour_old_value number;
1035: l_prev_hour_value_primary number;
1036: l_prev_hour_eff_date date;
1037: l_lu_change_flag char (1); /* 5519990 */
1038: l_local_unit_org_no hr_organization_information.org_information1%type; /* 5519990 */
1039: l_national_identifier per_all_people_f.national_identifier%type; /* 5526181 */
1040: l_old_date date;
1041: l_curr_hours number;
1042: l_curr_frequency per_all_assignments_f.frequency%type;