APPS.PAY_NL_GENERAL dependencies on HR_ORGANIZATION_INFORMATION

Line 628: from hr_organization_information hoi

624:
625: Cursor c_retro_method(p_business_group_id in number)
626: is
627: Select hoi.org_information2
628: from hr_organization_information hoi
629: where hoi.org_information_context = 'NL_BG_INFO'
630: and hoi.organization_id = p_business_group_id;
631:
632:

Line 1870: FROM hr_organization_information

1866: AND (pog2.start_date <= c_end_date AND pog2.end_date >= c_start_date);
1867: --
1868: CURSOR csr_get_late_starter_flag(c_business_group_id NUMBER) IS
1869: SELECT org_information7
1870: FROM hr_organization_information
1871: WHERE organization_id = c_business_group_id
1872: AND org_information_context = 'NL_BG_INFO';
1873: --
1874: CURSOR csr_chk_element_entry(c_parent_id NUMBER

Line 2055: FROM hr_organization_information

2051: AND (pog2.start_date <= c_end_date AND pog2.end_date >= c_start_date);
2052: --
2053: CURSOR csr_get_late_starter_flag(c_business_group_id NUMBER) IS
2054: SELECT org_information7
2055: FROM hr_organization_information
2056: WHERE organization_id = c_business_group_id
2057: AND org_information_context = 'NL_BG_INFO';
2058: --
2059: CURSOR csr_chk_element_entry(c_parent_id NUMBER

Line 2286: FROM hr_organization_information

2282: AND (pog2.start_date <= c_end_date AND pog2.end_date >= c_start_date));
2283: --
2284: CURSOR csr_get_late_starter_flag(c_business_group_id NUMBER) IS
2285: SELECT org_information7
2286: FROM hr_organization_information
2287: WHERE organization_id = c_business_group_id
2288: AND org_information_context = 'NL_BG_INFO';
2289: --
2290: CURSOR csr_chk_element_entry(c_ass_id NUMBER

Line 2524: FROM hr_organization_information

2520: AND (pog2.start_date <= c_end_date AND pog2.end_date >= c_start_date));
2521: --
2522: CURSOR csr_get_late_starter_flag(c_business_group_id NUMBER) IS
2523: SELECT org_information7
2524: FROM hr_organization_information
2525: WHERE organization_id = c_business_group_id
2526: AND org_information_context = 'NL_BG_INFO';
2527: --
2528: CURSOR csr_chk_element_entry(c_ass_id NUMBER