eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNSQL dependencies on PAY_ELEMENT_TYPES_F

Line 173: input_curr pay_element_types_f.input_currency_code%type;

169: lookup_type hr_lookups.lookup_type%type;
170: -- Bugfix 2827092
171: --value_set_id pay_input_values_f.value_set_id%type;
172: uom pay_input_values_f.uom%type;
173: input_curr pay_element_types_f.input_currency_code%type;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;
177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;

Line 215: pay_element_types_f pet,

211: uom,
212: input_curr
213: from pay_element_entries_f pee,
214: pay_element_links_f pel,
215: pay_element_types_f pet,
216: pay_input_values_f piv,
217: per_all_assignments_f asg
218: where asg.assignment_id = p_assignment_id
219: and p_effective_date between

Line 1509: pay_element_types_f petf

1505: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1506: from per_all_assignments_f pay_asg,
1507: hr_assignment_sets has,
1508: PAY_ELEMENT_SET_MEMBERS pesm,
1509: pay_element_types_f petf
1510: where pay_asg.business_group_id = :p_bgid
1511: and has.assignment_set_id = :pasetid
1512: and pay_asg.assignment_type = ''E''
1513: and fnd_date.canonical_to_date(:p_effective_date)

Line 1542: pay_element_types_f petf

1538: select pay_asg.assignment_id, pay_asg.assignment_number,
1539: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1540: from per_all_assignments_f pay_asg,
1541: hr_assignment_sets has,
1542: pay_element_types_f petf
1543: where pay_asg.business_group_id = :p_bgid
1544: and has.assignment_set_id = :pasetid
1545: and pay_asg.assignment_type = ''E''
1546: and fnd_date.canonical_to_date(:p_effective_date)

Line 1566: pay_element_types_f petf

1562: from per_all_assignments_f pay_asg,
1563: hr_assignment_sets has,
1564: hr_assignment_set_amendments amd,
1565: PAY_ELEMENT_SET_MEMBERS pesm,
1566: pay_element_types_f petf
1567: where pay_asg.business_group_id = :p_bgid
1568: and has.assignment_set_id = :pasetid
1569: and amd.assignment_set_id = has.assignment_set_id
1570: and pay_asg.assignment_id = amd.assignment_id

Line 1602: pay_element_types_f petf

1598: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1599: from per_all_assignments_f pay_asg,
1600: hr_assignment_sets has,
1601: hr_assignment_set_amendments amd,
1602: pay_element_types_f petf
1603: where pay_asg.business_group_id = :p_bgid
1604: and has.assignment_set_id = :pasetid
1605: and amd.assignment_set_id = has.assignment_set_id
1606: and pay_asg.assignment_id = amd.assignment_id

Line 1627: pay_element_types_f petf

1623: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1624: from per_all_assignments_f pay_asg,
1625: hr_assignment_sets has,
1626: PAY_ELEMENT_SET_MEMBERS pesm,
1627: pay_element_types_f petf
1628: where pay_asg.business_group_id = :p_bgid
1629: and has.assignment_set_id = :pasetid
1630: and pay_asg.assignment_type = ''E''
1631: and fnd_date.canonical_to_date(:p_effective_date) between

Line 1665: pay_element_types_f petf

1661: select pay_asg.assignment_id, pay_asg.assignment_number,
1662: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1663: from per_all_assignments_f pay_asg,
1664: hr_assignment_sets has,
1665: pay_element_types_f petf
1666: where pay_asg.business_group_id = :p_bgid
1667: and has.assignment_set_id = :pasetid
1668: and pay_asg.assignment_type = ''E''
1669: and fnd_date.canonical_to_date(:p_effective_date)

Line 1701: pay_element_types_f petf

1697: select pay_asg.assignment_id, pay_asg.assignment_number,
1698: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1699: from per_all_assignments_f pay_asg,
1700: PAY_ELEMENT_SET_MEMBERS pesm,
1701: pay_element_types_f petf
1702: where pay_asg.business_group_id = :p_bgid
1703: and pay_asg.assignment_type = ''E''
1704: and fnd_date.canonical_to_date(:p_effective_date) between
1705: pay_asg.effective_start_date and pay_asg.effective_end_date

Line 1731: pay_element_types_f petf

1727: sqlstr := '
1728: select pay_asg.assignment_id, pay_asg.assignment_number,
1729: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1730: from per_all_assignments_f pay_asg,
1731: pay_element_types_f petf
1732: where pay_asg.business_group_id = :p_bgid
1733: and pay_asg.assignment_type = ''E''
1734: and fnd_date.canonical_to_date(:p_effective_date)
1735: between petf.effective_start_date

Line 3088: pay_element_types_f pay_pet,

3084: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3085: and exists
3086: (select null
3087: from pay_element_entries_f pay_pee,
3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3092: pay_input_values_f pay_piv2

Line 3138: pay_element_types_f pay_pet,

3134: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3135: and exists
3136: (select null
3137: from pay_element_entries_f pay_pee,
3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,
3142: pay_input_values_f pay_piv2