APPS.PAY_CORE_FF_UDFS dependencies on PAY_ELEMENT_TYPES_F

Line 338: ln_bg_id pay_element_types_f.business_group_id%TYPE;

334: v_schedule varchar2(200);
335: ln_regsal_ele_entry_id number;
336: lv_frequency varchar2(100);
337: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information10%TYPE;
338: ln_bg_id pay_element_types_f.business_group_id%TYPE;
339: lv_leg_code pay_element_types_f.legislation_code%TYPE;
340: lv_class_name pay_element_classifications.classification_name%TYPE;
341: lb_regular_salary boolean;
342:

Line 339: lv_leg_code pay_element_types_f.legislation_code%TYPE;

335: ln_regsal_ele_entry_id number;
336: lv_frequency varchar2(100);
337: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information10%TYPE;
338: ln_bg_id pay_element_types_f.business_group_id%TYPE;
339: lv_leg_code pay_element_types_f.legislation_code%TYPE;
340: lv_class_name pay_element_classifications.classification_name%TYPE;
341: lb_regular_salary boolean;
342:
343:

Line 349: ,pay_element_types_f pet

345: ,cp_assignment_id IN NUMBER
346: ,cp_effective_date IN DATE) IS
347: SELECT peef.element_entry_id
348: FROM pay_element_entries_f peef
349: ,pay_element_types_f pet
350: where peef.element_type_id = pet.element_type_id
351: and peef.assignment_id = cp_assignment_id
352: and pet.element_name = 'Regular Salary'
353: and pet.legislation_code = cp_leg_code

Line 374: ,pay_element_types_f pet

370: ,cp_assignment_id IN NUMBER
371: ,cp_bg_id IN NUMBER) IS
372: SELECT petei.eei_information10
373: FROM pay_element_entries_f peef
374: ,pay_element_types_f pet
375: ,pay_element_type_extra_info petei
376: where peef.element_entry_id = cp_element_entry_id
377: and peef.assignment_id = cp_assignment_id
378: and peef.element_type_id = pet.element_type_id

Line 394: ,pay_element_types_f pet

390: SELECT pet.business_group_id
391: ,pet.legislation_code
392: ,pec.classification_name
393: FROM pay_element_entries_f peef
394: ,pay_element_types_f pet
395: ,pay_element_classifications pec
396: WHERE peef.element_entry_id = cp_element_entry_id
397: and peef.assignment_id = cp_assignment_id
398: and peef.element_type_id = pet.element_type_id

Line 1820: the date join for pay_element_types_f */

1816:
1817: hr_utility.trace(' p_pay_basis IS NULL');
1818: hr_utility.trace('In p_inpval_name = RATE');
1819: /* Changed the element_name and name to init case and added
1820: the date join for pay_element_types_f */
1821:
1822: begin
1823: SELECT IPV.input_value_id
1824: INTO v_inpval_id

Line 1826: pay_element_types_f ELT

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
1830: and ELT.element_type_id = IPV.element_type_id

Line 1852: the date join for pay_element_types_f */

1848: end;
1849: --
1850: ELSIF UPPER(p_inpval_name) = 'RATE CODE' THEN
1851: /* Changed the element_name and name to init case and added
1852: the date join for pay_element_types_f */
1853:
1854: begin
1855: hr_utility.trace('In RATE CODE');
1856:

Line 1860: pay_element_types_f ELT

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
1864: and ELT.element_type_id = IPV.element_type_id

Line 1887: the date join for pay_element_types_f */

1883: --
1884: ELSIF UPPER(p_inpval_name) = 'MONTHLY SALARY' THEN
1885:
1886: /* Changed the element_name and name to init case and added
1887: the date join for pay_element_types_f */
1888:
1889: begin
1890: hr_utility.trace('in MONTHLY SALARY');
1891:

Line 1895: pay_element_types_f ELT

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
1899: and ELT.element_type_id = IPV.element_type_id

Line 3070: , pay_element_types_f ETYPE

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
3074: and ASSIGN.assignment_id = l_assignment_id