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_ENTRY_VALUES_F

Line 1640: elsif (p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then

1636: run_event_proc := TRUE;
1637: event_proc_res := 'TRUE';
1638: end if;
1639: --
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;

Line 1652: from pay_element_entry_values_f

1648: select ''
1649: into l_dummy
1650: from dual
1651: where exists (select ''
1652: from pay_element_entry_values_f
1653: where element_entry_id = l_ee_id
1654: and element_entry_value_id =
1655: p_surrogate_key
1656: );

Line 3259: or p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then

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:
3263: end if;

Line 3321: elsif (p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then

3317: if(l_element_entry_id = p_surrogate_key) then
3318: save_event := TRUE;
3319: end if;
3320: --
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;

Line 3333: from pay_element_entry_values_f

3329: select ''
3330: into l_dummy
3331: from dual
3332: where exists (select ''
3333: from pay_element_entry_values_f
3334: where element_entry_id = l_ee_id
3335: and element_entry_value_id = p_surrogate_key
3336: );
3337: save_event := TRUE;

Line 3419: or p_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F') then

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;
3423: perform_qualifications

Line 4544: and l_look_for_rec.table_name = 'PAY_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:
4548: ------------ START fix for BUG 3598389 --------------------------

Line 5149: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5151: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5152: and exists
5153: ( select null

Line 5151: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5147: and ppe.surrogate_key=p_element_entry_id )
5148: )
5149: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5150: or
5151: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5152: and exists
5153: ( select null
5154: from pay_element_entry_values_f
5155: where element_entry_id = p_element_entry_id

Line 5154: from pay_element_entry_values_f

5150: or
5151: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5152: and exists
5153: ( select null
5154: from pay_element_entry_values_f
5155: where element_entry_id = p_element_entry_id
5156: and element_entry_value_id =
5157: ppe.surrogate_key ) )
5158: )

Line 5208: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5210: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5211: and exists
5212: ( select null

Line 5210: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5206: and ppe.surrogate_key=p_element_entry_id )
5207: )
5208: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5209: or
5210: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5211: and exists
5212: ( select null
5213: from pay_element_entry_values_f
5214: where element_entry_id = p_element_entry_id

Line 5213: from pay_element_entry_values_f

5209: or
5210: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5211: and exists
5212: ( select null
5213: from pay_element_entry_values_f
5214: where element_entry_id = p_element_entry_id
5215: and element_entry_value_id =
5216: ppe.surrogate_key ) )
5217: )

Line 5281: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5283: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5284: and exists
5285: ( select null

Line 5283: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5279: and ppe.surrogate_key=p_element_entry_id )
5280: )
5281: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5282: or
5283: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5284: and exists
5285: ( select null
5286: from pay_element_entry_values_f
5287: where element_entry_id = p_element_entry_id

Line 5286: from pay_element_entry_values_f

5282: or
5283: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5284: and exists
5285: ( select null
5286: from pay_element_entry_values_f
5287: where element_entry_id = p_element_entry_id
5288: and element_entry_value_id =
5289: ppe.surrogate_key ) )
5290: )

Line 5341: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5343: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5344: and exists
5345: ( select null

Line 5343: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5339: and ppe.surrogate_key=p_element_entry_id )
5340: )
5341: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5342: or
5343: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5344: and exists
5345: ( select null
5346: from pay_element_entry_values_f
5347: where element_entry_id = p_element_entry_id

Line 5346: from pay_element_entry_values_f

5342: or
5343: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5344: and exists
5345: ( select null
5346: from pay_element_entry_values_f
5347: where element_entry_id = p_element_entry_id
5348: and element_entry_value_id =
5349: ppe.surrogate_key ) )
5350: )

Line 5414: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5416: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5417: and exists
5418: ( select null

Line 5416: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5412: and ppe.surrogate_key=p_element_entry_id )
5413: )
5414: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5415: or
5416: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5417: and exists
5418: ( select null
5419: from pay_element_entry_values_f
5420: where element_entry_id = p_element_entry_id

Line 5419: from pay_element_entry_values_f

5415: or
5416: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5417: and exists
5418: ( select null
5419: from pay_element_entry_values_f
5420: where element_entry_id = p_element_entry_id
5421: and element_entry_value_id =
5422: ppe.surrogate_key ) )
5423: )

Line 5503: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5505: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5506: and exists
5507: ( select null

Line 5505: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5501: and ppe.surrogate_key=p_element_entry_id )
5502: )
5503: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5504: or
5505: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5506: and exists
5507: ( select null
5508: from pay_element_entry_values_f
5509: where element_entry_id = p_element_entry_id

Line 5508: from pay_element_entry_values_f

5504: or
5505: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5506: and exists
5507: ( select null
5508: from pay_element_entry_values_f
5509: where element_entry_id = p_element_entry_id
5510: and element_entry_value_id =
5511: ppe.surrogate_key ) )
5512: )

Line 5585: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5587: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5588: and exists
5589: ( select null

Line 5587: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5583: and ppe.surrogate_key=p_element_entry_id )
5584: )
5585: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5586: or
5587: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5588: and exists
5589: ( select null
5590: from pay_element_entry_values_f
5591: where element_entry_id = p_element_entry_id

Line 5590: from pay_element_entry_values_f

5586: or
5587: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5588: and exists
5589: ( select null
5590: from pay_element_entry_values_f
5591: where element_entry_id = p_element_entry_id
5592: and element_entry_value_id =
5593: ppe.surrogate_key ) )
5594: )