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 628: FROM PER_ALL_PEOPLE_F PER

624: ,l_restrict_empr_sl
625: ,l_restrict_ss_sl
626: ,l_per_daily_rate
627: ,l_dateofjoin
628: FROM PER_ALL_PEOPLE_F PER
629: WHERE PER.PERSON_ID = p_person_id
630: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
631: AND PER.EFFECTIVE_END_DATE;
632: EXCEPTION

Line 6761: ,per_all_people_f per

6757: , eev1.screen_entry_value screen_entry_value
6758: , iv1.name
6759: FROM per_all_assignments_f asg1
6760: ,per_all_assignments_f asg2
6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et
6764: ,pay_input_values_f iv1
6765: ,pay_element_entries_f ee

Line 7055: ,per_all_people_f per

7051: , eev1.screen_entry_value screen_entry_value
7052: , iv1.name
7053: FROM per_all_assignments_f asg1
7054: ,per_all_assignments_f asg2
7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et
7058: ,pay_input_values_f iv1
7059: ,pay_element_entries_f ee

Line 7221: ,per_all_people_f per

7217: , eev1.screen_entry_value screen_entry_value
7218: , iv1.name
7219: FROM per_all_assignments_f asg1
7220: ,per_all_assignments_f asg2
7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et
7224: ,pay_input_values_f iv1
7225: ,pay_element_entries_f ee

Line 7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7491:
7492: --
7493: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7494: SELECT pap.person_id FROM
7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7496: WHERE paa.assignment_action_id = p_assignment_action_id
7497: AND paa.assignment_id = asgmt.assignment_id
7498: AND asgmt.person_id = pap.person_id;
7499:

Line 7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7575:
7576: --
7577: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7578: SELECT pap.person_id FROM
7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7580: WHERE paa.assignment_action_id = p_assignment_action_id
7581: AND paa.assignment_id = asgmt.assignment_id
7582: AND asgmt.person_id = pap.person_id;
7583:

Line 7777: FROM PER_ALL_PEOPLE_F PER

7773:
7774:
7775: CURSOR csr_person_details(p_person_id IN NUMBER ) is
7776: SELECT PER_INFORMATION22 AS restrict_hol_to_6G
7777: FROM PER_ALL_PEOPLE_F PER
7778: WHERE PER.PERSON_ID = p_person_id
7779: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
7780: AND PER.EFFECTIVE_END_DATE;
7781:

Line 7910: FROM per_all_people_f pap

7906: ,pcr.cont_information1
7907: ,pcr.cont_information2
7908: ,pcr.date_start
7909: ,pcr.date_end
7910: FROM per_all_people_f pap
7911: ,per_contact_relationships pcr
7912: WHERE pap.person_id = pcr.contact_person_id
7913: AND pcr.person_id = personid
7914: AND pcr.contact_type = contacttype