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

Line 9: (assignment_id per_all_assignments_f.assignment_id%TYPE

5: g_debug BOOLEAN:=FALSE;
6: --
7: --
8: TYPE g_output_file_rec_type IS RECORD
9: (assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,employee_number per_all_people_f.employee_number%TYPE
12: ,assignment_number per_all_assignments_f.assignment_number%TYPE
13: ,effective_date per_all_assignments_f.effective_start_date%TYPE

Line 12: ,assignment_number per_all_assignments_f.assignment_number%TYPE

8: TYPE g_output_file_rec_type IS RECORD
9: (assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,employee_number per_all_people_f.employee_number%TYPE
12: ,assignment_number per_all_assignments_f.assignment_number%TYPE
13: ,effective_date per_all_assignments_f.effective_start_date%TYPE
14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)

Line 13: ,effective_date per_all_assignments_f.effective_start_date%TYPE

9: (assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,employee_number per_all_people_f.employee_number%TYPE
12: ,assignment_number per_all_assignments_f.assignment_number%TYPE
13: ,effective_date per_all_assignments_f.effective_start_date%TYPE
14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE

Line 18: ,normal_hours per_all_assignments_f.normal_hours%TYPE

14: ,change_in VARCHAR2(80)
15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE
22: ,period_divisor pay_user_column_instances_f.value%TYPE

Line 19: ,frequency per_all_assignments_f.frequency%TYPE

15: ,FTE_old_value per_assignment_budget_values_f.value%TYPE
16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE
22: ,period_divisor pay_user_column_instances_f.value%TYPE
23: ,message fnd_new_messages.message_text%TYPE

Line 43: g_fte_exists_assignment_id per_all_assignments_f.assignment_id%TYPE;

39: g_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
40: g_not_cached_constants BOOLEAN:=TRUE;
41:
42: -- cache for chk_fte_exists
43: g_fte_exists_assignment_id per_all_assignments_f.assignment_id%TYPE;
44: g_fte_exists BOOLEAN;
45:
46: -- cache for get_earliest_possible_date
47: g_epFd_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 47: g_epFd_assignment_id per_all_assignments_f.assignment_id%TYPE;

43: g_fte_exists_assignment_id per_all_assignments_f.assignment_id%TYPE;
44: g_fte_exists BOOLEAN;
45:
46: -- cache for get_earliest_possible_date
47: g_epFd_assignment_id per_all_assignments_f.assignment_id%TYPE;
48: g_epFd_earliest_possible_date DATE;
49:
50:
51: --

Line 86: FROM per_all_assignments_f asg

82: ) IS
83: SELECT asg.business_group_id
84: ,asg.normal_hours
85: ,asg.frequency
86: FROM per_all_assignments_f asg
87: WHERE asg.assignment_id = p_assignment_id
88: AND p_effective_date
89: BETWEEN asg.effective_start_date
90: AND asg.effective_end_date;

Line 596: FROM per_all_assignments_f asg

592: CURSOR csr_min_asg_start_date
593: (p_assignment_id NUMBER
594: ) IS
595: SELECT MIN(asg.effective_start_date)
596: FROM per_all_assignments_f asg
597: WHERE asg.assignment_id = p_assignment_id
598: AND asg.normal_hours IS NOT NULL;
599:
600:

Line 1682: FROM per_all_assignments_f asg1

1678: ,p_annual_hours_col_id IN NUMBER
1679: ,p_period_divisor_col_id IN NUMBER
1680: ) IS
1681: SELECT 'Normal Hours' change_type,asg2.effective_start_date
1682: FROM per_all_assignments_f asg1
1683: ,per_all_assignments_f asg2
1684: WHERE asg1.assignment_id = p_assignment_id
1685: AND ( asg1.effective_start_date >= p_min_effective_start_date
1686: OR

Line 1683: ,per_all_assignments_f asg2

1679: ,p_period_divisor_col_id IN NUMBER
1680: ) IS
1681: SELECT 'Normal Hours' change_type,asg2.effective_start_date
1682: FROM per_all_assignments_f asg1
1683: ,per_all_assignments_f asg2
1684: WHERE asg1.assignment_id = p_assignment_id
1685: AND ( asg1.effective_start_date >= p_min_effective_start_date
1686: OR
1687: p_min_effective_start_date

Line 1991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1987: l_calculation_date DATE;
1988: l_error VARCHAR2(2000);
1989: l_message VARCHAR2(240);
1990: l_full_name VARCHAR2(80);
1991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1992: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;
1993: i BINARY_INTEGER;
1994:
1995: CURSOR csr_payroll_assignment_set

Line 2001: FROM per_all_assignments_f asg

1997: ,p_effective_date DATE
1998: )
1999: IS
2000: SELECT DISTINCT asg.assignment_id
2001: FROM per_all_assignments_f asg
2002: WHERE asg.payroll_id = p_payroll_id
2003: AND ( p_effective_date
2004: BETWEEN asg.effective_start_date AND asg.effective_end_date
2005: OR

Line 2033: FROM per_all_assignments_f asg,

2029: ,p_contract_type VARCHAR2
2030: ,p_effective_date DATE
2031: ) IS
2032: SELECT DISTINCT asg.assignment_id
2033: FROM per_all_assignments_f asg,
2034: pqp_assignment_attributes_f aat
2035: WHERE asg.payroll_id = p_payroll_id
2036: AND ( p_effective_date
2037: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 2054: per_all_assignments_f asg

2050: (p_assignment_id NUMBER)
2051: IS
2052: SELECT per.full_name
2053: FROM per_all_people_f per,
2054: per_all_assignments_f asg
2055: WHERE asg.person_id = per.person_id
2056: AND asg.assignment_id = p_assignment_id
2057: AND l_calculation_date
2058: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 2341: FROM per_all_assignments_f asg

2337: INTO g_output_file_records(i).employee_number
2338: FROM per_all_people_f a
2339: WHERE a.person_id =
2340: (SELECT asg.person_id
2341: FROM per_all_assignments_f asg
2342: WHERE asg.assignment_id = l_assignment(i)
2343: AND ROWNUM < 2
2344: )
2345: AND effective_start_date =

Line 2358: FROM per_all_assignments_f a

2354: END IF;
2355:
2356: SELECT assignment_number
2357: INTO g_output_file_records(i).assignment_number
2358: FROM per_all_assignments_f a
2359: WHERE a.assignment_id = l_assignment(i)
2360: AND a.effective_start_date =
2361: (SELECT MAX(b.effective_start_date)
2362: FROM per_all_assignments_f b

Line 2362: FROM per_all_assignments_f b

2358: FROM per_all_assignments_f a
2359: WHERE a.assignment_id = l_assignment(i)
2360: AND a.effective_start_date =
2361: (SELECT MAX(b.effective_start_date)
2362: FROM per_all_assignments_f b
2363: WHERE b.assignment_id = a.assignment_id
2364: );
2365:
2366: