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 613: FROM per_all_assignments_f asg

609: CURSOR csr_min_asg_start_date
610: (p_assignment_id NUMBER
611: ) IS
612: SELECT MIN(asg.effective_start_date)
613: FROM per_all_assignments_f asg
614: WHERE asg.assignment_id = p_assignment_id
615: AND asg.normal_hours IS NOT NULL;
616:
617:

Line 1728: FROM per_all_assignments_f asg1

1724: ,p_annual_hours_col_id IN NUMBER
1725: ,p_period_divisor_col_id IN NUMBER
1726: ) IS
1727: SELECT 'Normal Hours' change_type,asg2.effective_start_date
1728: FROM per_all_assignments_f asg1
1729: ,per_all_assignments_f asg2
1730: WHERE asg1.assignment_id = p_assignment_id
1731: AND ( asg1.effective_start_date >= p_min_effective_start_date
1732: OR

Line 1729: ,per_all_assignments_f asg2

1725: ,p_period_divisor_col_id IN NUMBER
1726: ) IS
1727: SELECT 'Normal Hours' change_type,asg2.effective_start_date
1728: FROM per_all_assignments_f asg1
1729: ,per_all_assignments_f asg2
1730: WHERE asg1.assignment_id = p_assignment_id
1731: AND ( asg1.effective_start_date >= p_min_effective_start_date
1732: OR
1733: p_min_effective_start_date

Line 2040: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2036: l_calculation_date DATE;
2037: l_error VARCHAR2(2000);
2038: l_message VARCHAR2(240);
2039: l_full_name VARCHAR2(80);
2040: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2041: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;
2042: i BINARY_INTEGER;
2043:
2044: CURSOR csr_payroll_assignment_set

Line 2050: FROM per_all_assignments_f asg

2046: ,p_effective_date DATE
2047: )
2048: IS
2049: SELECT DISTINCT asg.assignment_id
2050: FROM per_all_assignments_f asg
2051: WHERE asg.payroll_id = p_payroll_id
2052: AND ( p_effective_date
2053: BETWEEN asg.effective_start_date AND asg.effective_end_date
2054: OR

Line 2082: FROM per_all_assignments_f asg,

2078: ,p_contract_type VARCHAR2
2079: ,p_effective_date DATE
2080: ) IS
2081: SELECT DISTINCT asg.assignment_id
2082: FROM per_all_assignments_f asg,
2083: pqp_assignment_attributes_f aat
2084: WHERE asg.payroll_id = p_payroll_id
2085: AND ( p_effective_date
2086: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 2103: per_all_assignments_f asg

2099: (p_assignment_id NUMBER)
2100: IS
2101: SELECT per.full_name
2102: FROM per_all_people_f per,
2103: per_all_assignments_f asg
2104: WHERE asg.person_id = per.person_id
2105: AND asg.assignment_id = p_assignment_id
2106: AND l_calculation_date
2107: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 2400: FROM per_all_assignments_f asg

2396: INTO g_output_file_records(i).employee_number
2397: FROM per_all_people_f a
2398: WHERE a.person_id =
2399: (SELECT asg.person_id
2400: FROM per_all_assignments_f asg
2401: WHERE asg.assignment_id = l_assignment(i)
2402: AND ROWNUM < 2
2403: )
2404: AND effective_start_date =

Line 2417: FROM per_all_assignments_f a

2413: END IF;
2414:
2415: SELECT assignment_number
2416: INTO g_output_file_records(i).assignment_number
2417: FROM per_all_assignments_f a
2418: WHERE a.assignment_id = l_assignment(i)
2419: AND a.effective_start_date =
2420: (SELECT MAX(b.effective_start_date)
2421: FROM per_all_assignments_f b

Line 2421: FROM per_all_assignments_f b

2417: FROM per_all_assignments_f a
2418: WHERE a.assignment_id = l_assignment(i)
2419: AND a.effective_start_date =
2420: (SELECT MAX(b.effective_start_date)
2421: FROM per_all_assignments_f b
2422: WHERE b.assignment_id = a.assignment_id
2423: );
2424:
2425: