APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_SOFT_CODING_KEYFLEX

Line 329: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE

325: p_location_id IN per_all_assignments_f.location_id%TYPE,
326: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
327: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
328: p_person_id IN per_all_people_f.person_id%TYPE,
329: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
330: )
331: RETURN VARCHAR2
332: IS
333: l_proc CONSTANT proc_name := g_package || 'where_clause';

Line 397: hr_soft_coding_keyflex hsk

393: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
394: [DETAIL_BLOCK.RESOURCE_ID]
395: {in (select paa.person_id
396: from per_all_assignments_f paa,
397: hr_soft_coding_keyflex hsk
398: where paa.business_group_id = '
399: || p_bg_id
400: || l_person
401: || l_payroll