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_AC_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 726: from per_all_assignments_f paf2

722: ,cp_xfr_action_id in number
723: ,cp_effective_date in date) is
724: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
725: pai.action_context_id
726: from per_all_assignments_f paf2
727: ,per_all_assignments_f paf
728: ,pay_action_information pai
729: where paf2.assignment_id = cp_assignment_id
730: and paf.person_id = paf2.person_id

Line 727: ,per_all_assignments_f paf

723: ,cp_effective_date in date) is
724: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
725: pai.action_context_id
726: from per_all_assignments_f paf2
727: ,per_all_assignments_f paf
728: ,pay_action_information pai
729: where paf2.assignment_id = cp_assignment_id
730: and paf.person_id = paf2.person_id
731: and pai.assignment_id = paf.assignment_id

Line 871: from per_all_assignments_f paf2

867: ,cp_payroll_id in number -- added for the bug 14605761
868: ,cp_effective_date in date) is
869: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
870: pai.action_context_id
871: from per_all_assignments_f paf2
872: ,per_all_assignments_f paf
873: ,pay_action_information pai
874: where paf2.assignment_id = cp_assignment_id
875: and paf.person_id = paf2.person_id

Line 872: ,per_all_assignments_f paf

868: ,cp_effective_date in date) is
869: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
870: pai.action_context_id
871: from per_all_assignments_f paf2
872: ,per_all_assignments_f paf
873: ,pay_action_information pai
874: where paf2.assignment_id = cp_assignment_id
875: and paf.person_id = paf2.person_id
876: and pai.assignment_id = paf.assignment_id

Line 2808: FROM per_all_assignments_f peaf,

2804: || '-'
2805: || puc.county_code
2806: || '-'
2807: || punc.city_code jurisdiction_code
2808: FROM per_all_assignments_f peaf,
2809: hr_locations_all hla,
2810: pay_us_states pus,
2811: pay_us_counties puc,
2812: pay_us_city_names punc,

Line 3692: from per_all_assignments_f

3688: lv_rb_status VARCHAR2(1);
3689:
3690: cursor c_business_grp_id is
3691: select distinct business_group_id
3692: from per_all_assignments_f
3693: where assignment_id = p_assignment_id;
3694:
3695: BEGIN
3696:

Line 5124: FROM per_all_assignments_f peaf,

5120: || '-'
5121: || puc.county_code
5122: || '-'
5123: || punc.city_code jurisdiction_code
5124: FROM per_all_assignments_f peaf,
5125: hr_locations_all hla,
5126: pay_us_states pus,
5127: pay_us_counties puc,
5128: pay_us_city_names punc,

Line 5679: FROM per_all_assignments_f peaf,

5675: || '-'
5676: || puc.county_code
5677: || '-'
5678: || punc.city_code jurisdiction_code
5679: FROM per_all_assignments_f peaf,
5680: hr_locations_all hla,
5681: pay_us_states pus,
5682: pay_us_counties puc,
5683: pay_us_city_names punc,

Line 6291: FROM per_all_assignments_f peaf,

6287: || '-'
6288: || puc.county_code
6289: || '-'
6290: || punc.city_code jurisdiction_code
6291: FROM per_all_assignments_f peaf,
6292: hr_locations_all hla,
6293: pay_us_states pus,
6294: pay_us_counties puc,
6295: pay_us_city_names punc,