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 5005: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5007: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5008: and exists
5009: ( select null

Line 5007: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5003: and ppe.surrogate_key=p_element_entry_id )
5004: )
5005: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5006: or
5007: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5008: and exists
5009: ( select null
5010: from pay_element_entry_values_f
5011: where element_entry_id = p_element_entry_id

Line 5010: from pay_element_entry_values_f

5006: or
5007: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5008: and exists
5009: ( select null
5010: from pay_element_entry_values_f
5011: where element_entry_id = p_element_entry_id
5012: and element_entry_value_id =
5013: ppe.surrogate_key ) )
5014: )

Line 5063: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5065: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5066: and exists
5067: ( select null

Line 5065: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5061: and ppe.surrogate_key=p_element_entry_id )
5062: )
5063: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5064: or
5065: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5066: and exists
5067: ( select null
5068: from pay_element_entry_values_f
5069: where element_entry_id = p_element_entry_id

Line 5068: from pay_element_entry_values_f

5064: or
5065: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5066: and exists
5067: ( select null
5068: from pay_element_entry_values_f
5069: where element_entry_id = p_element_entry_id
5070: and element_entry_value_id =
5071: ppe.surrogate_key ) )
5072: )

Line 5136: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5138: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5139: and exists
5140: ( select null

Line 5138: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5134: and ppe.surrogate_key=p_element_entry_id )
5135: )
5136: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5137: or
5138: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5139: and exists
5140: ( select null
5141: from pay_element_entry_values_f
5142: where element_entry_id = p_element_entry_id

Line 5141: from pay_element_entry_values_f

5137: or
5138: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5139: and exists
5140: ( select null
5141: from pay_element_entry_values_f
5142: where element_entry_id = p_element_entry_id
5143: and element_entry_value_id =
5144: ppe.surrogate_key ) )
5145: )

Line 5196: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5198: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5199: and exists
5200: ( select null

Line 5198: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5194: and ppe.surrogate_key=p_element_entry_id )
5195: )
5196: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5197: or
5198: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5199: and exists
5200: ( select null
5201: from pay_element_entry_values_f
5202: where element_entry_id = p_element_entry_id

Line 5201: from pay_element_entry_values_f

5197: or
5198: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5199: and exists
5200: ( select null
5201: from pay_element_entry_values_f
5202: where element_entry_id = p_element_entry_id
5203: and element_entry_value_id =
5204: ppe.surrogate_key ) )
5205: )

Line 5269: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5271: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5272: and exists
5273: ( select null

Line 5271: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5267: and ppe.surrogate_key=p_element_entry_id )
5268: )
5269: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5270: or
5271: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5272: and exists
5273: ( select null
5274: from pay_element_entry_values_f
5275: where element_entry_id = p_element_entry_id

Line 5274: from pay_element_entry_values_f

5270: or
5271: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5272: and exists
5273: ( select null
5274: from pay_element_entry_values_f
5275: where element_entry_id = p_element_entry_id
5276: and element_entry_value_id =
5277: ppe.surrogate_key ) )
5278: )

Line 5356: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_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
5358: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5359: and exists
5360: ( select null

Line 5358: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

5354: and ppe.surrogate_key=p_element_entry_id )
5355: )
5356: AND ( ( pdt.table_name <> 'PAY_ELEMENT_ENTRY_VALUES_F' )
5357: or
5358: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5359: and exists
5360: ( select null
5361: from pay_element_entry_values_f
5362: where element_entry_id = p_element_entry_id

Line 5361: from pay_element_entry_values_f

5357: or
5358: ( pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
5359: and exists
5360: ( select null
5361: from pay_element_entry_values_f
5362: where element_entry_id = p_element_entry_id
5363: and element_entry_value_id =
5364: ppe.surrogate_key ) )
5365: )