APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_SOFT_CODING_KEYFLEX

Line 425: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE

421: p_location_id IN per_all_assignments_f.location_id%TYPE,
422: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
423: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
424: p_person_id IN per_all_people_f.person_id%TYPE,
425: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
426: )
427: RETURN VARCHAR2
428: IS
429: l_proc CONSTANT proc_name := g_package || 'where_clause';

Line 493: hr_soft_coding_keyflex hsk

489: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
490: [DETAIL_BLOCK.RESOURCE_ID]
491: {in (select paa.person_id
492: from per_all_assignments_f paa,
493: hr_soft_coding_keyflex hsk
494: where paa.business_group_id = '
495: || p_bg_id
496: || l_person
497: || l_payroll