APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 146: pay_input_values_f piv, -- "Pay values" of type Money

142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money
147: pay_run_results prr, -- run result created by the payroll run/quick pay
148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
149: WHERE lck.locking_action_id = paa2.assignment_action_id
150: AND paa2.payroll_action_id = pai.action_context_id

Line 315: FROM pay_input_values_f piv

311:
312: CURSOR csr_input_value_uom(p_input_value_id NUMBER,
313: p_effective_date DATE) IS
314: SELECT piv.uom
315: FROM pay_input_values_f piv
316: WHERE piv.input_value_id = p_input_value_id
317: AND p_effective_date BETWEEN
318: piv.effective_start_date AND piv.effective_end_date;
319:

Line 497: pay_input_values_f piv,

493: NVL(pet.reporting_name,pet.element_name) element_name,
494: pec.classification_name,
495: piv.uom
496: FROM pay_element_classifications pec,
497: pay_input_values_f piv,
498: pay_element_types_f pet
499: WHERE pec.classification_name IN
500: ('Court Orders',
501: 'Voluntary Deductions',

Line 537: pay_input_values_f piv,

533: NVL(pet.reporting_name,pet.element_name) element_name,
534: 'Information',
535: piv.uom
536: FROM pay_element_classifications pec,
537: pay_input_values_f piv,
538: pay_element_types_f pet
539: WHERE pec.classification_name IN ( 'Information')
540: AND pec.business_group_id IS NULL
541: AND pec.legislation_code = 'IE'

Line 948: FROM pay_input_values_f piv,

944: CURSOR csr_input_value_id(p_element_name CHAR,
945: p_value_name CHAR) IS
946: SELECT pet.element_type_id,
947: piv.input_value_id
948: FROM pay_input_values_f piv,
949: pay_element_types_f pet
950: WHERE piv.element_type_id = pet.element_type_id
951: AND pet.legislation_code = 'IE'
952: AND pet.element_name = p_element_name

Line 2021: FROM pay_input_values_f piv,

2017: /* CURSOR csr_input_value_id(p_element_name CHAR,
2018: p_value_name CHAR) IS
2019: SELECT pet.element_type_id,
2020: piv.input_value_id
2021: FROM pay_input_values_f piv,
2022: pay_element_types_f pet
2023: WHERE piv.element_type_id = pet.element_type_id
2024: AND pet.legislation_code = 'IE'
2025: AND pet.element_name = p_element_name

Line 3156: FROM pay_input_values_f piv,

3152: CURSOR csr_input_value_id(p_element_name CHAR,
3153: p_value_name CHAR) IS
3154: SELECT pet.element_type_id,
3155: piv.input_value_id
3156: FROM pay_input_values_f piv,
3157: pay_element_types_f pet
3158: WHERE piv.element_type_id = pet.element_type_id
3159: AND pet.legislation_code = 'IE'
3160: AND pet.element_name = p_element_name