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 1514: from per_all_assignments_f paa,fnd_sessions ses

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

Line 1538: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1622: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1700: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1772: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1848: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1923: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 1981: from per_all_assignments_f paa,fnd_sessions ses

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

Line 2001: l_org_id per_all_assignments_f.organization_id%TYPE;

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

Line 2070: from per_all_assignments_f paa,fnd_sessions ses

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

Line 2091: l_org_id per_all_assignments_f.organization_id%TYPE;

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