DBA Data[Home] [Help]

APPS.PAY_HK_EFT dependencies on PER_PEOPLE_F

Line 23: ** secured view per_people_f

19: ** 16 Dec 2002 VGSRINIV 2600691 Modified cursor c_hsbc_hex_data.
20: ** Second_party_identifier is set to employee number.
21: ** Removed the National Identifier column in cursor c_hsbc_hex_data
22: ** 29 May 2003 KAVERMA 2920731 Replaced table per_all_people_f by
23: ** secured view per_people_f
24: ** 08 Sep 2003 AVENKATK 3131759 Modified cursor c_hsbc_hex_data.
25: ** Added date track check for Organizational payment method
26: */
27:

Line 73: , per_people_f p

69: , pay_pre_payments ppp
70: , pay_assignment_actions paa
71: , pay_payroll_actions ppa
72: , per_assignments_f a
73: , per_people_f p
74: where
75: paa.payroll_action_id =
76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
77: and ppp.pre_payment_id = paa.pre_payment_id

Line 139: , per_people_f p

135: , pay_pre_payments ppp
136: , pay_assignment_actions paa
137: , pay_payroll_actions ppa
138: , per_assignments_f a
139: , per_people_f p
140: where
141: paa.payroll_action_id =
142: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
143: and ppp.pre_payment_id = paa.pre_payment_id