APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on HR_GENERAL

Line 549: hr_general.end_of_time)

545: AND hou.organization_id = hoi1.organization_id
546: AND hoi1.organization_id = hoi2.organization_id
547: AND ppa.effective_date BETWEEN hou.date_from
548: AND nvl(hou.date_to,
549: hr_general.end_of_time)
550: AND hoi1.org_information_context = 'CLASS'
551: AND hoi1.org_information1 = 'HR_BG'
552: AND hoi2.org_information_context = 'Business Group Information'
553: AND ppa.action_type = 'X'

Line 812: HR_GENERAL2.mask_characters(csr_get_archived_info_rec.action_information7);');

808:
809: build_sql(sqlstr,
810: l_cntr_sql,
811: 'csr_get_archived_info_rec.action_information7 :=
812: HR_GENERAL2.mask_characters(csr_get_archived_info_rec.action_information7);');
813: END IF;
814:
815: build_sql(sqlstr,
816: l_cntr_sql,

Line 1304: hr_general.end_of_time)

1300: AND hou.organization_id = hoi1.organization_id
1301: AND hoi1.organization_id = hoi2.organization_id
1302: AND ppa.effective_date BETWEEN hou.date_from
1303: AND nvl(hou.date_to,
1304: hr_general.end_of_time)
1305: AND hoi1.org_information_context = 'CLASS'
1306: AND hoi1.org_information1 = 'HR_BG'
1307: AND hoi2.org_information_context = 'Business Group Information'
1308: AND ppa.action_type = 'X'