APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 154: FROM pay_element_types_f pet,

150:
151: CURSOR csr_element_type(p_element_type_id NUMBER,
152: p_effective_date DATE) IS
153: SELECT pet.formula_id
154: FROM pay_element_types_f pet,
155: ff_formulas_f fff
156: WHERE pet.element_type_id = p_element_type_id
157: AND pet.formula_id = fff.formula_id
158: AND fff.formula_name = 'ONCE_EACH_PERIOD'

Line 387: pay_element_types_f pet

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
391: AND pec.legislation_code = 'GB'

Line 410: pay_element_types_f pet

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
414: AND pec.legislation_code = 'GB'

Line 642: pay_element_types_f pet

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
646: AND piv.name = p_value_name;

Line 1475: pay_element_types_f pet

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
1479: AND piv.name = p_value_name;

Line 2683: pay_element_types_f pet, -- element types processed by the payroll run/quickpay

2679: pay_action_information pai, -- archived element/input value definition
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