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.PAY_US_INV_DED_FORMULAS dependencies on PAY_ELEMENT_TYPES_F

Line 596: PAY_ELEMENT_TYPES_F pet,

592: /* Cursor for Bug 3715182 and 3719168 */
593: CURSOR c_garn_max_fee_amt is
594: select target.MAX_FEE_AMOUNT from
595: PAY_US_GARN_FEE_RULES_F target,
596: PAY_ELEMENT_TYPES_F pet,
597: PAY_ELEMENT_ENTRIES_F pee
598: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
599: AND target.garn_category = pet.element_information1
600: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date

Line 637: pay_element_types_f pet_base,

633: from pay_element_entries_f peef_base,
634: pay_element_entries_f peef_si,
635: pay_element_entry_values_f peev_si,
636: pay_input_values_f pivf_si,
637: pay_element_types_f pet_base,
638: pay_element_types_f pet_si
639: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
640: and peef_base.element_type_id = pet_base.element_type_id
641: and pet_base.element_information18 = pet_si.element_type_id

Line 638: pay_element_types_f pet_si

634: pay_element_entries_f peef_si,
635: pay_element_entry_values_f peev_si,
636: pay_input_values_f pivf_si,
637: pay_element_types_f pet_base,
638: pay_element_types_f pet_si
639: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
640: and peef_base.element_type_id = pet_base.element_type_id
641: and pet_base.element_information18 = pet_si.element_type_id
642: and peef_base.assignment_id = peef_si.assignment_id

Line 1614: PAY_ELEMENT_TYPES_F pet

1610: /* Cursor for Bug 3715182 and 3719168 */
1611: CURSOR c_garn_max_fee_amt is
1612: select target.MAX_FEE_AMOUNT from
1613: PAY_US_GARN_FEE_RULES_F target,
1614: PAY_ELEMENT_TYPES_F pet
1615: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
1616: AND target.garn_category = pet.element_information1
1617: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date
1618: AND target.effective_end_date

Line 1628: from pay_element_types_f

1624: -- Bug 4079142
1625: -- Cursor to get the element name to be used in the message.
1626: CURSOR csr_get_ele_name (p_ele_type_id number) is
1627: select rtrim(element_name,' Calculator' )
1628: from pay_element_types_f
1629: where element_type_id = p_ele_type_id;
1630:
1631: -- Bug# 6132855
1632: -- Federal Minimum Wage now is stored in JIT table

Line 3538: pay_element_types_f petf,

3534: -- Checking Element level Override
3535: CURSOR csr_elem_ovrd_duration IS
3536: SELECT petei.eei_information12
3537: FROM pay_element_entries_f peef,
3538: pay_element_types_f petf,
3539: pay_element_types_f petf_calc,
3540: pay_element_type_extra_info petei
3541: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3542: AND petf.element_type_id = peef.element_type_id

Line 3539: pay_element_types_f petf_calc,

3535: CURSOR csr_elem_ovrd_duration IS
3536: SELECT petei.eei_information12
3537: FROM pay_element_entries_f peef,
3538: pay_element_types_f petf,
3539: pay_element_types_f petf_calc,
3540: pay_element_type_extra_info petei
3541: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3542: AND petf.element_type_id = peef.element_type_id
3543: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 3870: PAY_ELEMENT_TYPES_F pet

3866: /* Bug 3722152 */
3867: CURSOR c_garn_max_fee_amt is
3868: select target.MAX_FEE_AMOUNT from
3869: PAY_US_GARN_FEE_RULES_F target,
3870: PAY_ELEMENT_TYPES_F pet
3871: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
3872: AND target.garn_category = pet.element_information1
3873: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date
3874: AND target.effective_end_date

Line 3883: from pay_element_types_f

3879: -- Bug 4079142
3880: -- Cursor to get the element name to be used in the message.
3881: CURSOR csr_get_ele_name (p_ele_type_id number) is
3882: select rtrim(element_name,' Calculator' )
3883: from pay_element_types_f
3884: where element_type_id = p_ele_type_id;
3885:
3886: -- Bug 4556146
3887: CURSOR csr_get_entry_start_date is

Line 3973: pay_element_types_f petf,

3969: -- Checking If Multiple Element level Overrides exist
3970: CURSOR csr_elem_ovrd_fed_stat_M_count IS
3971: SELECT count(petei.eei_information13)
3972: FROM pay_element_entries_f peef,
3973: pay_element_types_f petf,
3974: pay_element_types_f petf_calc,
3975: pay_element_type_extra_info petei
3976: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3977: AND petf.element_type_id = peef.element_type_id

Line 3974: pay_element_types_f petf_calc,

3970: CURSOR csr_elem_ovrd_fed_stat_M_count IS
3971: SELECT count(petei.eei_information13)
3972: FROM pay_element_entries_f peef,
3973: pay_element_types_f petf,
3974: pay_element_types_f petf_calc,
3975: pay_element_type_extra_info petei
3976: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3977: AND petf.element_type_id = peef.element_type_id
3978: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 3991: pay_element_types_f petf,

3987: CURSOR csr_elem_ovrd_fed_stat_M IS
3988: SELECT petei.eei_information13
3989: ,petei.eei_information14
3990: FROM pay_element_entries_f peef,
3991: pay_element_types_f petf,
3992: pay_element_types_f petf_calc,
3993: pay_element_type_extra_info petei
3994: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3995: AND petf.element_type_id = peef.element_type_id

Line 3992: pay_element_types_f petf_calc,

3988: SELECT petei.eei_information13
3989: ,petei.eei_information14
3990: FROM pay_element_entries_f peef,
3991: pay_element_types_f petf,
3992: pay_element_types_f petf_calc,
3993: pay_element_type_extra_info petei
3994: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3995: AND petf.element_type_id = peef.element_type_id
3996: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 6020: from pay_element_types_f

6016: -- Bug 4079142
6017: -- Cursor to get the element name to be used in the message.
6018: CURSOR csr_get_ele_name (p_ele_type_id number) is
6019: select rtrim(element_name,' Calculator' )
6020: from pay_element_types_f
6021: where element_type_id = p_ele_type_id;
6022:
6023: -- Bug 3528349
6024: -- Cursor to fetch the Filing Status year for the person if specified