APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 250: ,pay_element_types_f pet

246: ,pec.classification_name ele_class
247: ,piv.uom uom
248: FROM hr_organization_information hoi
249: ,pay_element_classifications pec
250: ,pay_element_types_f pet
251: ,pay_input_values_f piv
252: WHERE hoi.organization_id = p_bus_grp_id
253: AND hoi.org_information_context = 'Business Group:Payslip Info'
254: AND hoi.org_information1 = 'ELEMENT'

Line 271: ,pay_element_types_f pet

267: ,piv.lookup_type lookup_type
268: ,piv.value_set_id value_set_id
269: FROM hr_organization_information hoi
270: ,pay_element_classifications pec
271: ,pay_element_types_f pet
272: ,pay_input_values_f piv
273: WHERE hoi.organization_id = p_bus_grp_id
274: AND hoi.org_information_context = 'Business Group:Payslip Info'
275: AND hoi.org_information1 = 'ELEMENT'

Line 1892: FROM pay_element_types_f et

1888: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1889: ,et.element_type_id element_type_id
1890: ,iv.input_value_id input_value_id
1891: ,iv.uom uom
1892: FROM pay_element_types_f et
1893: , pay_element_types_f_tl pettl
1894: , pay_input_values_f iv
1895: , pay_element_classifications classification
1896: WHERE et.element_type_id = iv.element_type_id

Line 1893: , pay_element_types_f_tl pettl

1889: ,et.element_type_id element_type_id
1890: ,iv.input_value_id input_value_id
1891: ,iv.uom uom
1892: FROM pay_element_types_f et
1893: , pay_element_types_f_tl pettl
1894: , pay_input_values_f iv
1895: , pay_element_classifications classification
1896: WHERE et.element_type_id = iv.element_type_id
1897: AND et.element_type_id = pettl.element_type_id

Line 1919: FROM pay_element_types_f et

1915: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1916: ,et.element_type_id element_type_id
1917: ,iv.input_value_id input_value_id
1918: ,iv.uom uom
1919: FROM pay_element_types_f et
1920: , pay_element_types_f_tl pettl
1921: , pay_input_values_f iv
1922: , pay_element_classifications classification
1923: WHERE et.element_type_id = iv.element_type_id

Line 1920: , pay_element_types_f_tl pettl

1916: ,et.element_type_id element_type_id
1917: ,iv.input_value_id input_value_id
1918: ,iv.uom uom
1919: FROM pay_element_types_f et
1920: , pay_element_types_f_tl pettl
1921: , pay_input_values_f iv
1922: , pay_element_classifications classification
1923: WHERE et.element_type_id = iv.element_type_id
1924: AND et.element_type_id = pettl.element_type_id

Line 1947: FROM pay_element_types_f et

1943: ,et.element_type_id element_type_id
1944: ,iv.input_value_id input_value_id
1945: ,iv.uom uom
1946: ,classification.classification_name ele_class
1947: FROM pay_element_types_f et
1948: , pay_element_types_f_tl pettl
1949: , pay_input_values_f iv
1950: , pay_element_classifications classification
1951: WHERE et.element_type_id = iv.element_type_id

Line 1948: , pay_element_types_f_tl pettl

1944: ,iv.input_value_id input_value_id
1945: ,iv.uom uom
1946: ,classification.classification_name ele_class
1947: FROM pay_element_types_f et
1948: , pay_element_types_f_tl pettl
1949: , pay_input_values_f iv
1950: , pay_element_classifications classification
1951: WHERE et.element_type_id = iv.element_type_id
1952: AND et.element_type_id = pettl.element_type_id

Line 1978: FROM pay_element_types_f et

1974: ,et.element_type_id element_type_id
1975: ,iv.input_value_id input_value_id
1976: ,iv.uom uom
1977: ,classification.classification_name ele_class
1978: FROM pay_element_types_f et
1979: , pay_element_types_f_tl pettl
1980: , pay_input_values_f iv
1981: , pay_element_classifications classification
1982: WHERE et.element_type_id = iv.element_type_id

Line 1979: , pay_element_types_f_tl pettl

1975: ,iv.input_value_id input_value_id
1976: ,iv.uom uom
1977: ,classification.classification_name ele_class
1978: FROM pay_element_types_f et
1979: , pay_element_types_f_tl pettl
1980: , pay_input_values_f iv
1981: , pay_element_classifications classification
1982: WHERE et.element_type_id = iv.element_type_id
1983: AND et.element_type_id = pettl.element_type_id

Line 2823: ,pay_element_types_f pet

2819: ,ppa.payroll_id
2820: ,pap.business_group_id
2821: ,pap.accrual_plan_id
2822: FROM pay_accrual_plans pap
2823: ,pay_element_types_f pet
2824: ,pay_element_links_f pel
2825: ,pay_element_entries_f pee
2826: ,pay_assignment_actions paa
2827: ,pay_payroll_actions ppa

Line 2971: ,pay_element_types_f pet

2967: ,pec.classification_name
2968: ,piv.uom
2969: FROM hr_organization_information hoi
2970: ,pay_element_classifications pec
2971: ,pay_element_types_f pet
2972: ,pay_input_values_f piv
2973: WHERE hoi.organization_id = p_bus_grp_id
2974: AND hoi.org_information_context = 'Business Group:Payslip Info'
2975: AND hoi.org_information1 = 'ELEMENT'

Line 3866: ,pay_element_types_f et

3862: FROM per_all_assignments_f asg1
3863: ,per_all_assignments_f asg2
3864: ,per_all_people_f per
3865: ,pay_element_links_f el
3866: ,pay_element_types_f et
3867: ,pay_input_values_f iv1
3868: ,pay_element_entries_f ee
3869: ,pay_element_entry_values_f eev1
3870: WHERE asg1.assignment_id = p_assignment_id

Line 3894: ,pay_element_types_f et

3890: SELECT ee.effective_start_date
3891: ,eev1.screen_entry_value screen_entry_value
3892: FROM per_all_assignments_f asg1
3893: ,pay_element_links_f el
3894: ,pay_element_types_f et
3895: ,pay_input_values_f iv1
3896: ,pay_element_entries_f ee
3897: ,pay_element_entry_values_f eev1
3898: WHERE asg1.assignment_id = p_assignment_id

Line 4227: FROM pay_element_types_f et

4223: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
4224: ,et.element_type_id element_type_id
4225: ,iv.input_value_id input_value_id
4226: ,iv.uom uom
4227: FROM pay_element_types_f et
4228: , pay_element_types_f_tl pettl
4229: , pay_input_values_f iv
4230: , pay_element_classifications classification
4231: WHERE et.element_type_id = iv.element_type_id

Line 4228: , pay_element_types_f_tl pettl

4224: ,et.element_type_id element_type_id
4225: ,iv.input_value_id input_value_id
4226: ,iv.uom uom
4227: FROM pay_element_types_f et
4228: , pay_element_types_f_tl pettl
4229: , pay_input_values_f iv
4230: , pay_element_classifications classification
4231: WHERE et.element_type_id = iv.element_type_id
4232: AND et.element_type_id = pettl.element_type_id

Line 4254: FROM pay_element_types_f et

4250: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
4251: ,et.element_type_id element_type_id
4252: ,iv.input_value_id input_value_id
4253: ,iv.uom uom
4254: FROM pay_element_types_f et
4255: , pay_element_types_f_tl pettl
4256: , pay_input_values_f iv
4257: , pay_element_classifications classification
4258: WHERE et.element_type_id = iv.element_type_id

Line 4255: , pay_element_types_f_tl pettl

4251: ,et.element_type_id element_type_id
4252: ,iv.input_value_id input_value_id
4253: ,iv.uom uom
4254: FROM pay_element_types_f et
4255: , pay_element_types_f_tl pettl
4256: , pay_input_values_f iv
4257: , pay_element_classifications classification
4258: WHERE et.element_type_id = iv.element_type_id
4259: AND et.element_type_id = pettl.element_type_id

Line 4364: FROM pay_element_types_f

4360: /* cursor to get the element type id for 'Tax' element */
4361: /*
4362: CURSOR csr_get_tax_element IS
4363: SELECT element_type_id
4364: FROM pay_element_types_f
4365: WHERE element_name = 'Tax'
4366: AND legislation_code = 'NO'
4367: AND business_group_id IS NULL
4368: AND p_date_earned BETWEEN effective_start_date AND effective_end_date ;

Line 4377: from pay_element_types_f

4373: -- cursor to get the name of the element
4374:
4375: cursor csr_element_name (p_element_type_id NUMBER) IS
4376: select element_name
4377: from pay_element_types_f
4378: where element_type_id = p_element_type_id
4379: and p_date_earned between effective_start_date and effective_end_date ;
4380:
4381: -----------------------------------------

Line 4409: ,pay_element_types_f et

4405: CURSOR csr_tax_period_override (p_assignment_id NUMBER, p_input_value VARCHAR2) IS
4406: SELECT eev1.screen_entry_value screen_entry_value
4407: FROM per_all_assignments_f asg1
4408: ,pay_element_links_f el
4409: ,pay_element_types_f et
4410: ,pay_input_values_f iv1
4411: ,pay_element_entries_f ee
4412: ,pay_element_entry_values_f eev1
4413: WHERE asg1.assignment_id = p_assignment_id