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_INTERPRETER_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 317: FROM pay_element_entries_f

313: -- The following cursor selects the start and end date of the element entry id.
314: CURSOR c_element_start_end IS
315: SELECT MIN(effective_start_date) esd,
316: MAX(effective_end_date) eed
317: FROM pay_element_entries_f
318: WHERE element_entry_id = p_element_entry_id;
319: --
320: BEGIN
321: --

Line 560: FROM pay_element_entries_f pee,

556:
557: SELECT DISTINCT pee.assignment_id ,
558: pet.proration_group_id
559: into p_assignment_id,p_event_group_id
560: FROM pay_element_entries_f pee,
561: pay_element_types_f pet
562: WHERE pee.element_entry_id = p_element_entry_id
563: AND pee.element_type_id = pet.element_type_id
564: AND pee.effective_start_date <= l_date_earned

Line 1631: if (p_table_name = 'PAY_ELEMENT_ENTRIES_F') then

1627: --
1628: -- Need to decide if the event is relevent to the current entry
1629: --
1630: process_event := FALSE;
1631: if (p_table_name = 'PAY_ELEMENT_ENTRIES_F') then
1632: --
1633: if (glo_datetrack_ee_tab(curr_ptr).element_entry_id
1634: = p_surrogate_key) then
1635: process_event := TRUE;

Line 1644: l_ee_id pay_element_entries_f.element_entry_id%type;

1640: elsif (p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then
1641: --
1642: declare
1643: l_dummy varchar2(2);
1644: l_ee_id pay_element_entries_f.element_entry_id%type;
1645: begin
1646: l_ee_id :=
1647: glo_datetrack_ee_tab(curr_ptr).element_entry_id;
1648: select ''

Line 2052: from pay_element_entries_f

2048: select min(effective_start_date),
2049: max(effective_end_date)
2050: into l_ee_min_date,
2051: l_ee_max_date
2052: from pay_element_entries_f
2053: where element_entry_id = p_element_entry_id;
2054: --
2055: hr_utility.trace('td id '|| p_time_definition_id );
2056: hr_utility.trace('asg act id '|| p_assignment_action_id );

Line 3258: if ( p_table_name = 'PAY_ELEMENT_ENTRIES_F'

3254:
3255: /* If its element entries don't run the procedure
3256: validation, assume it's qualified
3257: */
3258: if ( p_table_name = 'PAY_ELEMENT_ENTRIES_F'
3259: or p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then
3260: run_event_proc := FALSE;
3261: event_proc_res := 'TRUE';
3262:

Line 3315: if (p_table_name = 'PAY_ELEMENT_ENTRIES_F') then

3311:
3312: -- Need to decide if the event is relevent to the current entry
3313: --
3314: save_event := FALSE;
3315: if (p_table_name = 'PAY_ELEMENT_ENTRIES_F') then
3316: --
3317: if(l_element_entry_id = p_surrogate_key) then
3318: save_event := TRUE;
3319: end if;

Line 3325: l_ee_id pay_element_entries_f.element_entry_id%type;

3321: elsif (p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then
3322: --
3323: declare
3324: l_dummy varchar2(2);
3325: l_ee_id pay_element_entries_f.element_entry_id%type;
3326: begin
3327: l_ee_id :=
3328: l_element_entry_id;
3329: select ''

Line 3354: p_table_name = 'PAY_ELEMENT_ENTRIES_F' and

3350: curr_ptr := glo_datetrack_ee_tab(curr_ptr).next_ptr;
3351:
3352: if( curr_ptr IS NULL AND
3353: save_event = FALSE and
3354: p_table_name = 'PAY_ELEMENT_ENTRIES_F' and
3355: l_update_type = 'P' and
3356: p_penserv_mode = 'N' ) THEN /*Bug 7409433 Added condition p_penserv_mode ='N' */
3357:
3358: save_event := TRUE;

Line 3418: if ( p_table_name = 'PAY_ELEMENT_ENTRIES_F'

3414:
3415: /* If its element entries don't run the procedure
3416: validation, assume it's qualified
3417: */
3418: if ( p_table_name = 'PAY_ELEMENT_ENTRIES_F'
3419: or p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then
3420: run_event_proc := FALSE;
3421: event_proc_res := 'TRUE';
3422: end if;

Line 4543: or ( p_mst_pe_rec.table_name = 'PAY_ELEMENT_ENTRIES_F'

4539: -- (or our one exception of element entries and element_entry_values_f)
4540: -- if not then dont do any more processing, get next p_mst_pe_rec
4541: --
4542: IF (p_mst_pe_rec.table_name = l_look_for_rec.table_name
4543: or ( p_mst_pe_rec.table_name = 'PAY_ELEMENT_ENTRIES_F'
4544: and l_look_for_rec.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') )
4545: then
4546:
4547:

Line 4815: from pay_element_entries_f pee

4811: select '' chk
4812: from dual
4813: where exists (
4814: select '' chk
4815: from pay_element_entries_f pee
4816: ,pqh_criteria_rate_elements pcre
4817: ,pqh_rate_matrix_rates_f prmr
4818: where pee.assignment_id=p_assignment_id
4819: and pcre.element_type_id=pee.element_type_id

Line 4824: from pay_element_entries_f pee

4820: and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id
4821: and prmr.rate_matrix_rate_id=p_surrogate_key)
4822: or exists (
4823: select '' chk
4824: from pay_element_entries_f pee
4825: ,pqh_criteria_rate_elements pcre
4826: ,pqh_criteria_rate_factors pcrf
4827: ,pqh_rate_matrix_rates_f prmr
4828: where pee.assignment_id=p_assignment_id

Line 5000: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

4996: AND ppe.change_type = nvl(p_mode,ppe.change_type)
4997: AND ppe.creation_date BETWEEN cp_cstart_date AND cp_cend_date
4998: AND ( (cp_bulk_processing = 'Y')
4999: or ( cp_bulk_processing = 'N'
5000: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5001: or
5002: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5003: and ppe.surrogate_key=p_element_entry_id )
5004: )

Line 5002: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

4998: AND ( (cp_bulk_processing = 'Y')
4999: or ( cp_bulk_processing = 'N'
5000: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5001: or
5002: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5003: and ppe.surrogate_key=p_element_entry_id )
5004: )
5005: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5006: or

Line 5058: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

5054: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5055: AND ppe.creation_date BETWEEN cp_cstart_date AND cp_cend_date
5056: AND ( (cp_bulk_processing = 'Y')
5057: or ( cp_bulk_processing = 'N'
5058: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5059: or
5060: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5061: and ppe.surrogate_key=p_element_entry_id )
5062: )

Line 5060: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5056: AND ( (cp_bulk_processing = 'Y')
5057: or ( cp_bulk_processing = 'N'
5058: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5059: or
5060: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5061: and ppe.surrogate_key=p_element_entry_id )
5062: )
5063: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5064: or

Line 5131: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

5127: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5128: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5129: AND ( (cp_bulk_processing = 'Y')
5130: or ( cp_bulk_processing = 'N'
5131: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5132: or
5133: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5134: and ppe.surrogate_key=p_element_entry_id )
5135: )

Line 5133: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5129: AND ( (cp_bulk_processing = 'Y')
5130: or ( cp_bulk_processing = 'N'
5131: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5132: or
5133: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5134: and ppe.surrogate_key=p_element_entry_id )
5135: )
5136: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5137: or

Line 5191: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

5187: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5188: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5189: AND ( (cp_bulk_processing = 'Y')
5190: or ( cp_bulk_processing = 'N'
5191: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5192: or
5193: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5194: and ppe.surrogate_key=p_element_entry_id )
5195: )

Line 5193: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5189: AND ( (cp_bulk_processing = 'Y')
5190: or ( cp_bulk_processing = 'N'
5191: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5192: or
5193: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5194: and ppe.surrogate_key=p_element_entry_id )
5195: )
5196: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5197: or

Line 5264: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

5260: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5261: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5262: AND ( (cp_bulk_processing = 'Y')
5263: or ( cp_bulk_processing = 'N'
5264: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5265: or
5266: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5267: and ppe.surrogate_key=p_element_entry_id )
5268: )

Line 5266: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5262: AND ( (cp_bulk_processing = 'Y')
5263: or ( cp_bulk_processing = 'N'
5264: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5265: or
5266: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5267: and ppe.surrogate_key=p_element_entry_id )
5268: )
5269: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5270: or

Line 5351: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )

5347: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5348: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5349: AND ( (cp_bulk_processing = 'Y')
5350: or ( cp_bulk_processing = 'N'
5351: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5352: or
5353: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5354: and ppe.surrogate_key=p_element_entry_id )
5355: )

Line 5353: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5349: AND ( (cp_bulk_processing = 'Y')
5350: or ( cp_bulk_processing = 'N'
5351: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5352: or
5353: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5354: and ppe.surrogate_key=p_element_entry_id )
5355: )
5356: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5357: or

Line 5918: pay_element_entries_f ee

5914:
5915: cursor csr_dflt_grps (cp_ee_id in number, cp_report_date in date ) IS
5916: select distinct(et.recalc_event_group_id) recalc_event_group_id
5917: from
5918: pay_element_entries_f ee
5919: ,pay_element_links_f el
5920: ,pay_element_types_f et
5921: where ee.element_entry_id = nvl(cp_ee_id,-1)
5922: and ee.element_link_id = el.element_link_id