APPS.PAY_NO_ABSENCE dependencies on PER_ALL_PEOPLE_F

Line 92: ,per_all_people_f per

88: CURSOR CSR_ELE_ENT_VAL_FETCH (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_f asg1
91: ,per_all_assignments_f asg2
92: ,per_all_people_f per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_f ee

Line 169: FROM per_all_people_f pap

165: ,ROUND(MONTHS_BETWEEN( abs_stdt, pap.date_of_birth ) / 12, 2) AS AGE
166: ,pcr.contact_type
167: ,pcr.cont_information1
168: ,pcr.cont_information2
169: FROM per_all_people_f pap
170: ,per_contact_relationships pcr
171: WHERE pap.person_id = pcr.contact_person_id
172: AND pcr.person_id = personid
173: AND pcr.contact_type = contacttype

Line 601: FROM PER_ALL_PEOPLE_F PER

597: ,l_restrict_empr_sl
598: ,l_restrict_ss_sl
599: ,l_per_daily_rate
600: ,l_dateofjoin
601: FROM PER_ALL_PEOPLE_F PER
602: WHERE PER.PERSON_ID = p_person_id
603: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
604: AND PER.EFFECTIVE_END_DATE;
605: EXCEPTION

Line 6661: ,per_all_people_f per

6657: , eev1.screen_entry_value screen_entry_value
6658: , iv1.name
6659: FROM per_all_assignments_f asg1
6660: ,per_all_assignments_f asg2
6661: ,per_all_people_f per
6662: ,pay_element_links_f el
6663: ,pay_element_types_f et
6664: ,pay_input_values_f iv1
6665: ,pay_element_entries_f ee

Line 6955: ,per_all_people_f per

6951: , eev1.screen_entry_value screen_entry_value
6952: , iv1.name
6953: FROM per_all_assignments_f asg1
6954: ,per_all_assignments_f asg2
6955: ,per_all_people_f per
6956: ,pay_element_links_f el
6957: ,pay_element_types_f et
6958: ,pay_input_values_f iv1
6959: ,pay_element_entries_f ee

Line 7121: ,per_all_people_f per

7117: , eev1.screen_entry_value screen_entry_value
7118: , iv1.name
7119: FROM per_all_assignments_f asg1
7120: ,per_all_assignments_f asg2
7121: ,per_all_people_f per
7122: ,pay_element_links_f el
7123: ,pay_element_types_f et
7124: ,pay_input_values_f iv1
7125: ,pay_element_entries_f ee

Line 7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7391:
7392: --
7393: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7394: SELECT pap.person_id FROM
7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7396: WHERE paa.assignment_action_id = p_assignment_action_id
7397: AND paa.assignment_id = asgmt.assignment_id
7398: AND asgmt.person_id = pap.person_id;
7399:

Line 7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7475:
7476: --
7477: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7478: SELECT pap.person_id FROM
7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7480: WHERE paa.assignment_action_id = p_assignment_action_id
7481: AND paa.assignment_id = asgmt.assignment_id
7482: AND asgmt.person_id = pap.person_id;
7483:

Line 7672: FROM PER_ALL_PEOPLE_F PER

7668:
7669:
7670: CURSOR csr_person_details(p_person_id IN NUMBER ) is
7671: SELECT PER_INFORMATION22 AS restrict_hol_to_6G
7672: FROM PER_ALL_PEOPLE_F PER
7673: WHERE PER.PERSON_ID = p_person_id
7674: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
7675: AND PER.EFFECTIVE_END_DATE;
7676:

Line 7805: FROM per_all_people_f pap

7801: ,pcr.cont_information1
7802: ,pcr.cont_information2
7803: ,pcr.date_start
7804: ,pcr.date_end
7805: FROM per_all_people_f pap
7806: ,per_contact_relationships pcr
7807: WHERE pap.person_id = pcr.contact_person_id
7808: AND pcr.person_id = personid
7809: AND pcr.contact_type = contacttype