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 168: input_curr pay_element_types_f.input_currency_code%type;

164: lookup_type hr_lookups.lookup_type%type;
165: -- Bugfix 2827092
166: --value_set_id pay_input_values_f.value_set_id%type;
167: uom pay_input_values_f.uom%type;
168: input_curr pay_element_types_f.input_currency_code%type;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;
172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;

Line 210: pay_element_types_f pet,

206: uom,
207: input_curr
208: from pay_element_entries_f pee,
209: pay_element_links_f pel,
210: pay_element_types_f pet,
211: pay_input_values_f piv,
212: per_all_assignments_f asg
213: where asg.assignment_id = p_assignment_id
214: and p_effective_date between

Line 1474: pay_element_types_f petf

1470: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1471: from per_all_assignments_f pay_asg,
1472: hr_assignment_sets has,
1473: PAY_ELEMENT_SET_MEMBERS pesm,
1474: pay_element_types_f petf
1475: where pay_asg.business_group_id = :p_bgid
1476: and has.assignment_set_id = :pasetid
1477: and pay_asg.assignment_type = ''E''
1478: and fnd_date.canonical_to_date(:p_effective_date)

Line 1507: pay_element_types_f petf

1503: select pay_asg.assignment_id, pay_asg.assignment_number,
1504: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1505: from per_all_assignments_f pay_asg,
1506: hr_assignment_sets has,
1507: pay_element_types_f petf
1508: where pay_asg.business_group_id = :p_bgid
1509: and has.assignment_set_id = :pasetid
1510: and pay_asg.assignment_type = ''E''
1511: and fnd_date.canonical_to_date(:p_effective_date)

Line 1531: pay_element_types_f petf

1527: from per_all_assignments_f pay_asg,
1528: hr_assignment_sets has,
1529: hr_assignment_set_amendments amd,
1530: PAY_ELEMENT_SET_MEMBERS pesm,
1531: pay_element_types_f petf
1532: where pay_asg.business_group_id = :p_bgid
1533: and has.assignment_set_id = :pasetid
1534: and amd.assignment_set_id = has.assignment_set_id
1535: and pay_asg.assignment_id = amd.assignment_id

Line 1567: pay_element_types_f petf

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

Line 1592: pay_element_types_f petf

1588: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1589: from per_all_assignments_f pay_asg,
1590: hr_assignment_sets has,
1591: PAY_ELEMENT_SET_MEMBERS pesm,
1592: pay_element_types_f petf
1593: where pay_asg.business_group_id = :p_bgid
1594: and has.assignment_set_id = :pasetid
1595: and pay_asg.assignment_type = ''E''
1596: and fnd_date.canonical_to_date(:p_effective_date) between

Line 1630: pay_element_types_f petf

1626: select pay_asg.assignment_id, pay_asg.assignment_number,
1627: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1628: from per_all_assignments_f pay_asg,
1629: hr_assignment_sets has,
1630: pay_element_types_f petf
1631: where pay_asg.business_group_id = :p_bgid
1632: and has.assignment_set_id = :pasetid
1633: and pay_asg.assignment_type = ''E''
1634: and fnd_date.canonical_to_date(:p_effective_date)

Line 1666: pay_element_types_f petf

1662: select pay_asg.assignment_id, pay_asg.assignment_number,
1663: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1664: from per_all_assignments_f pay_asg,
1665: PAY_ELEMENT_SET_MEMBERS pesm,
1666: pay_element_types_f petf
1667: where pay_asg.business_group_id = :p_bgid
1668: and pay_asg.assignment_type = ''E''
1669: and fnd_date.canonical_to_date(:p_effective_date) between
1670: pay_asg.effective_start_date and pay_asg.effective_end_date

Line 1696: pay_element_types_f petf

1692: sqlstr := '
1693: select pay_asg.assignment_id, pay_asg.assignment_number,
1694: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1695: from per_all_assignments_f pay_asg,
1696: pay_element_types_f petf
1697: where pay_asg.business_group_id = :p_bgid
1698: and pay_asg.assignment_type = ''E''
1699: and fnd_date.canonical_to_date(:p_effective_date)
1700: between petf.effective_start_date

Line 3010: pay_element_types_f pay_pet,

3006: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3007: and exists
3008: (select null
3009: from pay_element_entries_f pay_pee,
3010: pay_element_types_f pay_pet,
3011: pay_element_entry_values_f pay_pev,
3012: pay_element_entry_values_f pay_pev2,
3013: pay_input_values_f pay_piv,
3014: pay_input_values_f pay_piv2

Line 3060: pay_element_types_f pay_pet,

3056: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3057: and exists
3058: (select null
3059: from pay_element_entries_f pay_pee,
3060: pay_element_types_f pay_pet,
3061: pay_element_entry_values_f pay_pev,
3062: pay_element_entry_values_f pay_pev2,
3063: pay_input_values_f pay_piv,
3064: pay_input_values_f pay_piv2