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_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 937: -- FROM per_all_assignments_f paa

933: -- l_create_string := 'CREATE TABLE pqp_person_id_temp
934: -- AS SELECT DISTINCT paa.person_id
935: -- ,paa.assignment_id
936: -- ,haa.include_or_exclude
937: -- FROM per_all_assignments_f paa
938: -- ,hr_assignment_set_amendments haa
939: -- WHERE paa.assignment_id = haa.assignment_id
940: -- AND haa.assignment_set_id = '
941: -- || l_assignment_set_id;

Line 962: FROM per_all_assignments_f paa

958: THEN
959: l_proc_step := 70;
960: l_string :=
961: 'SELECT DISTINCT person_id
962: FROM per_all_assignments_f paa
963: ,hr_assignment_set_amendments hasa
964: ,pay_payroll_actions ppa
965: WHERE paa.business_group_id = ppa.business_group_id
966: AND ppa.payroll_action_id = :payroll_action_id

Line 1214: FROM per_all_assignments_f asg

1210: ,c_effective_date DATE
1211: )
1212: IS
1213: SELECT asg.assignment_id assignment_id, asg.payroll_id
1214: FROM per_all_assignments_f asg
1215: WHERE asg.person_id BETWEEN p_start_person AND p_end_person
1216: AND asg.assignment_id = NVL(c_assignment_id, asg.assignment_id)
1217: AND asg.business_group_id = c_business_group_id
1218: AND ( c_effective_date BETWEEN asg.effective_start_date

Line 1223: FROM per_all_assignments_f asg2

1219: AND asg.effective_end_date
1220: OR ( asg.effective_start_date > c_effective_date
1221: AND asg.effective_end_date =
1222: (SELECT MIN(asg2.effective_end_date)
1223: FROM per_all_assignments_f asg2
1224: WHERE asg2.assignment_id = asg.assignment_id)
1225: )
1226: )
1227: AND asg.assignment_type NOT IN ('C', 'A', 'B') -- Bug 6847750, 7718235

Line 1244: FROM per_all_assignments_f asg

1240: ,c_effective_date DATE
1241: )
1242: IS
1243: SELECT asg.assignment_id
1244: FROM per_all_assignments_f asg
1245: ,hr_assignment_set_amendments hasa
1246: WHERE asg.assignment_id = hasa.assignment_id
1247: AND hasa.assignment_set_id = c_assignment_set_id
1248: AND NVL(hasa.include_or_exclude, 'I') = 'I'

Line 1253: FROM per_all_assignments_f asg2

1249: AND asg.person_id BETWEEN p_start_person AND p_end_person
1250: AND asg.effective_end_date < c_effective_date
1251: AND NOT EXISTS(
1252: SELECT 1
1253: FROM per_all_assignments_f asg2
1254: WHERE asg2.assignment_id = asg.assignment_id
1255: AND ( c_effective_date
1256: BETWEEN asg2.effective_start_date
1257: AND asg2.effective_end_date

Line 1758: FROM per_all_assignments_f asg

1754:
1755: CURSOR csr_min_asg_start_date(p_assignment_id NUMBER)
1756: IS
1757: SELECT MIN(asg.effective_start_date)
1758: FROM per_all_assignments_f asg
1759: WHERE asg.assignment_id = p_assignment_id
1760: AND asg.normal_hours IS NOT NULL;
1761:
1762: l_aat_effective_start_date DATE;

Line 1887: FROM per_all_assignments_f asg

1883:
1884: CURSOR csr_max_asg_end_date(p_assignment_id NUMBER)
1885: IS
1886: SELECT MAX(asg.effective_end_date)
1887: FROM per_all_assignments_f asg
1888: WHERE asg.assignment_id = p_assignment_id
1889: AND asg.normal_hours IS NOT NULL;
1890: --
1891: BEGIN

Line 2142: FROM per_all_assignments_f asg

2138: INTO g_output_file_records(g_output_file_records.FIRST).employee_number
2139: FROM per_all_people_f a
2140: WHERE a.person_id =
2141: (SELECT asg.person_id
2142: FROM per_all_assignments_f asg
2143: WHERE asg.assignment_id = p_assignment_id AND ROWNUM < 2)
2144: AND effective_start_date = (SELECT MAX(b.effective_start_date)
2145: FROM per_all_people_f b
2146: WHERE b.person_id = a.person_id);

Line 2157: FROM per_all_assignments_f a

2153: END IF;
2154:
2155: SELECT assignment_number
2156: INTO g_output_file_records(g_output_file_records.FIRST).assignment_number
2157: FROM per_all_assignments_f a
2158: WHERE a.assignment_id = p_assignment_id
2159: AND a.effective_start_date =
2160: (SELECT MAX(b.effective_start_date)
2161: FROM per_all_assignments_f b

Line 2161: FROM per_all_assignments_f b

2157: FROM per_all_assignments_f a
2158: WHERE a.assignment_id = p_assignment_id
2159: AND a.effective_start_date =
2160: (SELECT MAX(b.effective_start_date)
2161: FROM per_all_assignments_f b
2162: WHERE b.assignment_id = a.assignment_id);
2163:
2164: END IF; -- IF g_is_concurrent_program_run
2165:

Line 2855: FROM per_all_assignments_f asg1, per_all_assignments_f asg2

2851: ,p_user_row_id IN NUMBER
2852: )
2853: IS
2854: SELECT asg2.effective_start_date
2855: FROM per_all_assignments_f asg1, per_all_assignments_f asg2
2856: WHERE asg1.assignment_id = p_assignment_id
2857: AND ( asg1.effective_start_date >= p_effective_start_date
2858: OR p_effective_start_date BETWEEN asg1.effective_start_date
2859: AND asg1.effective_end_date