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_ENTRIES_F

Line 523: PAY_ELEMENT_ENTRIES_F pee

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
527: AND target.effective_end_date

Line 536: FROM pay_element_entries_f

532:
533: /* Cursot to return the Initial Fee Flag value Bug 3549298 */
534: CURSOR csr_get_ini_fee_flag is
535: SELECT nvl(entry_information9, 'N')
536: FROM pay_element_entries_f
537: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
538: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
539: AND P_CTX_DATE_EARNED BETWEEN effective_start_date and effective_end_date;
540:

Line 544: from pay_element_entries_f peef,

540:
541: -- Get the value entered for Allowances Input Value
542: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
543: select peev.screen_entry_value
544: from pay_element_entries_f peef,
545: pay_element_entry_values_f peev,
546: pay_input_values_f pivf
547: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
548: and peev.element_entry_id = peef.element_entry_id

Line 559: from pay_element_entries_f peef_base,

555: -- Bug# 5672067
556: -- Get the Screen Entry Value for 'Replace Amt' Input Values
557: CURSOR c_get_Replace_Amount_val(c_input_value_name varchar2) IS
558: select peev_si.screen_entry_value
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,

Line 560: pay_element_entries_f peef_si,

556: -- Get the Screen Entry Value for 'Replace Amt' Input Values
557: CURSOR c_get_Replace_Amount_val(c_input_value_name varchar2) IS
558: select peev_si.screen_entry_value
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

Line 1466: FROM pay_element_entries_f

1462: SELECT nvl(entry_information4, default_number),
1463: nvl(entry_information5, default_number),
1464: nvl(entry_information6, default_number),
1465: nvl(entry_information7, default_number)
1466: FROM pay_element_entries_f
1467: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
1468: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
1469: AND c_override_date BETWEEN effective_start_date and effective_end_date;
1470:

Line 1475: pay_element_entries_f pee

1471: /*-- Cursor for Bug 3704744 --*/
1472: CURSOR csr_get_proration_ovrd is
1473: select aei.aei_information3
1474: from per_assignment_extra_info aei,
1475: pay_element_entries_f pee
1476: where aei.assignment_id = pee.assignment_id
1477: and aei.information_type = 'US_PRORATION_RULE'
1478: and aei.aei_information_category = 'US_PRORATION_RULE'
1479: and aei.aei_information2 = garn_cat

Line 1486: FROM pay_element_entries_f

1482:
1483: /* Cursot to return the Initial Fee Flag value Bug 3549298 */
1484: CURSOR csr_get_ini_fee_flag is
1485: SELECT nvl(entry_information9, 'N')
1486: FROM pay_element_entries_f
1487: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
1488: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
1489: AND P_CTX_DATE_EARNED BETWEEN effective_start_date and effective_end_date;
1490:

Line 2879: FROM pay_element_entries_f

2875: FUNCTION GET_GARN_LIMIT_MAX_DURATION(PAY_EARNED_START_DATE DATE)
2876: RETURN number IS
2877: CURSOR csr_ovrd_duration IS
2878: SELECT entry_information8
2879: FROM pay_element_entries_f
2880: WHERE element_entry_id = CTX_ORIGINAL_ENTRY_ID
2881: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
2882: AND PAY_EARNED_START_DATE BETWEEN effective_start_date AND effective_end_date;
2883:

Line 2887: FROM pay_element_entries_f peef,

2883:
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

Line 3174: FROM pay_element_entries_f

3170:
3171: /*-- Cursor for Bug 3520523 --*/
3172: CURSOR csr_exmpt_ovrd(c_override_date date) is
3173: SELECT entry_information4
3174: FROM pay_element_entries_f
3175: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
3176: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
3177: AND c_override_date BETWEEN effective_start_date and effective_end_date;
3178:

Line 3183: FROM pay_element_entries_f

3179:
3180: /* Cursot to return the Initial Fee Flag value Bug 3549298 */
3181: CURSOR csr_get_ini_fee_flag is
3182: SELECT nvl(entry_information9, 'N')
3183: FROM pay_element_entries_f
3184: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
3185: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
3186: AND P_CTX_DATE_EARNED BETWEEN effective_start_date and effective_end_date;
3187:

Line 3192: pay_element_entries_f pee

3188: /*-- Cursor for Bug 2658290 --*/
3189: CURSOR csr_get_proration_ovrd is
3190: select aei.aei_information3
3191: from per_assignment_extra_info aei,
3192: pay_element_entries_f pee
3193: where aei.assignment_id = pee.assignment_id
3194: and aei.information_type = 'US_PRORATION_RULE'
3195: and aei.aei_information_category = 'US_PRORATION_RULE'
3196: and aei.aei_information2 = garn_cat

Line 3223: from pay_element_entries_f

3219:
3220: -- Bug 4556146
3221: CURSOR csr_get_entry_start_date is
3222: select min(effective_start_date)
3223: from pay_element_entries_f
3224: where element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
3225: group by element_entry_id;
3226:
3227: -- Added for Bug# 5150447

Line 3231: from pay_element_entries_f pee,

3227: -- Added for Bug# 5150447
3228: CURSOR c_get_res_state_code(p_element_entry_id in number) is
3229: select paf.assignment_id,
3230: pus.state_code
3231: from pay_element_entries_f pee,
3232: per_all_assignments_f paf,
3233: per_all_people_f ppf,
3234: per_addresses pa,
3235: pay_us_states pus

Line 3256: from pay_element_entries_f peef,

3252: and pus.state_abbrev = nvl(loc_information17,region_2) ;
3253:
3254: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
3255: select peev.screen_entry_value
3256: from pay_element_entries_f peef,
3257: pay_element_entry_values_f peev,
3258: pay_input_values_f pivf
3259: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
3260: and peev.element_entry_id = peef.element_entry_id

Line 3306: FROM pay_element_entries_f peef,

3302: -- Bug# 6133337
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

Line 3324: FROM pay_element_entries_f peef,

3320: -- Checking Element level Override
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

Line 5162: pay_element_entries_f peef,

5158: -- Cursor to fetch the Filing Status year for the person if specified
5159: CURSOR csr_get_filing_status_year is
5160: select ppei.pei_information1
5161: from per_people_extra_info ppei,
5162: pay_element_entries_f peef,
5163: per_all_assignments_f paaf
5164: where peef.element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
5165: and peef.assignment_id = paaf.assignment_id
5166: and paaf.person_id = ppei.person_id

Line 5173: from pay_element_entries_f

5169: -- Bug 3528349
5170: -- Cursor to get the start date of the element
5171: CURSOR csr_get_entry_start_date is
5172: select min(effective_start_date)
5173: from pay_element_entries_f
5174: where element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
5175: group by element_entry_id;
5176:
5177: -- 5111601

Line 5181: FROM pay_element_entries_f

5177: -- 5111601
5178: -- Cursor to Fetch whether the EE or Spouse is Blind / Age >= 65
5179: CURSOR csr_get_blind_65_flag is
5180: SELECT entry_information10
5181: FROM pay_element_entries_f
5182: WHERE element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
5183: AND entry_information_category = 'US_INVOLUNTARY DEDUCTIONS'
5184: AND P_CTX_DATE_EARNED BETWEEN effective_start_date and effective_end_date;
5185: