DBA Data[Home] [Help]

APPS.PAY_GROUP_EVENT_PKG dependencies on STANDARD

Line 245: -- "STANDARD_RATE" and "OVERTIME_RATE", where by these will be used by

241: -- *******************************************************************
242: -- EXAMPLE 2: FF_GLOBALS_F
243: --
244: -- This assumes the global which the customer wants to track are
245: -- "STANDARD_RATE" and "OVERTIME_RATE", where by these will be used by
246: -- elements "Time Card" and "Overtime".
247: --
248: -- *******************************************************************
249: --

Line 269: and glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')

265: , pay_element_entries_f pee
266: , pay_element_types_f pet
267: where glb.global_id = p_surrogate_key
268: and pee.assignment_id = p_assignment_id
269: and glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')
270: and pee.element_type_id = pet.element_type_id
271: and pet.element_name in ('Time Card','Overtime')
272: );
273: --

Line 303: and glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')

299: , pay_element_entries_f pee
300: , pay_element_types_f pet
301: where glb.global_id = p_surrogate_key
302: and pee.assignment_id = p_assignment_id
303: and glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')
304: and pee.element_type_id = pet.element_type_id
305: and pet.element_name in ('Time Card','Overtime')
306: and pee.effective_end_date >= pet.effective_start_date
307: and pee.effective_start_date <= pet.effective_end_date