APPS.PAY_KR_YEA_PDF_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 410: from hr_organization_information hoi

406: cursor csr_pdf_setup
407: is
408: select hoi.org_information1 import_path,
409: hoi.org_information2 nts_certs_path
410: from hr_organization_information hoi
411: where hoi.organization_id = p_business_group_id
412: and hoi.org_information_context = 'KR_YEA_PDF_SETUP_BG';
413: --
414: begin

Line 500: l_nts_certs_path hr_organization_information.org_information2%type;

496: is
497: --
498: l_proc varchar2(80) := c_package||'import_init';
499: --
500: l_nts_certs_path hr_organization_information.org_information2%type;
501: --
502: begin
503: --
504: if g_debug then

Line 662: l_import_path hr_organization_information.org_information1%type;

658: is
659: --
660: l_proc varchar2(80) := c_package||'upload_init';
661: --
662: l_import_path hr_organization_information.org_information1%type;
663: --
664: begin
665: --
666: if g_debug then

Line 7008: hr_organization_information hoi,

7004: pp.employee_number emp_num
7005: from per_people_f pp,
7006: per_periods_of_service ppos,
7007: per_assignments_f pa,
7008: hr_organization_information hoi,
7009: per_business_groups_perf pbg
7010: where pbg.legislation_code = c_legislation_code
7011: and pbg.business_group_id = nvl(g_business_group_id,pbg.business_group_id)
7012: and hoi.organization_id = pbg.business_group_id