APPS.PAY_SE_ALECTA dependencies on PER_ALL_ASSIGNMENTS_F

Line 309: ,per_all_assignments_f as1

305: IS
306: SELECT '1'
307: FROM pay_payroll_actions appa
308: ,pay_assignment_actions act
309: ,per_all_assignments_f as1
310: ,pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id
312: AND appa.effective_date BETWEEN csr_v_canonical_start_date
313: AND csr_v_canonical_end_date

Line 508: ,per_all_assignments_f as1

504: ,act.assignment_id assignment_id
505: ,act.assignment_action_id run_action_id
506: FROM pay_payroll_actions appa
507: ,pay_assignment_actions act
508: ,per_all_assignments_f as1
509: ,pay_payroll_actions ppa
510: WHERE ppa.payroll_action_id = p_payroll_action_id
511: AND appa.effective_date BETWEEN l_canonical_start_date
512: AND l_canonical_end_date

Line 1045: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1041: l_annual_salary_fk NUMBER :=0; -- Changes 2008/2009
1042:
1043: -- Temp needed Variables
1044: l_person_id per_all_people_f.person_id%TYPE;
1045: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1046:
1047: -- Temp needed Variables
1048:
1049: -- End of place for Variables which fetches the values to be archived

Line 1075: ,per_all_assignments_f paa

1071: ,paa.assignment_number
1072: ,paa.employee_category
1073: ,paa.effective_start_date
1074: FROM pay_assignment_actions pac
1075: ,per_all_assignments_f paa
1076: ,per_all_people_f pap
1077: WHERE pac.assignment_action_id = p_asg_act_id
1078: AND paa.assignment_id = pac.assignment_id
1079: AND paa.person_id = pap.person_id

Line 1093: FROM per_all_assignments_f paa

1089: CURSOR csr_get_segment2
1090: IS
1091: SELECT scl.segment2
1092: ,scl.segment8
1093: FROM per_all_assignments_f paa
1094: ,hr_soft_coding_keyflex scl
1095: ,pay_assignment_actions pasa
1096: WHERE pasa.assignment_action_id = p_assignment_action_id
1097: AND pasa.assignment_id = paa.assignment_id

Line 1151: FROM per_all_assignments_f

1147:
1148: CURSOR csr_new_joinee (csr_v_assignment_id NUMBER)
1149: IS
1150: SELECT COUNT ('1') "RECORD_FOUND"
1151: FROM per_all_assignments_f
1152: WHERE assignment_id = csr_v_assignment_id
1153: AND business_group_id = g_business_group_id
1154: AND effective_start_date < g_start_date;
1155:

Line 1183: FROM per_all_assignments_f

1179: CURSOR csr_get_joining_date (csr_v_assignment_id NUMBER)
1180: IS
1181: SELECT effective_start_date
1182: ,effective_end_date
1183: FROM per_all_assignments_f
1184: WHERE assignment_id = csr_v_assignment_id
1185: AND business_group_id = g_business_group_id
1186: AND effective_start_date >= g_start_date
1187: AND effective_start_date <= g_end_date

Line 1196: FROM per_all_assignments_f paaf

1192:
1193: CURSOR csr_get_person_id (csr_v_assignment_id NUMBER)
1194: IS
1195: SELECT paaf.person_id
1196: FROM per_all_assignments_f paaf
1197: WHERE paaf.assignment_id = csr_v_assignment_id
1198: AND paaf.effective_start_date <= g_end_date;
1199:
1200: lr_get_person_id csr_get_person_id%ROWTYPE;

Line 1207: FROM per_all_assignments_f

1203: IS
1204: SELECT GREATEST (effective_start_date, g_start_date)
1205: effective_start_date
1206: ,LEAST (effective_end_date, g_end_date) effective_end_date
1207: FROM per_all_assignments_f
1208: WHERE assignment_id = csr_v_assignment_id
1209: AND business_group_id = g_business_group_id
1210: AND effective_start_date BETWEEN g_start_date AND g_end_date
1211: ORDER BY effective_end_date DESC;

Line 2935: FROM per_all_assignments_f paa

2931: CURSOR csr_get_details
2932: IS
2933: SELECT scl.segment2
2934: ,paa.location_id
2935: FROM per_all_assignments_f paa
2936: ,hr_soft_coding_keyflex scl
2937: WHERE paa.assignment_id = p_assignment_id
2938: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2939: -- AND paa.primary_flag = 'Y'

Line 3051: FROM per_all_assignments_f paa

3047: ,paa.assignment_id
3048: ,paa.assignment_number
3049: ,paa.effective_start_date
3050: ,pap.date_of_birth
3051: FROM per_all_assignments_f paa
3052: ,per_all_people_f pap
3053: WHERE paa.assignment_id = p_assignment_id
3054: AND paa.person_id = pap.person_id
3055: AND pap.per_information_category = 'SE'

Line 3096: FROM per_all_assignments_f paa

3092: CURSOR csr_get_details
3093: IS
3094: SELECT MONTHS_BETWEEN (g_start_date, pap.date_of_birth) / 12 "YEAR"
3095: ,pap.date_of_birth
3096: FROM per_all_assignments_f paa
3097: ,per_all_people_f pap
3098: WHERE paa.assignment_id = p_assignment_id
3099: AND paa.person_id = pap.person_id
3100: AND pap.per_information_category = 'SE'

Line 3133: FROM per_all_assignments_f paa

3129: IS
3130: CURSOR csr_get_details
3131: IS
3132: SELECT paa.person_id
3133: FROM per_all_assignments_f paa
3134: WHERE paa.assignment_id = p_assignment_id
3135: AND p_effective_date BETWEEN paa.effective_start_date
3136: AND paa.effective_end_date;
3137:

Line 3197: FROM per_all_assignments_f paa

3193: CURSOR csr_get_details
3194: IS
3195: SELECT scl.segment2
3196: ,paa.location_id
3197: FROM per_all_assignments_f paa
3198: ,hr_soft_coding_keyflex scl
3199: WHERE paa.assignment_id = p_assignment_id
3200: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
3201: AND p_effective_date BETWEEN paa.effective_start_date

Line 3427: FROM per_all_assignments_f

3423: l_min_assg_start_date DATE;
3424: CURSOR csr_min_assignment (csr_v_assignment_id NUMBER )
3425: IS
3426: SELECT min(effective_start_date)
3427: FROM per_all_assignments_f
3428: WHERE assignment_id=csr_v_assignment_id;
3429: BEGIN
3430:
3431: get_org_lvl_info (p_assignment_id

Line 3496: FROM per_all_assignments_f paa

3492: ,scl.segment7
3493: ,GREATEST (effective_start_date, g_start_date)
3494: "EFF_START_DATE"
3495: ,LEAST (effective_end_date, g_end_date) "EFF_END_DATE"
3496: FROM per_all_assignments_f paa
3497: ,hr_soft_coding_keyflex scl
3498: WHERE paa.assignment_id = p_assignment_id
3499: AND paa.business_group_id = g_business_group_id
3500: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id