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.PER_IN_ASG_LEG_HOOK dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 58: FROM hr_all_organization_units_tl

54: IS
55:
56: CURSOR c_org_name (p_org_id IN NUMBER) IS
57: SELECT name
58: FROM hr_all_organization_units_tl
59: WHERE organization_id = p_org_id
60: AND language = userenv('LANG');
61:
62: CURSOR c_previous_gre IS

Line 72: l_pf_org hr_all_organization_units_tl.name%TYPE;

68: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
69: AND ses.session_id = userenv('SESSIONID')
70: AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
71:
72: l_pf_org hr_all_organization_units_tl.name%TYPE;
73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;

Line 73: l_gre_org hr_all_organization_units_tl.name%TYPE;

69: AND ses.session_id = userenv('SESSIONID')
70: AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
71:
72: l_pf_org hr_all_organization_units_tl.name%TYPE;
73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;
77: l_esi_id hr_all_organization_units_tl.name%TYPE;

Line 74: l_esi_org hr_all_organization_units_tl.name%TYPE;

70: AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
71:
72: l_pf_org hr_all_organization_units_tl.name%TYPE;
73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;
77: l_esi_id hr_all_organization_units_tl.name%TYPE;
78: l_message VARCHAR2(255);

Line 75: l_gre_id hr_all_organization_units_tl.name%TYPE;

71:
72: l_pf_org hr_all_organization_units_tl.name%TYPE;
73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;
77: l_esi_id hr_all_organization_units_tl.name%TYPE;
78: l_message VARCHAR2(255);
79: l_procedure VARCHAR2(100);

Line 76: l_pf_id hr_all_organization_units_tl.name%TYPE;

72: l_pf_org hr_all_organization_units_tl.name%TYPE;
73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;
77: l_esi_id hr_all_organization_units_tl.name%TYPE;
78: l_message VARCHAR2(255);
79: l_procedure VARCHAR2(100);
80: g_gre_id NUMBER;

Line 77: l_esi_id hr_all_organization_units_tl.name%TYPE;

73: l_gre_org hr_all_organization_units_tl.name%TYPE;
74: l_esi_org hr_all_organization_units_tl.name%TYPE;
75: l_gre_id hr_all_organization_units_tl.name%TYPE;
76: l_pf_id hr_all_organization_units_tl.name%TYPE;
77: l_esi_id hr_all_organization_units_tl.name%TYPE;
78: l_message VARCHAR2(255);
79: l_procedure VARCHAR2(100);
80: g_gre_id NUMBER;
81: g_pf_id NUMBER;