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 1546: ,per_all_assignments_f ASSIGN

1542: l_res_city,
1543: l_res_zip,
1544: l_wah
1545: FROM per_addresses ADDR
1546: ,per_all_assignments_f ASSIGN
1547: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1548: AND ASSIGN.effective_end_date
1549: and ASSIGN.assignment_id = l_assignment_id
1550: and ADDR.person_id = ASSIGN.person_id

Line 1730: , per_all_assignments_f ASSIGN

1726: l_state,
1727: l_zip_code
1728: FROM hr_locations HRLOC
1729: , hr_soft_coding_keyflex HRSCKF
1730: , per_all_assignments_f ASSIGN
1731: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1732: AND ASSIGN.effective_end_date
1733: AND ASSIGN.assignment_id = l_assignment_id
1734: AND ASSIGN.soft_coding_keyflex_id = HRSCKF.soft_coding_keyflex_id

Line 2364: from per_all_assignments_f paaf,

2360: ptp.end_date,
2361: ptp.regular_payment_date, /* Bug#8592027 */
2362: ptp.payroll_id, /*7520832*/
2363: paaf.person_id /* 765549 */
2364: from per_all_assignments_f paaf,
2365: pay_all_payrolls_f papf,
2366: per_time_periods ptp
2367: where paaf.payroll_id = papf.payroll_id
2368: and papf.payroll_id = ptp.payroll_id

Line 2681: ,per_all_assignments_f assign

2677: NVL(hrloc.loc_information17,hrloc.region_2),
2678: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2679: FROM hr_locations hrloc
2680: ,hr_soft_coding_keyflex hrsckf
2681: ,per_all_assignments_f assign
2682: WHERE p_date_earned BETWEEN assign.effective_start_date
2683: AND assign.effective_end_date
2684: AND assign.assignment_id = p_assignment_id
2685: AND assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id

Line 2785: per_all_assignments_f assign

2781: --
2782: CURSOR csr_ws(p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
2783: SELECT segment4
2784: FROM hr_soft_coding_keyflex target,
2785: per_all_assignments_f assign
2786: WHERE ASSIGN.assignment_id = p_assignment_id
2787: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
2788: AND target.enabled_flag = 'Y'
2789: AND p_date_earned BETWEEN assign.effective_start_date

Line 2799: ,per_all_assignments_f assign

2795: NVL(addr.add_information18,addr.town_or_city) city,
2796: NVL(addr.add_information20,addr.postal_code) zip,
2797: NVL(assign.work_at_home,'N')
2798: FROM per_addresses addr
2799: ,per_all_assignments_f assign
2800: WHERE p_date_earned BETWEEN assign.effective_start_date
2801: AND assign.effective_end_date
2802: AND assign.assignment_id = p_assignment_id
2803: AND addr.person_id = assign.person_id

Line 2812: per_all_assignments_f paf

2808: -- Get Full Name, Assignment Number
2809: CURSOR csr_person_details(p_assignment_id IN NUMBER,p_date_paid IN DATE) IS
2810: SELECT ppf.full_name, paf.assignment_number
2811: FROM per_all_people_f ppf,
2812: per_all_assignments_f paf
2813: WHERE ppf.person_id = paf.person_id
2814: AND paf.assignment_id = p_assignment_id
2815: AND p_date_paid BETWEEN paf.effective_start_date
2816: AND paf.effective_end_date

Line 2821: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

2817: AND p_date_paid BETWEEN ppf.effective_start_date
2818: AND ppf.effective_end_date;
2819:
2820: l_full_name per_all_people_f.full_name%TYPE;
2821: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2822:
2823: -- Get actual_termination_date for the person
2824: CURSOR csr_eff_dates(p_assignment_id IN NUMBER, p_date_paid IN DATE ) IS
2825: SELECT paa.effective_start_date,

Line 2827: FROM per_all_assignments_f paa

2823: -- Get actual_termination_date for the person
2824: CURSOR csr_eff_dates(p_assignment_id IN NUMBER, p_date_paid IN DATE ) IS
2825: SELECT paa.effective_start_date,
2826: paa.effective_end_date
2827: FROM per_all_assignments_f paa
2828: WHERE paa.assignment_id = p_assignment_id
2829: AND p_date_paid BETWEEN paa.effective_start_date
2830: AND paa.effective_end_date;
2831:

Line 2842: per_all_assignments_f paa

2838: -- Get actual_termination_date for the person
2839: 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
2840: SELECT pps.actual_termination_date,pps.date_start
2841: FROM per_periods_of_service pps,
2842: per_all_assignments_f paa
2843: WHERE paa.assignment_id = p_assignment_id
2844: AND paa.person_id = pps.person_id
2845: AND p_date_earned BETWEEN paa.effective_start_date
2846: AND paa.effective_end_date

Line 2854: FROM per_all_assignments_f

2850:
2851: -- Get
2852: CURSOR csr_person_id (p_assignment_id IN NUMBER) IS
2853: SELECT person_id
2854: FROM per_all_assignments_f
2855: WHERE assignment_id = p_assignment_id;
2856:
2857: l_person_id per_all_assignments_f.person_id%TYPE;
2858:

Line 2857: l_person_id per_all_assignments_f.person_id%TYPE;

2853: SELECT person_id
2854: FROM per_all_assignments_f
2855: WHERE assignment_id = p_assignment_id;
2856:
2857: l_person_id per_all_assignments_f.person_id%TYPE;
2858:
2859: l_jurisdiction VARCHAR2(20);
2860: l_calc_percent VARCHAR2(10);
2861: l_threshold_hours_state NUMBER;

Line 5916: from per_all_assignments_f paaf,

5912: CURSOR csr_get_period_dates IS
5913: select ptp.start_date,
5914: ptp.end_date,
5915: ptp.payroll_id
5916: from per_all_assignments_f paaf,
5917: pay_all_payrolls_f papf,
5918: per_time_periods ptp
5919: where paaf.payroll_id = papf.payroll_id
5920: and papf.payroll_id = ptp.payroll_id

Line 6012: FROM per_all_assignments_f

6008: AND papf.payroll_id=p_payroll_id;
6009:
6010: CURSOR get_assignment_number IS
6011: SELECT assignment_number
6012: FROM per_all_assignments_f
6013: WHERE assignment_id=p_assignment_id;
6014:
6015: l_num_periods_per_year per_time_period_types.number_per_fiscal_year%TYPE;
6016: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 6016: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

6012: FROM per_all_assignments_f
6013: WHERE assignment_id=p_assignment_id;
6014:
6015: l_num_periods_per_year per_time_period_types.number_per_fiscal_year%TYPE;
6016: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6017: l_ht_deducted NUMBER;
6018:
6019: BEGIN
6020:

Line 6523: ,per_all_assignments_f ASS

6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT
6521: ,pay_payroll_actions PACT
6522: ,pay_payroll_actions BACT
6523: ,per_all_assignments_f ASS
6524: WHERE BAL_ASSACT.assignment_action_id = p_asgmnt_action_id
6525: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
6526: AND FEED.balance_type_id = p_balance_type_id + decode(TARGET.INPUT_VALUE_ID, null, 0, 0)
6527: AND FEED.input_value_id = TARGET.input_value_id

Line 6537: AND ASS.person_id = (select person_id from per_all_assignments_f START_ASS

6533: and FEED.effective_end_date
6534: AND RR.status in ('P','PA')
6535: AND ASSACT.action_sequence <= BAL_ASSACT.action_sequence
6536: AND ASSACT.assignment_id = ASS.assignment_id
6537: AND ASS.person_id = (select person_id from per_all_assignments_f START_ASS
6538: where START_ASS.assignment_id = BAL_ASSACT.assignment_id
6539: and rownum = 1)
6540: AND PACT.effective_date between ASS.effective_start_date
6541: and ASS.effective_end_date