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.HR_US_FF_UDF1 dependencies on PER_ALL_ASSIGNMENTS_F

Line 1505: ,per_all_assignments_f ASSIGN

1501: l_res_city,
1502: l_res_zip,
1503: l_wah
1504: FROM per_addresses ADDR
1505: ,per_all_assignments_f ASSIGN
1506: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1507: AND ASSIGN.effective_end_date
1508: and ASSIGN.assignment_id = l_assignment_id
1509: and ADDR.person_id = ASSIGN.person_id

Line 1689: , per_all_assignments_f ASSIGN

1685: l_state,
1686: l_zip_code
1687: FROM hr_locations HRLOC
1688: , hr_soft_coding_keyflex HRSCKF
1689: , per_all_assignments_f ASSIGN
1690: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1691: AND ASSIGN.effective_end_date
1692: AND ASSIGN.assignment_id = l_assignment_id
1693: AND ASSIGN.soft_coding_keyflex_id = HRSCKF.soft_coding_keyflex_id

Line 2311: from per_all_assignments_f paaf,

2307: -- get start and end dates of the pay period
2308: CURSOR csr_get_period_dates IS
2309: select ptp.start_date,
2310: ptp.end_date
2311: from per_all_assignments_f paaf,
2312: pay_all_payrolls_f papf,
2313: per_time_periods ptp
2314: where paaf.payroll_id = papf.payroll_id
2315: and papf.payroll_id = ptp.payroll_id

Line 2327: FROM per_all_assignments_f paaf

2323:
2324: -- Checks whether the assignment is valid as of last date of the pay period.
2325: CURSOR CSR_GET_VALID_ASSIGNMENT IS
2326: SELECT 1
2327: FROM per_all_assignments_f paaf
2328: WHERE l_date between paaf.effective_start_date
2329: and paaf.effective_end_date;
2330:
2331: BEGIN

Line 2582: ,per_all_assignments_f assign

2578: NVL(hrloc.loc_information17,hrloc.region_2),
2579: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2580: FROM hr_locations hrloc
2581: ,hr_soft_coding_keyflex hrsckf
2582: ,per_all_assignments_f assign
2583: WHERE p_date_earned BETWEEN assign.effective_start_date
2584: AND assign.effective_end_date
2585: AND assign.assignment_id = p_assignment_id
2586: AND assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id

Line 2686: per_all_assignments_f assign

2682: --
2683: CURSOR csr_ws(p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
2684: SELECT segment4
2685: FROM hr_soft_coding_keyflex target,
2686: per_all_assignments_f assign
2687: WHERE ASSIGN.assignment_id = p_assignment_id
2688: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
2689: AND target.enabled_flag = 'Y'
2690: AND p_date_earned BETWEEN assign.effective_start_date

Line 2700: ,per_all_assignments_f assign

2696: NVL(addr.add_information18,addr.town_or_city) city,
2697: NVL(addr.add_information20,addr.postal_code) zip,
2698: NVL(assign.work_at_home,'N')
2699: FROM per_addresses addr
2700: ,per_all_assignments_f assign
2701: WHERE p_date_earned BETWEEN assign.effective_start_date
2702: AND assign.effective_end_date
2703: AND assign.assignment_id = p_assignment_id
2704: AND addr.person_id = assign.person_id

Line 2713: per_all_assignments_f paf

2709: -- Get Full Name, Assignment Number
2710: CURSOR csr_person_details(p_assignment_id IN NUMBER,p_date_paid IN DATE) IS
2711: SELECT ppf.full_name, paf.assignment_number
2712: FROM per_all_people_f ppf,
2713: per_all_assignments_f paf
2714: WHERE ppf.person_id = paf.person_id
2715: AND paf.assignment_id = p_assignment_id
2716: AND p_date_paid BETWEEN paf.effective_start_date
2717: AND paf.effective_end_date

Line 2722: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

2718: AND p_date_paid BETWEEN ppf.effective_start_date
2719: AND ppf.effective_end_date;
2720:
2721: l_full_name per_all_people_f.full_name%TYPE;
2722: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2723:
2724: -- Get actual_termination_date for the person
2725: CURSOR csr_eff_dates(p_assignment_id IN NUMBER, p_date_paid IN DATE ) IS
2726: SELECT paa.effective_start_date,

Line 2728: FROM per_all_assignments_f paa

2724: -- Get actual_termination_date for the person
2725: CURSOR csr_eff_dates(p_assignment_id IN NUMBER, p_date_paid IN DATE ) IS
2726: SELECT paa.effective_start_date,
2727: paa.effective_end_date
2728: FROM per_all_assignments_f paa
2729: WHERE paa.assignment_id = p_assignment_id
2730: AND p_date_paid BETWEEN paa.effective_start_date
2731: AND paa.effective_end_date;
2732:

Line 2743: per_all_assignments_f paa

2739: -- Get actual_termination_date for the person
2740: CURSOR csr_term_dates(p_assignment_id IN NUMBER, p_date_earned IN DATE,p_date_start IN DATE,p_date_end IN DATE ) IS
2741: SELECT pps.actual_termination_date,pps.date_start
2742: FROM per_periods_of_service pps,
2743: per_all_assignments_f paa
2744: WHERE paa.assignment_id = p_assignment_id
2745: AND paa.person_id = pps.person_id
2746: AND p_date_earned BETWEEN paa.effective_start_date
2747: AND paa.effective_end_date

Line 2755: FROM per_all_assignments_f

2751:
2752: -- Get
2753: CURSOR csr_person_id (p_assignment_id IN NUMBER) IS
2754: SELECT person_id
2755: FROM per_all_assignments_f
2756: WHERE assignment_id = p_assignment_id;
2757:
2758: l_person_id per_all_assignments_f.person_id%TYPE;
2759:

Line 2758: l_person_id per_all_assignments_f.person_id%TYPE;

2754: SELECT person_id
2755: FROM per_all_assignments_f
2756: WHERE assignment_id = p_assignment_id;
2757:
2758: l_person_id per_all_assignments_f.person_id%TYPE;
2759:
2760: l_jurisdiction VARCHAR2(20);
2761: l_calc_percent VARCHAR2(10);
2762: l_threshold_hours_state NUMBER;