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 421: p_location_id IN per_all_assignments_f.location_id%TYPE,

417: END process_bee_batches;
418:
419: FUNCTION where_clause (
420: p_bg_id IN hr_all_organization_units.business_group_id%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

Line 422: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,

418:
419: FUNCTION where_clause (
420: p_bg_id IN hr_all_organization_units.business_group_id%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: )

Line 423: p_organization_id IN per_all_assignments_f.organization_id%TYPE,

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

Line 479: from per_all_assignments_f paa

475: l_where_clause :=
476: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
477: [DETAIL_BLOCK.RESOURCE_ID]
478: {in (select paa.person_id
479: from per_all_assignments_f paa
480: where paa.business_group_id = '
481: || p_bg_id
482: || l_person
483: || l_payroll

Line 492: from per_all_assignments_f paa,

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

Line 2790: per_all_assignments_f paf,

2786: assignment_id )
2787: in ( SELECT date_earned,
2788: assignment_id
2789: FROM hxc_bee_pref_adj_lines,
2790: per_all_assignments_f paf,
2791: per_assignment_status_types pas
2792: WHERE resource_id = person_id
2793: AND batch_source = 'OTM'
2794: AND paf.effective_end_date = hr_general.end_of_time

Line 2821: per_all_assignments_f paf

2817: WHERE (date_worked ,assignment_id) in
2818: ( SELECT date_earned,
2819: paf.assignment_id
2820: FROM hxc_bee_pref_adj_lines hoa,
2821: per_all_assignments_f paf
2822: WHERE hoa.resource_id = paf.person_id
2823: AND hoa.date_earned BETWEEN paf.effective_start_date
2824: AND paf.effective_end_date
2825: AND paf.primary_flag = 'Y');