APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on HR_ORGANIZATION_INFORMATION

Line 1013: SELECT 'Y' FROM hr_organization_information hoi

1009: ln_business_group_id NUMBER; -- Added for bug 8643214
1010:
1011: --New cursor defined for bug 8550075
1012: CURSOR c_get_view_date_criteria (cp_bg_id IN NUMBER) IS
1013: SELECT 'Y' FROM hr_organization_information hoi
1014: WHERE hoi.organization_id = cp_bg_id
1015: AND hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1016: AND ORG_INFORMATION12 = 'DATE_PAID'
1017: AND ORG_INFORMATION1 = 'PAYSLIP';

Line 1764: hr_organization_information hoi

1760:
1761: CURSOR c_currency_code is
1762: select hoi.org_information10
1763: from hr_organization_units hou,
1764: hr_organization_information hoi
1765: where hou.organization_id = p_business_group_id /* Bug 3487250 */
1766: and hou.organization_id = hoi.organization_id
1767: and hoi.org_information_context = 'Business Group Information';
1768:

Line 1859: from hr_organization_information

1855: and lei_information1 = upper(p_doc_type);
1856:
1857: CURSOR get_org_eit (l_organization_id number) IS
1858: select org_information2,org_information3
1859: from hr_organization_information
1860: where org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
1861: and org_information1 = upper(p_doc_type)
1862: and organization_id = l_organization_id;
1863:

Line 1866: from hr_organization_information hoi

1862: and organization_id = l_organization_id;
1863:
1864: CURSOR get_bg_eit (l_business_group_id number) IS
1865: select org_information2, org_information3
1866: from hr_organization_information hoi
1867: where hoi.organization_id = l_business_group_id
1868: and hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1869: and hoi.org_information1 = upper(p_doc_type) ;
1870:

Line 2294: hr_organization_information

2290: CURSOR cur_legislation_code is
2291: select
2292: org_information9
2293: from
2294: hr_organization_information
2295: where
2296: org_information_context = 'Business Group Information'
2297: and organization_id = p_business_group_id;
2298:

Line 2299: l_legislation_code hr_organization_information.org_information9%TYPE;

2295: where
2296: org_information_context = 'Business Group Information'
2297: and organization_id = p_business_group_id;
2298:
2299: l_legislation_code hr_organization_information.org_information9%TYPE;
2300:
2301: BEGIN
2302:
2303: OPEN cur_legislation_code;

Line 2529: from hr_organization_information hoi

2525: RETURN VARCHAR2 IS
2526:
2527: cursor cur_legislation(p_business_grp_id in number) is
2528: select hoi.org_information9
2529: from hr_organization_information hoi
2530: where hoi.organization_id = p_business_grp_id
2531: and hoi.org_information_context = 'Business Group Information';
2532:
2533: cursor cur_payment_typ(p_legislation_code in varchar2

Line 2986: SELECT 'Y' FROM hr_organization_information hoi

2982:
2983:
2984: --New cursor defined for bug 8550075
2985: CURSOR c_get_view_date_criteria (cp_bg_id IN NUMBER) IS
2986: SELECT 'Y' FROM hr_organization_information hoi
2987: WHERE hoi.organization_id = cp_bg_id
2988: AND hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
2989: AND ORG_INFORMATION12 = 'DATE_PAID'
2990: AND ORG_INFORMATION1 = 'PAYSLIP';