DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_INPUT_VALUES_F

Line 1825: FROM pay_input_values_f IPV,

1821:
1822: begin
1823: SELECT IPV.input_value_id
1824: INTO v_inpval_id
1825: FROM pay_input_values_f IPV,
1826: pay_element_types_f ELT
1827: WHERE ELT.element_name = 'Regular Wages'
1828: and p_period_start BETWEEN ELT.effective_start_date
1829: AND ELT.effective_end_date

Line 1859: FROM pay_input_values_f IPV,

1855: hr_utility.trace('In RATE CODE');
1856:
1857: SELECT IPV.input_value_id
1858: INTO v_inpval_id
1859: FROM pay_input_values_f IPV,
1860: pay_element_types_f ELT
1861: WHERE ELT.element_name = 'Regular Wages'
1862: and p_period_start BETWEEN ELT.effective_start_date
1863: AND ELT.effective_end_date

Line 1894: FROM pay_input_values_f IPV,

1890: hr_utility.trace('in MONTHLY SALARY');
1891:
1892: SELECT IPV.input_value_id
1893: INTO v_inpval_id
1894: FROM pay_input_values_f IPV,
1895: pay_element_types_f ELT
1896: WHERE ELT.element_name = 'Regular Salary'
1897: and p_period_start BETWEEN ELT.effective_start_date
1898: AND ELT.effective_end_date

Line 3069: , pay_input_values_f INPUTV

3065: , INPUTV.input_value_id
3066: from
3067: per_all_assignments_f ASSIGN
3068: , per_pay_bases BASES
3069: , pay_input_values_f INPUTV
3070: , pay_element_types_f ETYPE
3071: , pay_rates RATE
3072: where l_date_earned BETWEEN ASSIGN.effective_start_date
3073: AND ASSIGN.effective_end_date