eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 325: p_location_id IN per_all_assignments_f.location_id%TYPE,

321: END process_bee_batches;
322:
323: FUNCTION where_clause (
324: p_bg_id IN hr_all_organization_units.business_group_id%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

Line 326: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,

322:
323: FUNCTION where_clause (
324: p_bg_id IN hr_all_organization_units.business_group_id%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: )

Line 327: p_organization_id IN per_all_assignments_f.organization_id%TYPE,

323: FUNCTION where_clause (
324: p_bg_id IN hr_all_organization_units.business_group_id%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

Line 383: from per_all_assignments_f paa

379: l_where_clause :=
380: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
381: [DETAIL_BLOCK.RESOURCE_ID]
382: {in (select paa.person_id
383: from per_all_assignments_f paa
384: where paa.business_group_id = '
385: || p_bg_id
386: || l_person
387: || l_payroll

Line 396: from per_all_assignments_f paa,

392: l_where_clause :=
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

Line 2050: per_all_assignments_f paf,

2046: assignment_id )
2047: in ( SELECT date_earned,
2048: assignment_id
2049: FROM hxc_bee_pref_adj_lines,
2050: per_all_assignments_f paf,
2051: per_assignment_status_types pas
2052: WHERE resource_id = person_id
2053: AND batch_source = 'OTM'
2054: AND paf.effective_end_date = hr_general.end_of_time

Line 2081: per_all_assignments_f paf

2077: WHERE (date_worked ,assignment_id) in
2078: ( SELECT date_earned,
2079: paf.assignment_id
2080: FROM hxc_bee_pref_adj_lines hoa,
2081: per_all_assignments_f paf
2082: WHERE hoa.resource_id = paf.person_id
2083: AND hoa.date_earned BETWEEN paf.effective_start_date
2084: AND paf.effective_end_date
2085: AND paf.primary_flag = 'Y');