APPS.PAY_SE_ALECTA dependencies on PER_ALL_ASSIGNMENTS_F

Line 269: ,per_all_assignments_f as1

265: IS
266: SELECT '1'
267: FROM pay_payroll_actions appa
268: ,pay_assignment_actions act
269: ,per_all_assignments_f as1
270: ,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = p_payroll_action_id
272: AND appa.effective_date BETWEEN csr_v_canonical_start_date
273: AND csr_v_canonical_end_date

Line 468: ,per_all_assignments_f as1

464: ,act.assignment_id assignment_id
465: ,act.assignment_action_id run_action_id
466: FROM pay_payroll_actions appa
467: ,pay_assignment_actions act
468: ,per_all_assignments_f as1
469: ,pay_payroll_actions ppa
470: WHERE ppa.payroll_action_id = p_payroll_action_id
471: AND appa.effective_date BETWEEN l_canonical_start_date
472: AND l_canonical_end_date

Line 998: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

994: l_eit_local_unit NUMBER;
995: l_legal_employer_id_fetched NUMBER;
996: -- Temp needed Variables
997: l_person_id per_all_people_f.person_id%TYPE;
998: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
999:
1000: -- Temp needed Variables
1001:
1002: -- End of place for Variables which fetches the values to be archived

Line 1028: ,per_all_assignments_f paa

1024: ,paa.assignment_number
1025: ,paa.employee_category
1026: ,paa.effective_start_date
1027: FROM pay_assignment_actions pac
1028: ,per_all_assignments_f paa
1029: ,per_all_people_f pap
1030: WHERE pac.assignment_action_id = p_asg_act_id
1031: AND paa.assignment_id = pac.assignment_id
1032: AND paa.person_id = pap.person_id

Line 1046: FROM per_all_assignments_f paa

1042: CURSOR csr_get_segment2
1043: IS
1044: SELECT scl.segment2
1045: ,scl.segment8
1046: FROM per_all_assignments_f paa
1047: ,hr_soft_coding_keyflex scl
1048: ,pay_assignment_actions pasa
1049: WHERE pasa.assignment_action_id = p_assignment_action_id
1050: AND pasa.assignment_id = paa.assignment_id

Line 1104: FROM per_all_assignments_f

1100:
1101: CURSOR csr_new_joinee (csr_v_assignment_id NUMBER)
1102: IS
1103: SELECT COUNT ('1') "RECORD_FOUND"
1104: FROM per_all_assignments_f
1105: WHERE assignment_id = csr_v_assignment_id
1106: AND business_group_id = g_business_group_id
1107: AND effective_start_date < g_start_date;
1108:

Line 1124: FROM per_all_assignments_f

1120: CURSOR csr_get_joining_date (csr_v_assignment_id NUMBER)
1121: IS
1122: SELECT effective_start_date
1123: ,effective_end_date
1124: FROM per_all_assignments_f
1125: WHERE assignment_id = csr_v_assignment_id
1126: AND business_group_id = g_business_group_id
1127: AND effective_start_date >= g_start_date
1128: AND effective_start_date <= g_end_date

Line 1137: FROM per_all_assignments_f paaf

1133:
1134: CURSOR csr_get_person_id (csr_v_assignment_id NUMBER)
1135: IS
1136: SELECT paaf.person_id
1137: FROM per_all_assignments_f paaf
1138: WHERE paaf.assignment_id = csr_v_assignment_id
1139: AND paaf.effective_start_date <= g_end_date;
1140:
1141: lr_get_person_id csr_get_person_id%ROWTYPE;

Line 1148: FROM per_all_assignments_f

1144: IS
1145: SELECT GREATEST (effective_start_date, g_start_date)
1146: effective_start_date
1147: ,LEAST (effective_end_date, g_end_date) effective_end_date
1148: FROM per_all_assignments_f
1149: WHERE assignment_id = csr_v_assignment_id
1150: AND business_group_id = g_business_group_id
1151: AND effective_start_date BETWEEN g_start_date AND g_end_date
1152: ORDER BY effective_end_date DESC;

Line 2507: FROM per_all_assignments_f paa

2503: CURSOR csr_get_details
2504: IS
2505: SELECT scl.segment2
2506: ,paa.location_id
2507: FROM per_all_assignments_f paa
2508: ,hr_soft_coding_keyflex scl
2509: WHERE paa.assignment_id = p_assignment_id
2510: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2511: -- AND paa.primary_flag = 'Y'

Line 2623: FROM per_all_assignments_f paa

2619: ,paa.assignment_id
2620: ,paa.assignment_number
2621: ,paa.effective_start_date
2622: ,pap.date_of_birth
2623: FROM per_all_assignments_f paa
2624: ,per_all_people_f pap
2625: WHERE paa.assignment_id = p_assignment_id
2626: AND paa.person_id = pap.person_id
2627: AND pap.per_information_category = 'SE'

Line 2668: FROM per_all_assignments_f paa

2664: CURSOR csr_get_details
2665: IS
2666: SELECT MONTHS_BETWEEN (g_start_date, pap.date_of_birth) / 12 "YEAR"
2667: ,pap.date_of_birth
2668: FROM per_all_assignments_f paa
2669: ,per_all_people_f pap
2670: WHERE paa.assignment_id = p_assignment_id
2671: AND paa.person_id = pap.person_id
2672: AND pap.per_information_category = 'SE'

Line 2705: FROM per_all_assignments_f paa

2701: IS
2702: CURSOR csr_get_details
2703: IS
2704: SELECT paa.person_id
2705: FROM per_all_assignments_f paa
2706: WHERE paa.assignment_id = p_assignment_id
2707: AND p_effective_date BETWEEN paa.effective_start_date
2708: AND paa.effective_end_date;
2709:

Line 2769: FROM per_all_assignments_f paa

2765: CURSOR csr_get_details
2766: IS
2767: SELECT scl.segment2
2768: ,paa.location_id
2769: FROM per_all_assignments_f paa
2770: ,hr_soft_coding_keyflex scl
2771: WHERE paa.assignment_id = p_assignment_id
2772: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2773: AND p_effective_date BETWEEN paa.effective_start_date

Line 2980: FROM per_all_assignments_f

2976: l_min_assg_start_date DATE;
2977: CURSOR csr_min_assignment (csr_v_assignment_id NUMBER )
2978: IS
2979: SELECT min(effective_start_date)
2980: FROM per_all_assignments_f
2981: WHERE assignment_id=csr_v_assignment_id;
2982: BEGIN
2983:
2984: get_org_lvl_info (p_assignment_id

Line 3049: FROM per_all_assignments_f paa

3045: ,scl.segment7
3046: ,GREATEST (effective_start_date, g_start_date)
3047: "EFF_START_DATE"
3048: ,LEAST (effective_end_date, g_end_date) "EFF_END_DATE"
3049: FROM per_all_assignments_f paa
3050: ,hr_soft_coding_keyflex scl
3051: WHERE paa.assignment_id = p_assignment_id
3052: AND paa.business_group_id = g_business_group_id
3053: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id