APPS.PQP_BUDGET_MAINTENANCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: assignment_id per_all_assignments_f.assignment_id%TYPE

5: hr_application_error EXCEPTION;
6: PRAGMA EXCEPTION_INIT (hr_application_error, -20001);
7: -- output record structure
8: TYPE g_output_file_rec_type IS RECORD(
9: assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,uom VARCHAR2(80)
12: ,employee_number per_all_people_f.employee_number%TYPE
13: ,assignment_number per_all_assignments_f.assignment_number%TYPE

Line 13: ,assignment_number per_all_assignments_f.assignment_number%TYPE

9: assignment_id per_all_assignments_f.assignment_id%TYPE
10: ,status VARCHAR2(80)
11: ,uom VARCHAR2(80)
12: ,employee_number per_all_people_f.employee_number%TYPE
13: ,assignment_number per_all_assignments_f.assignment_number%TYPE
14: ,effective_date per_all_assignments_f.effective_start_date%TYPE
15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE
16: ,change_type VARCHAR2(80)
17: ,new_budget_value per_assignment_budget_values_f.VALUE%TYPE

Line 14: ,effective_date per_all_assignments_f.effective_start_date%TYPE

10: ,status VARCHAR2(80)
11: ,uom VARCHAR2(80)
12: ,employee_number per_all_people_f.employee_number%TYPE
13: ,assignment_number per_all_assignments_f.assignment_number%TYPE
14: ,effective_date per_all_assignments_f.effective_start_date%TYPE
15: ,old_budget_value per_assignment_budget_values_f.VALUE%TYPE
16: ,change_type VARCHAR2(80)
17: ,new_budget_value per_assignment_budget_values_f.VALUE%TYPE
18: ,MESSAGE fnd_new_messages.MESSAGE_TEXT%TYPE

Line 53: FROM per_all_assignments_f

49:
50: CURSOR get_business_group_id(p_assignment_id NUMBER)
51: IS
52: SELECT business_group_id
53: FROM per_all_assignments_f
54: WHERE assignment_id = p_assignment_id;
55:
56: --
57: --

Line 926: -- FROM per_all_assignments_f paa

922: -- l_create_string := 'CREATE TABLE pqp_person_id_temp
923: -- AS SELECT DISTINCT paa.person_id
924: -- ,paa.assignment_id
925: -- ,haa.include_or_exclude
926: -- FROM per_all_assignments_f paa
927: -- ,hr_assignment_set_amendments haa
928: -- WHERE paa.assignment_id = haa.assignment_id
929: -- AND haa.assignment_set_id = '
930: -- || l_assignment_set_id;

Line 951: FROM per_all_assignments_f paa

947: THEN
948: l_proc_step := 70;
949: l_string :=
950: 'SELECT DISTINCT person_id
951: FROM per_all_assignments_f paa
952: ,hr_assignment_set_amendments hasa
953: ,pay_payroll_actions ppa
954: WHERE paa.business_group_id = ppa.business_group_id
955: AND ppa.payroll_action_id = :payroll_action_id

Line 1203: FROM per_all_assignments_f asg

1199: ,c_effective_date DATE
1200: )
1201: IS
1202: SELECT asg.assignment_id assignment_id, asg.payroll_id
1203: FROM per_all_assignments_f asg
1204: WHERE asg.person_id BETWEEN p_start_person AND p_end_person
1205: AND asg.assignment_id = NVL(c_assignment_id, asg.assignment_id)
1206: AND asg.business_group_id = c_business_group_id
1207: AND ( c_effective_date BETWEEN asg.effective_start_date

Line 1212: FROM per_all_assignments_f asg2

1208: AND asg.effective_end_date
1209: OR ( asg.effective_start_date > c_effective_date
1210: AND asg.effective_end_date =
1211: (SELECT MIN(asg2.effective_end_date)
1212: FROM per_all_assignments_f asg2
1213: WHERE asg2.assignment_id = asg.assignment_id)
1214: )
1215: )
1216: ORDER BY asg.assignment_id;

Line 1232: FROM per_all_assignments_f asg

1228: ,c_effective_date DATE
1229: )
1230: IS
1231: SELECT asg.assignment_id
1232: FROM per_all_assignments_f asg
1233: ,hr_assignment_set_amendments hasa
1234: WHERE asg.assignment_id = hasa.assignment_id
1235: AND hasa.assignment_set_id = c_assignment_set_id
1236: AND NVL(hasa.include_or_exclude, 'I') = 'I'

Line 1241: FROM per_all_assignments_f asg2

1237: AND asg.person_id BETWEEN p_start_person AND p_end_person
1238: AND asg.effective_end_date < c_effective_date
1239: AND NOT EXISTS(
1240: SELECT 1
1241: FROM per_all_assignments_f asg2
1242: WHERE asg2.assignment_id = asg.assignment_id
1243: AND ( c_effective_date
1244: BETWEEN asg2.effective_start_date
1245: AND asg2.effective_end_date

Line 1746: FROM per_all_assignments_f asg

1742:
1743: CURSOR csr_min_asg_start_date(p_assignment_id NUMBER)
1744: IS
1745: SELECT MIN(asg.effective_start_date)
1746: FROM per_all_assignments_f asg
1747: WHERE asg.assignment_id = p_assignment_id
1748: AND asg.normal_hours IS NOT NULL;
1749:
1750: l_aat_effective_start_date DATE;

Line 2119: FROM per_all_assignments_f asg

2115: INTO g_output_file_records(g_output_file_records.FIRST).employee_number
2116: FROM per_all_people_f a
2117: WHERE a.person_id =
2118: (SELECT asg.person_id
2119: FROM per_all_assignments_f asg
2120: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)
2121: AND effective_start_date = (SELECT MAX(b.effective_start_date)
2122: FROM per_all_people_f b
2123: WHERE b.person_id = a.person_id);

Line 2134: FROM per_all_assignments_f a

2130: END IF;
2131:
2132: SELECT assignment_number
2133: INTO g_output_file_records(g_output_file_records.FIRST).assignment_number
2134: FROM per_all_assignments_f a
2135: WHERE a.assignment_id = p_assignment_id
2136: AND a.effective_start_date =
2137: (SELECT MAX(b.effective_start_date)
2138: FROM per_all_assignments_f b

Line 2138: FROM per_all_assignments_f b

2134: FROM per_all_assignments_f a
2135: WHERE a.assignment_id = p_assignment_id
2136: AND a.effective_start_date =
2137: (SELECT MAX(b.effective_start_date)
2138: FROM per_all_assignments_f b
2139: WHERE b.assignment_id = a.assignment_id);
2140:
2141: END IF; -- IF g_is_concurrent_program_run
2142:

Line 2813: FROM per_all_assignments_f asg1, per_all_assignments_f asg2

2809: ,p_user_row_id IN NUMBER
2810: )
2811: IS
2812: SELECT asg2.effective_start_date
2813: FROM per_all_assignments_f asg1, per_all_assignments_f asg2
2814: WHERE asg1.assignment_id = p_assignment_id
2815: AND ( asg1.effective_start_date >= p_effective_start_date
2816: OR p_effective_start_date BETWEEN asg1.effective_start_date
2817: AND asg1.effective_end_date