APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 167: FROM pay_input_values_f piv

163:
164: CURSOR csr_input_value_uom(p_input_value_id NUMBER,
165: p_effective_date DATE) IS
166: SELECT piv.uom
167: FROM pay_input_values_f piv
168: WHERE piv.input_value_id = p_input_value_id
169: AND p_effective_date BETWEEN
170: piv.effective_start_date AND piv.effective_end_date;
171:

Line 386: pay_input_values_f piv,

382: NVL(pet.reporting_name,pet.element_name) element_name,
383: pec.classification_name,
384: piv.uom
385: FROM pay_element_classifications pec,
386: pay_input_values_f piv,
387: pay_element_types_f pet
388: WHERE pec.classification_name IN ('Court Orders','Voluntary Deductions','Pre Tax Deductions',
389: 'PAYE','NI','Earnings','Direct Payment','Pre NI Deductions','Pre Tax and NI Deductions')
390: AND pec.business_group_id IS NULL

Line 409: pay_input_values_f piv,

405: NVL(pet.reporting_name,pet.element_name) element_name,
406: pec.classification_name,
407: piv.uom
408: FROM pay_element_classifications pec,
409: pay_input_values_f piv,
410: pay_element_types_f pet
411: WHERE pec.classification_name IN ('Court Orders','Voluntary Deductions','Pre Tax Deductions',
412: 'PAYE','NI','Earnings','Direct Payment','Pre NI Deductions','Pre Tax and NI Deductions')
413: AND pec.business_group_id IS NULL

Line 641: FROM pay_input_values_f piv,

637: CURSOR csr_input_value_id(p_element_name CHAR,
638: p_value_name CHAR) IS
639: SELECT pet.element_type_id,
640: piv.input_value_id
641: FROM pay_input_values_f piv,
642: pay_element_types_f pet
643: WHERE piv.element_type_id = pet.element_type_id
644: AND pet.legislation_code = 'GB'
645: AND pet.element_name = p_element_name

Line 1058: ,pay_input_values_f piv

1054: SELECT prrv.result_value reference
1055: FROM pay_element_entries_f peef
1056: ,pay_run_results prr
1057: ,pay_run_result_values prrv
1058: ,pay_input_values_f piv
1059: WHERE peef.element_entry_id = p_element_entry_id
1060: and piv.name ='Reference'
1061: and piv.legislation_code='GB'
1062: and peef.element_type_id = piv.element_type_id

Line 1474: FROM pay_input_values_f piv,

1470: CURSOR csr_input_value_id(p_element_name CHAR,
1471: p_value_name CHAR) IS
1472: SELECT pet.element_type_id,
1473: piv.input_value_id
1474: FROM pay_input_values_f piv,
1475: pay_element_types_f pet
1476: WHERE piv.element_type_id = pet.element_type_id
1477: AND pet.legislation_code = 'GB'
1478: AND pet.element_name = p_element_name

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

2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2681: pay_assignment_actions paa, -- payroll run/quickpay action
2682: pay_payroll_actions ppa1, -- payroll run/quickpay action
2683: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2684: pay_input_values_f piv, -- "Pay values" of type Money
2685: pay_run_results prr, -- run result created by the payroll run/quick pay
2686: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
2687: WHERE lck.locking_action_id = paa2.assignment_action_id
2688: AND paa2.payroll_action_id = pai.action_context_id