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 522: PAY_ELEMENT_TYPES_F pet,

518: /* Cursor for Bug 3715182 and 3719168 */
519: CURSOR c_garn_max_fee_amt is
520: select target.MAX_FEE_AMOUNT from
521: PAY_US_GARN_FEE_RULES_F target,
522: PAY_ELEMENT_TYPES_F pet,
523: PAY_ELEMENT_ENTRIES_F pee
524: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
525: AND target.garn_category = pet.element_information1
526: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date

Line 563: pay_element_types_f pet_base,

559: from pay_element_entries_f peef_base,
560: pay_element_entries_f peef_si,
561: pay_element_entry_values_f peev_si,
562: pay_input_values_f pivf_si,
563: pay_element_types_f pet_base,
564: pay_element_types_f pet_si
565: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
566: and peef_base.element_type_id = pet_base.element_type_id
567: and pet_base.element_information18 = pet_si.element_type_id

Line 564: pay_element_types_f pet_si

560: pay_element_entries_f peef_si,
561: pay_element_entry_values_f peev_si,
562: pay_input_values_f pivf_si,
563: pay_element_types_f pet_base,
564: pay_element_types_f pet_si
565: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
566: and peef_base.element_type_id = pet_base.element_type_id
567: and pet_base.element_information18 = pet_si.element_type_id
568: and peef_base.assignment_id = peef_si.assignment_id

Line 1496: PAY_ELEMENT_TYPES_F pet

1492: /* Cursor for Bug 3715182 and 3719168 */
1493: CURSOR c_garn_max_fee_amt is
1494: select target.MAX_FEE_AMOUNT from
1495: PAY_US_GARN_FEE_RULES_F target,
1496: PAY_ELEMENT_TYPES_F pet
1497: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
1498: AND target.garn_category = pet.element_information1
1499: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date
1500: AND target.effective_end_date

Line 1510: from pay_element_types_f

1506: -- Bug 4079142
1507: -- Cursor to get the element name to be used in the message.
1508: CURSOR csr_get_ele_name (p_ele_type_id number) is
1509: select rtrim(element_name,' Calculator' )
1510: from pay_element_types_f
1511: where element_type_id = p_ele_type_id;
1512:
1513: -- Bug# 6132855
1514: -- Federal Minimum Wage now is stored in JIT table

Line 2888: pay_element_types_f petf,

2884: -- Checking Element level Override
2885: CURSOR csr_elem_ovrd_duration IS
2886: SELECT petei.eei_information12
2887: FROM pay_element_entries_f peef,
2888: pay_element_types_f petf,
2889: pay_element_types_f petf_calc,
2890: pay_element_type_extra_info petei
2891: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
2892: AND petf.element_type_id = peef.element_type_id

Line 2889: pay_element_types_f petf_calc,

2885: CURSOR csr_elem_ovrd_duration IS
2886: SELECT petei.eei_information12
2887: FROM pay_element_entries_f peef,
2888: pay_element_types_f petf,
2889: pay_element_types_f petf_calc,
2890: pay_element_type_extra_info petei
2891: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
2892: AND petf.element_type_id = peef.element_type_id
2893: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 3204: PAY_ELEMENT_TYPES_F pet

3200: /* Bug 3722152 */
3201: CURSOR c_garn_max_fee_amt is
3202: select target.MAX_FEE_AMOUNT from
3203: PAY_US_GARN_FEE_RULES_F target,
3204: PAY_ELEMENT_TYPES_F pet
3205: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
3206: AND target.garn_category = pet.element_information1
3207: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date
3208: AND target.effective_end_date

Line 3217: from pay_element_types_f

3213: -- Bug 4079142
3214: -- Cursor to get the element name to be used in the message.
3215: CURSOR csr_get_ele_name (p_ele_type_id number) is
3216: select rtrim(element_name,' Calculator' )
3217: from pay_element_types_f
3218: where element_type_id = p_ele_type_id;
3219:
3220: -- Bug 4556146
3221: CURSOR csr_get_entry_start_date is

Line 3307: pay_element_types_f petf,

3303: -- Checking If Multiple Element level Overrides exist
3304: CURSOR csr_elem_ovrd_fed_stat_M_count IS
3305: SELECT count(petei.eei_information13)
3306: FROM pay_element_entries_f peef,
3307: pay_element_types_f petf,
3308: pay_element_types_f petf_calc,
3309: pay_element_type_extra_info petei
3310: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3311: AND petf.element_type_id = peef.element_type_id

Line 3308: pay_element_types_f petf_calc,

3304: CURSOR csr_elem_ovrd_fed_stat_M_count IS
3305: SELECT count(petei.eei_information13)
3306: FROM pay_element_entries_f peef,
3307: pay_element_types_f petf,
3308: pay_element_types_f petf_calc,
3309: pay_element_type_extra_info petei
3310: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3311: AND petf.element_type_id = peef.element_type_id
3312: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 3325: pay_element_types_f petf,

3321: CURSOR csr_elem_ovrd_fed_stat_M IS
3322: SELECT petei.eei_information13
3323: ,petei.eei_information14
3324: FROM pay_element_entries_f peef,
3325: pay_element_types_f petf,
3326: pay_element_types_f petf_calc,
3327: pay_element_type_extra_info petei
3328: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3329: AND petf.element_type_id = peef.element_type_id

Line 3326: pay_element_types_f petf_calc,

3322: SELECT petei.eei_information13
3323: ,petei.eei_information14
3324: FROM pay_element_entries_f peef,
3325: pay_element_types_f petf,
3326: pay_element_types_f petf_calc,
3327: pay_element_type_extra_info petei
3328: WHERE peef.element_entry_id = CTX_ORIGINAL_ENTRY_ID
3329: AND petf.element_type_id = peef.element_type_id
3330: AND petf_calc.element_type_id = CTX_ELEMENT_TYPE_ID

Line 5154: from pay_element_types_f

5150: -- Bug 4079142
5151: -- Cursor to get the element name to be used in the message.
5152: CURSOR csr_get_ele_name (p_ele_type_id number) is
5153: select rtrim(element_name,' Calculator' )
5154: from pay_element_types_f
5155: where element_type_id = p_ele_type_id;
5156:
5157: -- Bug 3528349
5158: -- Cursor to fetch the Filing Status year for the person if specified