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: nvl(save_event,FALSE) = FALSE and -- bug 8298970. save_event is null as it is not initialized
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 4817: from pay_element_entries_f pee

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

Line 4826: from pay_element_entries_f pee

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

Line 4848: ,pay_element_entries_f peef

4844: (
4845: SELECT '' chk
4846: FROM pay_input_values_f piv
4847: ,pay_element_links_f pelf
4848: ,pay_element_entries_f peef
4849: WHERE piv.input_value_id = p_surrogate_key
4850: AND pelf.element_type_id = piv.element_type_id
4851: AND peef.element_link_id = pelf.element_link_id
4852: AND peef.assignment_id = p_assignment_id

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

5140: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5141: AND ppe.creation_date BETWEEN cp_cstart_date AND cp_cend_date
5142: AND ( (cp_bulk_processing = 'Y')
5143: or ( cp_bulk_processing = 'N'
5144: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5145: or
5146: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5147: and ppe.surrogate_key=p_element_entry_id )
5148: )

Line 5146: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5142: AND ( (cp_bulk_processing = 'Y')
5143: or ( cp_bulk_processing = 'N'
5144: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5145: or
5146: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5147: and ppe.surrogate_key=p_element_entry_id )
5148: )
5149: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5150: or

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

5199: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5200: AND ppe.creation_date BETWEEN cp_cstart_date AND cp_cend_date
5201: AND ( (cp_bulk_processing = 'Y')
5202: or ( cp_bulk_processing = 'N'
5203: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5204: or
5205: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5206: and ppe.surrogate_key=p_element_entry_id )
5207: )

Line 5205: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5201: AND ( (cp_bulk_processing = 'Y')
5202: or ( cp_bulk_processing = 'N'
5203: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5204: or
5205: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5206: and ppe.surrogate_key=p_element_entry_id )
5207: )
5208: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5209: or

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

5272: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5273: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5274: AND ( (cp_bulk_processing = 'Y')
5275: or ( cp_bulk_processing = 'N'
5276: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5277: or
5278: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5279: and ppe.surrogate_key=p_element_entry_id )
5280: )

Line 5278: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5274: AND ( (cp_bulk_processing = 'Y')
5275: or ( cp_bulk_processing = 'N'
5276: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5277: or
5278: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5279: and ppe.surrogate_key=p_element_entry_id )
5280: )
5281: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5282: or

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

5332: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5333: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5334: AND ( (cp_bulk_processing = 'Y')
5335: or ( cp_bulk_processing = 'N'
5336: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5337: or
5338: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5339: and ppe.surrogate_key=p_element_entry_id )
5340: )

Line 5338: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5334: AND ( (cp_bulk_processing = 'Y')
5335: or ( cp_bulk_processing = 'N'
5336: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5337: or
5338: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5339: and ppe.surrogate_key=p_element_entry_id )
5340: )
5341: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5342: or

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

5405: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5406: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5407: AND ( (cp_bulk_processing = 'Y')
5408: or ( cp_bulk_processing = 'N'
5409: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5410: or
5411: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5412: and ppe.surrogate_key=p_element_entry_id )
5413: )

Line 5411: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5407: AND ( (cp_bulk_processing = 'Y')
5408: or ( cp_bulk_processing = 'N'
5409: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5410: or
5411: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5412: and ppe.surrogate_key=p_element_entry_id )
5413: )
5414: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5415: or

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

5494: AND ppe.change_type = nvl(p_mode,ppe.change_type)
5495: AND ppe.effective_date BETWEEN cp_estart_date AND cp_eend_date
5496: AND ( (cp_bulk_processing = 'Y')
5497: or ( cp_bulk_processing = 'N'
5498: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5499: or
5500: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5501: and ppe.surrogate_key=p_element_entry_id )
5502: )

Line 5500: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5496: AND ( (cp_bulk_processing = 'Y')
5497: or ( cp_bulk_processing = 'N'
5498: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5499: or
5500: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5501: and ppe.surrogate_key=p_element_entry_id )
5502: )
5503: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5504: or

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

5576: AND ( ppe.effective_date > nvl(cp_last_approved_date, hr_api.g_sot) or ppe.creation_date > nvl(cp_last_approved_date, hr_api.g_sot)) -- Bug 10092118
5577: -- Bug fix 12363861 End
5578: AND ( (cp_bulk_processing = 'Y')
5579: or ( cp_bulk_processing = 'N'
5580: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5581: or
5582: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5583: and ppe.surrogate_key=p_element_entry_id )
5584: )

Line 5582: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

5578: AND ( (cp_bulk_processing = 'Y')
5579: or ( cp_bulk_processing = 'N'
5580: AND ( (pdt.table_name <> 'PAY_ELEMENT_ENTRIES_F' )
5581: or
5582: ( pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
5583: and ppe.surrogate_key=p_element_entry_id )
5584: )
5585: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5586: or

Line 6267: pay_element_entries_f ee

6263:
6264: cursor csr_dflt_grps (cp_ee_id in number, cp_report_date in date ) IS
6265: select distinct(et.recalc_event_group_id) recalc_event_group_id
6266: from
6267: pay_element_entries_f ee
6268: ,pay_element_links_f el
6269: ,pay_element_types_f et
6270: where ee.element_entry_id = nvl(cp_ee_id,-1)
6271: and ee.element_link_id = el.element_link_id