APPS.PAY_GB_DEO dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 322: pay_element_entry_values_f peev,

318: is
319: select distinct paaf.person_id,max(peef.assignment_id) assignment_id
320: from pay_element_types_f pet,
321: pay_input_values_f piv,
322: pay_element_entry_values_f peev,
323: pay_element_entries_f peef,
324: per_all_assignments_f paaf,
325: hr_soft_coding_keyflex sc,
326: pay_all_payrolls_f ppf,

Line 476: pay_element_entry_values_f peev1,

472: select paaf.person_id person_id,max(peef.assignment_id) assignment_id,max(peef.element_entry_id) element_entry_id,peev2.screen_entry_value employee_ref
473: from pay_element_types_f pet1,
474: pay_input_values_f piv1,
475: pay_input_values_f piv2,
476: pay_element_entry_values_f peev1,
477: pay_element_entry_values_f peev2,
478: pay_element_entries_f peef,
479: per_all_assignments_f paaf,
480: hr_soft_coding_keyflex scl,

Line 477: pay_element_entry_values_f peev2,

473: from pay_element_types_f pet1,
474: pay_input_values_f piv1,
475: pay_input_values_f piv2,
476: pay_element_entry_values_f peev1,
477: pay_element_entry_values_f peev2,
478: pay_element_entries_f peef,
479: per_all_assignments_f paaf,
480: hr_soft_coding_keyflex scl,
481: pay_all_payrolls_f ppf,

Line 536: from pay_element_entry_values_f

532:
533: cursor get_reason(p_element_entry_id IN number)
534: is
535: select SCREEN_ENTRY_VALUE
536: from pay_element_entry_values_f
537: where element_entry_id = p_element_entry_id
538: and INPUT_VALUE_ID
539: in (select INPUT_VALUE_ID from pay_input_values_f where name = 'DEO Underpayment Reason');
540:

Line 548: pay_element_entry_values_f peev,

544: select paa.assignment_action_id asgactid,
545: peef.assignment_id,ppa.EFFECTIVE_DATE
546: from pay_element_types_f pet,
547: pay_input_values_f piv,
548: pay_element_entry_values_f peev,
549: pay_element_entries_f peef,
550: per_all_assignments_f paaf,
551: hr_soft_coding_keyflex sc,
552: pay_all_payrolls_f ppf,