APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_ALL_PEOPLE_F

Line 972: per_all_people_f pap

968: assign.location_id
969: FROM
970: pay_assignment_actions pac,
971: per_all_assignments_f assign,
972: per_all_people_f pap
973: WHERE pac.assignment_action_id = p_asg_act_id
974: AND assign.assignment_id = pac.assignment_id
975: AND assign.person_id = pap.person_id
976: AND pap.per_information_category = 'DK'

Line 1022: per_all_people_f papf

1018: ,scl.SEGMENT21 MO_CODE
1019: ,scl.SEGMENT22 FO_CODE
1020: ,NVL(scl.SEGMENT23,'FH1') FH_CODE
1021: FROM
1022: per_all_people_f papf
1023: ,per_all_assignments_f paaf
1024: ,pay_payrolls_f ppf
1025: ,hr_soft_coding_keyflex scl
1026: WHERE paaf.person_id = p_person_id

Line 1122: , per_all_people_f pap

1118: ,pad.REGION_2
1119: ,pad.REGION_3
1120: ,pad.style
1121: FROM per_addresses pad
1122: , per_all_people_f pap
1123: WHERE pad.person_id = pap.person_id
1124: AND pad.primary_flag = 'Y'
1125: AND pap.person_id = p_person_id
1126: AND pad.business_group_id = pap.business_group_id

Line 1155: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type

1151:
1152:
1153: /* Getting the latest hire date */
1154: /* For Bug 9011035 */
1155: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type
1156: ,p_end_date DATE) IS
1157: SELECT MAX(date_start) lhd FROM per_periods_of_service
1158: WHERE person_id=pid
1159: AND date_start <= p_end_date;

Line 1164: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS

1160:
1161: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;
1162:
1163: /* Cursor to get the extra person info - Foreigner (yes/no) */
1164: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS
1165: SELECT PEI_INFORMATION1 yes_no FROM per_people_extra_info
1166: WHERE person_id=pid
1167: AND information_type='DK_EINCOME_FORIEGN_IND';
1168:

Line 1172: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS

1168:
1169: rg_csr_get_extra_person_info csr_get_extra_person_info%rowtype;
1170:
1171: /* Get the territory */
1172: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
1173: SELECT *
1174: FROM per_addresses_v
1175: WHERE person_id =pid
1176: and primary_flag='Y';

Line 1292: ,per_all_people_f per

1288: /* Cursor to retrieve Element - Employee ATP*/
1289: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1290: SELECT eev1.screen_entry_value screen_entry_value
1291: FROM per_all_assignments_f asg1
1292: ,per_all_people_f per
1293: ,pay_element_links_f el
1294: ,pay_element_types_f et
1295: ,pay_input_values_f iv1
1296: ,pay_element_entries_f ee

Line 1327: ,per_all_people_f per

1323: /* Cursor to retrieve Element - Tax Card*/
1324: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1325: SELECT ee.effective_start_date, eev1.screen_entry_value
1326: FROM per_all_assignments_f asg1
1327: ,per_all_people_f per
1328: ,pay_element_links_f el
1329: ,pay_element_types_f et
1330: ,pay_input_values_f iv1
1331: ,pay_element_entries_f ee