DBA Data[Home] [Help]

APPS.PAY_IE_BIK dependencies on PAY_ELEMENT_TYPES_F

Line 400: from pay_element_types_f pet,

396: cursor get_invalid_days(p_element_entry_id in number,
397: p_vehicle_alloc_end_date in DATE,
398: p_curr_period_start_date in DATE) is
399: select nvl(sum(to_number(prrv.result_value)),0)
400: from pay_element_types_f pet,
401: pay_input_values_f piv,
402: pay_element_entries_f pee,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paas,

Line 451: from pay_element_types_f pet,

447: cursor invalid_total_mileage(p_element_entry_id in number,
448: p_vehicle_alloc_end_date in DATE,
449: p_curr_period_start_date in DATE) is
450: select nvl(sum(to_number(prrv.result_value)),0)
451: from pay_element_types_f pet,
452: pay_input_values_f piv,
453: pay_element_entries_f pee,
454: pay_payroll_actions ppa,
455: pay_assignment_actions paas,

Line 502: from pay_element_types_f pet,

498: cursor invalid_bsg_mileage(p_element_entry_id in number,
499: p_vehicle_alloc_end_date in DATE,
500: p_curr_period_start_date in DATE) is
501: select nvl(sum(to_number(prrv.result_value)),0)
502: from pay_element_types_f pet,
503: pay_input_values_f piv,
504: pay_element_entries_f pee,
505: pay_payroll_actions ppa,
506: pay_assignment_actions paas,