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.HR_NL_ORG_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 626: from per_all_assignments_f paa,fnd_sessions ses

622:
623: --Determine the Organization Id of the Employees Assignment
624: CURSOR get_org_id(p_assignment_id number) is
625: select paa.organization_id
626: from per_all_assignments_f paa,fnd_sessions ses
627: where paa.assignment_id = p_assignment_id and
628: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
629: session_id = userenv('sessionid');
630:

Line 631: l_org_id per_all_assignments_f.organization_id%TYPE;

627: where paa.assignment_id = p_assignment_id and
628: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
629: session_id = userenv('sessionid');
630:
631: l_org_id per_all_assignments_f.organization_id%TYPE;
632: l_provider_id hr_organization_units.organization_id%TYPE;
633:
634: BEGIN
635:

Line 756: from per_all_assignments_f paa,fnd_sessions ses

752: --Determine the Organization Id of the Employees Assignment
753: --
754: CURSOR get_org_id(p_assignment_id number) is
755: select paa.organization_id
756: from per_all_assignments_f paa,fnd_sessions ses
757: where paa.assignment_id = p_assignment_id and
758: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
759: session_id = userenv('sessionid');
760:

Line 780: l_org_id per_all_assignments_f.organization_id%TYPE;

776: --Local Variables
777: --
778: l_avg_days Number;
779: v_avg_days Avg_Days_Per_Month%ROWTYPE;
780: l_org_id per_all_assignments_f.organization_id%TYPE;
781: l_organization_id hr_organization_units.organization_id%TYPE;
782: l_level number;
783:
784: BEGIN

Line 931: from per_all_assignments_f paa,fnd_sessions ses

927: --Determine the Organization Id of the Employees Assignment
928: --
929: CURSOR get_org_id(p_assignment_id number) is
930: select paa.organization_id
931: from per_all_assignments_f paa,fnd_sessions ses
932: where paa.assignment_id = p_assignment_id and
933: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
934: session_id = userenv('sessionid');
935:

Line 955: l_org_id per_all_assignments_f.organization_id%TYPE;

951: --Local Variables
952: --
953: l_working_hrs Number;
954: v_hrs_per_week Working_hours_Per_Week%ROWTYPE;
955: l_org_id per_all_assignments_f.organization_id%TYPE;
956: l_organization_id hr_organization_units.organization_id%TYPE;
957: l_level number;
958:
959: BEGIN

Line 1024: from per_all_assignments_f paa,fnd_sessions ses

1020: --Determine the Organization Id of the Employees Assignment
1021: --
1022: CURSOR get_org_id(p_assignment_id number) is
1023: select paa.organization_id
1024: from per_all_assignments_f paa,fnd_sessions ses
1025: where paa.assignment_id = p_assignment_id and
1026: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1027: session_id = userenv('sessionid');
1028:

Line 1048: l_org_id per_all_assignments_f.organization_id%TYPE;

1044: --Local Variables
1045: --
1046: l_part_time_per Number;
1047: v_part_time_per Part_Time_Percentage_Method%ROWTYPE;
1048: l_org_id per_all_assignments_f.organization_id%TYPE;
1049: l_organization_id hr_organization_units.organization_id%TYPE;
1050: l_level number;
1051:
1052: BEGIN

Line 1121: from per_all_assignments_f paa,fnd_sessions ses

1117: --Determine the Organization Id of the Employees Assignment
1118: --
1119: CURSOR get_org_id(p_assignment_id number) is
1120: select paa.organization_id
1121: from per_all_assignments_f paa,fnd_sessions ses
1122: where paa.assignment_id = p_assignment_id and
1123: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1124: session_id = userenv('sessionid');
1125:

Line 1145: l_org_id per_all_assignments_f.organization_id%TYPE;

1141: --Local Variables
1142: --
1143: l_lunar_method Number;
1144: v_lunar_method Lunar_5_Week_Month_Wage_Method%ROWTYPE;
1145: l_org_id per_all_assignments_f.organization_id%TYPE;
1146: l_organization_id hr_organization_units.organization_id%TYPE;
1147: l_level number;
1148:
1149: BEGIN

Line 1216: from per_all_assignments_f paa,fnd_sessions ses

1212: --Determine the Organization Id of the Employees Assignment
1213: --
1214: CURSOR get_org_id(p_assignment_id number) is
1215: select paa.organization_id
1216: from per_all_assignments_f paa,fnd_sessions ses
1217: where paa.assignment_id = p_assignment_id and
1218: ses.effective_date between paa.effective_start_date
1219: and paa.effective_end_date and
1220: session_id = userenv('sessionid');

Line 1241: l_org_id per_all_assignments_f.organization_id%TYPE;

1237: --Local Variables
1238: --
1239: l_Pro_Tax_Table hr_organization_information.ORG_INFORMATION10%TYPE;
1240: v_Pro_Tax_Table cur_Pro_Tax_Table%ROWTYPE;
1241: l_org_id per_all_assignments_f.organization_id%TYPE;
1242: l_organization_id hr_organization_units.organization_id%TYPE;
1243: l_level number;
1244:
1245: BEGIN

Line 1515: from per_all_assignments_f paa,fnd_sessions ses

1511: --Determine the Organization Id of the Employees Assignment
1512: --
1513: CURSOR get_org_id(p_assignment_id number) is
1514: select paa.organization_id
1515: from per_all_assignments_f paa,fnd_sessions ses
1516: where paa.assignment_id = p_assignment_id and
1517: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1518: session_id = userenv('sessionid');
1519:

Line 1539: l_org_id per_all_assignments_f.organization_id%TYPE;

1535: --Local Variables
1536: --
1537: l_parental_leave_perc Number;
1538: v_csr_par_leave csr_Parental_Leave_Perc%ROWTYPE;
1539: l_org_id per_all_assignments_f.organization_id%TYPE;
1540: l_organization_id hr_organization_units.organization_id%TYPE;
1541: l_level number;
1542:
1543: BEGIN

Line 1623: l_org_id per_all_assignments_f.organization_id%TYPE;

1619: --Local Variables
1620: --
1621: l_cbs_Rep_Freq hr_organization_information.ORG_INFORMATION15%TYPE;
1622: v_Rep_Freq_Table csr_cbs_rep_freq%ROWTYPE;
1623: l_org_id per_all_assignments_f.organization_id%TYPE;
1624: l_organization_id hr_organization_units.organization_id%TYPE;
1625: l_level number;
1626: BEGIN
1627: --

Line 1701: l_org_id per_all_assignments_f.organization_id%TYPE;

1697: --Local Variables
1698: --
1699: l_cbs_cust_num hr_organization_information.ORG_INFORMATION16%TYPE;
1700: v_cust_num_table csr_customer_number%ROWTYPE;
1701: l_org_id per_all_assignments_f.organization_id%TYPE;
1702: l_organization_id hr_organization_units.organization_id%TYPE;
1703: l_level number;
1704: BEGIN
1705: --

Line 1773: l_org_id per_all_assignments_f.organization_id%TYPE;

1769: --Local Variables
1770: --
1771: l_cbs_company_unit hr_organization_information.ORG_INFORMATION18%TYPE;
1772: v_company_unit_table csr_company_unit%ROWTYPE;
1773: l_org_id per_all_assignments_f.organization_id%TYPE;
1774: l_organization_id hr_organization_units.organization_id%TYPE;
1775: l_level number;
1776: BEGIN
1777: --

Line 1849: l_org_id per_all_assignments_f.organization_id%TYPE;

1845: --Local Variables
1846: --
1847: l_cbs_public_sector hr_organization_information.ORG_INFORMATION17%TYPE;
1848: v_public_sector_Table csr_public_sector_info%ROWTYPE;
1849: l_org_id per_all_assignments_f.organization_id%TYPE;
1850: l_organization_id hr_organization_units.organization_id%TYPE;
1851: l_level number;
1852: BEGIN
1853: --

Line 1924: l_org_id per_all_assignments_f.organization_id%TYPE;

1920: --Local Variables
1921: --
1922: l_full_wage_paid hr_organization_information.ORG_INFORMATION17%TYPE;
1923: v_full_sick_wage csr_full_wage_paid%ROWTYPE;
1924: l_org_id per_all_assignments_f.organization_id%TYPE;
1925: l_organization_id hr_organization_units.organization_id%TYPE;
1926: l_level number;
1927: BEGIN
1928: --

Line 1982: from per_all_assignments_f paa,fnd_sessions ses

1978: -- Determine the Organization Id of the Employees Assignment
1979: --
1980: CURSOR get_org_id(p_assignment_id number) is
1981: select paa.organization_id
1982: from per_all_assignments_f paa,fnd_sessions ses
1983: where paa.assignment_id = p_assignment_id and
1984: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1985: session_id = userenv('sessionid');
1986: CURSOR csr_IZA_Weekly_Hours

Line 2002: l_org_id per_all_assignments_f.organization_id%TYPE;

1998: --Local Variables
1999: --
2000: l_IZA_Weekly_Hours hr_organization_information.ORG_INFORMATION20%TYPE;
2001: v_IZA_Weekly_Hours_table csr_IZA_Weekly_Hours%ROWTYPE;
2002: l_org_id per_all_assignments_f.organization_id%TYPE;
2003: l_organization_id hr_organization_units.organization_id%TYPE;
2004: l_level number;
2005: BEGIN
2006: --

Line 2071: from per_all_assignments_f paa,fnd_sessions ses

2067: -- Determine the Organization Id of the Employees Assignment
2068: --
2069: CURSOR get_org_id(p_assignment_id number) is
2070: select paa.organization_id
2071: from per_all_assignments_f paa,fnd_sessions ses
2072: where paa.assignment_id = p_assignment_id and
2073: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2074: session_id = userenv('sessionid');
2075: --

Line 2092: l_org_id per_all_assignments_f.organization_id%TYPE;

2088: --Local Variables
2089: --
2090: l_IZA_Monthly_Hours hr_organization_information.ORG_INFORMATION12%TYPE;
2091: v_IZA_Monthly_Hours_table csr_IZA_Monthly_Hours%ROWTYPE;
2092: l_org_id per_all_assignments_f.organization_id%TYPE;
2093: l_organization_id hr_organization_units.organization_id%TYPE;
2094: l_level number;
2095: BEGIN
2096: --

Line 2304: from per_all_assignments_f paa,fnd_sessions ses

2300:
2301: --Determine the Organization Id of the Employees Assignment
2302: CURSOR get_org_id(p_assignment_id number) is
2303: select paa.organization_id
2304: from per_all_assignments_f paa,fnd_sessions ses
2305: where paa.assignment_id = p_assignment_id and
2306: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2307: session_id = userenv('sessionid');
2308:

Line 2309: l_org_id per_all_assignments_f.organization_id%TYPE;

2305: where paa.assignment_id = p_assignment_id and
2306: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2307: session_id = userenv('sessionid');
2308:
2309: l_org_id per_all_assignments_f.organization_id%TYPE;
2310: l_excluded_ind NUMBER;
2311:
2312: BEGIN
2313:

Line 2332: FROM per_all_assignments_f paa

2328: --Determine the Organization Id of the Employees Assignment
2329: --
2330: CURSOR csr_get_org_id(p_assignment_id NUMBER) IS
2331: SELECT paa.organization_id
2332: FROM per_all_assignments_f paa
2333: ,fnd_sessions ses
2334: WHERE paa.assignment_id = p_assignment_id
2335: AND ses.effective_date BETWEEN paa.effective_start_date
2336: AND paa.effective_end_date

Line 2350: l_org_id per_all_assignments_f.organization_id%TYPE;

2346: --Local Variables
2347: --
2348: v_csr_get_lhd_override csr_get_lhd_override%ROWTYPE;
2349: l_lhd_pro_override hr_organization_information.ORG_INFORMATION6%TYPE;
2350: l_org_id per_all_assignments_f.organization_id%TYPE;
2351: l_organization_id per_all_assignments_f.organization_id%TYPE; --15837938
2352: l_level number; --15837938
2353:
2354: BEGIN

Line 2351: l_organization_id per_all_assignments_f.organization_id%TYPE; --15837938

2347: --
2348: v_csr_get_lhd_override csr_get_lhd_override%ROWTYPE;
2349: l_lhd_pro_override hr_organization_information.ORG_INFORMATION6%TYPE;
2350: l_org_id per_all_assignments_f.organization_id%TYPE;
2351: l_organization_id per_all_assignments_f.organization_id%TYPE; --15837938
2352: l_level number; --15837938
2353:
2354: BEGIN
2355:

Line 2420: FROM per_all_assignments_f paa

2416: (p_assignment_id IN number) RETURN varchar2 IS
2417:
2418: CURSOR csr_get_org_id(p_assignment_id IN number) IS
2419: SELECT paa.organization_id
2420: FROM per_all_assignments_f paa
2421: ,fnd_sessions ses
2422: WHERE paa.assignment_id = p_assignment_id
2423: AND ses.effective_date
2424: BETWEEN paa.effective_start_date

Line 2438: l_org_id per_all_assignments_f.organization_id%TYPE;

2434:
2435: --Local Variable
2436: rec_get_bene_rul_sepa csr_get_bene_rul_sepa%ROWTYPE;
2437: l_benefi_rule hr_organization_information.org_information7%TYPE;
2438: l_org_id per_all_assignments_f.organization_id%TYPE;
2439: l_organization_id per_all_assignments_f.organization_id%TYPE;
2440: l_level number;
2441:
2442: BEGIN

Line 2439: l_organization_id per_all_assignments_f.organization_id%TYPE;

2435: --Local Variable
2436: rec_get_bene_rul_sepa csr_get_bene_rul_sepa%ROWTYPE;
2437: l_benefi_rule hr_organization_information.org_information7%TYPE;
2438: l_org_id per_all_assignments_f.organization_id%TYPE;
2439: l_organization_id per_all_assignments_f.organization_id%TYPE;
2440: l_level number;
2441:
2442: BEGIN
2443: