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_CONTINUOUS_CALC dependencies on PAY_ELEMENT_TYPES_F

Line 5004: /* name : PAY_ELEMENT_TYPES_F_aru

5000: --
5001: /* Used generator to build this procedure, but removed some of that table values.
5002: */
5003: /* PAY_ELEMENT_TYEPS_F */
5004: /* name : PAY_ELEMENT_TYPES_F_aru
5005: purpose : This is procedure that records any updates
5006: on element_types.
5007: */
5008: procedure PAY_ELEMENT_TYPES_F_aru(

Line 5008: procedure PAY_ELEMENT_TYPES_F_aru(

5004: /* name : PAY_ELEMENT_TYPES_F_aru
5005: purpose : This is procedure that records any updates
5006: on element_types.
5007: */
5008: procedure PAY_ELEMENT_TYPES_F_aru(
5009: p_business_group_id in number,
5010: p_legislation_code in varchar2,
5011: p_effective_date in date,
5012: p_old_ATTRIBUTE1 in VARCHAR2,

Line 5120: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 10);

5116: )
5117: is
5118: --
5119: begin
5120: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 10);
5121: /* If the continuous calc is overriden then do nothing */
5122: if (g_override_cc = TRUE) then
5123: return;
5124: end if;

Line 5132: 'PAY_ELEMENT_TYPES_F',

5128: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
5129: --
5130: pay_continuous_calc.event_update(p_business_group_id,
5131: p_legislation_code,
5132: 'PAY_ELEMENT_TYPES_F',
5133: 'ATTRIBUTE1',
5134: p_old_ATTRIBUTE1,
5135: p_new_ATTRIBUTE1,
5136: p_effective_date

Line 5140: 'PAY_ELEMENT_TYPES_F',

5136: p_effective_date
5137: );
5138: pay_continuous_calc.event_update(p_business_group_id,
5139: p_legislation_code,
5140: 'PAY_ELEMENT_TYPES_F',
5141: 'ATTRIBUTE10',
5142: p_old_ATTRIBUTE10,
5143: p_new_ATTRIBUTE10,
5144: p_effective_date

Line 5148: 'PAY_ELEMENT_TYPES_F',

5144: p_effective_date
5145: );
5146: pay_continuous_calc.event_update(p_business_group_id,
5147: p_legislation_code,
5148: 'PAY_ELEMENT_TYPES_F',
5149: 'ATTRIBUTE11',
5150: p_old_ATTRIBUTE11,
5151: p_new_ATTRIBUTE11,
5152: p_effective_date

Line 5156: 'PAY_ELEMENT_TYPES_F',

5152: p_effective_date
5153: );
5154: pay_continuous_calc.event_update(p_business_group_id,
5155: p_legislation_code,
5156: 'PAY_ELEMENT_TYPES_F',
5157: 'ATTRIBUTE12',
5158: p_old_ATTRIBUTE12,
5159: p_new_ATTRIBUTE12,
5160: p_effective_date

Line 5164: 'PAY_ELEMENT_TYPES_F',

5160: p_effective_date
5161: );
5162: pay_continuous_calc.event_update(p_business_group_id,
5163: p_legislation_code,
5164: 'PAY_ELEMENT_TYPES_F',
5165: 'ATTRIBUTE13',
5166: p_old_ATTRIBUTE13,
5167: p_new_ATTRIBUTE13,
5168: p_effective_date

Line 5172: 'PAY_ELEMENT_TYPES_F',

5168: p_effective_date
5169: );
5170: pay_continuous_calc.event_update(p_business_group_id,
5171: p_legislation_code,
5172: 'PAY_ELEMENT_TYPES_F',
5173: 'ATTRIBUTE14',
5174: p_old_ATTRIBUTE14,
5175: p_new_ATTRIBUTE14,
5176: p_effective_date

Line 5180: 'PAY_ELEMENT_TYPES_F',

5176: p_effective_date
5177: );
5178: pay_continuous_calc.event_update(p_business_group_id,
5179: p_legislation_code,
5180: 'PAY_ELEMENT_TYPES_F',
5181: 'ATTRIBUTE15',
5182: p_old_ATTRIBUTE15,
5183: p_new_ATTRIBUTE15,
5184: p_effective_date

Line 5188: 'PAY_ELEMENT_TYPES_F',

5184: p_effective_date
5185: );
5186: pay_continuous_calc.event_update(p_business_group_id,
5187: p_legislation_code,
5188: 'PAY_ELEMENT_TYPES_F',
5189: 'ATTRIBUTE16',
5190: p_old_ATTRIBUTE16,
5191: p_new_ATTRIBUTE16,
5192: p_effective_date

Line 5196: 'PAY_ELEMENT_TYPES_F',

5192: p_effective_date
5193: );
5194: pay_continuous_calc.event_update(p_business_group_id,
5195: p_legislation_code,
5196: 'PAY_ELEMENT_TYPES_F',
5197: 'ATTRIBUTE17',
5198: p_old_ATTRIBUTE17,
5199: p_new_ATTRIBUTE17,
5200: p_effective_date

Line 5204: 'PAY_ELEMENT_TYPES_F',

5200: p_effective_date
5201: );
5202: pay_continuous_calc.event_update(p_business_group_id,
5203: p_legislation_code,
5204: 'PAY_ELEMENT_TYPES_F',
5205: 'ATTRIBUTE18',
5206: p_old_ATTRIBUTE18,
5207: p_new_ATTRIBUTE18,
5208: p_effective_date

Line 5212: 'PAY_ELEMENT_TYPES_F',

5208: p_effective_date
5209: );
5210: pay_continuous_calc.event_update(p_business_group_id,
5211: p_legislation_code,
5212: 'PAY_ELEMENT_TYPES_F',
5213: 'ATTRIBUTE19',
5214: p_old_ATTRIBUTE19,
5215: p_new_ATTRIBUTE19,
5216: p_effective_date

Line 5220: 'PAY_ELEMENT_TYPES_F',

5216: p_effective_date
5217: );
5218: pay_continuous_calc.event_update(p_business_group_id,
5219: p_legislation_code,
5220: 'PAY_ELEMENT_TYPES_F',
5221: 'ATTRIBUTE2',
5222: p_old_ATTRIBUTE2,
5223: p_new_ATTRIBUTE2,
5224: p_effective_date

Line 5228: 'PAY_ELEMENT_TYPES_F',

5224: p_effective_date
5225: );
5226: pay_continuous_calc.event_update(p_business_group_id,
5227: p_legislation_code,
5228: 'PAY_ELEMENT_TYPES_F',
5229: 'ATTRIBUTE20',
5230: p_old_ATTRIBUTE20,
5231: p_new_ATTRIBUTE20,
5232: p_effective_date

Line 5236: 'PAY_ELEMENT_TYPES_F',

5232: p_effective_date
5233: );
5234: pay_continuous_calc.event_update(p_business_group_id,
5235: p_legislation_code,
5236: 'PAY_ELEMENT_TYPES_F',
5237: 'ATTRIBUTE3',
5238: p_old_ATTRIBUTE3,
5239: p_new_ATTRIBUTE3,
5240: p_effective_date

Line 5244: 'PAY_ELEMENT_TYPES_F',

5240: p_effective_date
5241: );
5242: pay_continuous_calc.event_update(p_business_group_id,
5243: p_legislation_code,
5244: 'PAY_ELEMENT_TYPES_F',
5245: 'ATTRIBUTE4',
5246: p_old_ATTRIBUTE4,
5247: p_new_ATTRIBUTE4,
5248: p_effective_date

Line 5252: 'PAY_ELEMENT_TYPES_F',

5248: p_effective_date
5249: );
5250: pay_continuous_calc.event_update(p_business_group_id,
5251: p_legislation_code,
5252: 'PAY_ELEMENT_TYPES_F',
5253: 'ATTRIBUTE5',
5254: p_old_ATTRIBUTE5,
5255: p_new_ATTRIBUTE5,
5256: p_effective_date

Line 5260: 'PAY_ELEMENT_TYPES_F',

5256: p_effective_date
5257: );
5258: pay_continuous_calc.event_update(p_business_group_id,
5259: p_legislation_code,
5260: 'PAY_ELEMENT_TYPES_F',
5261: 'ATTRIBUTE6',
5262: p_old_ATTRIBUTE6,
5263: p_new_ATTRIBUTE6,
5264: p_effective_date

Line 5268: 'PAY_ELEMENT_TYPES_F',

5264: p_effective_date
5265: );
5266: pay_continuous_calc.event_update(p_business_group_id,
5267: p_legislation_code,
5268: 'PAY_ELEMENT_TYPES_F',
5269: 'ATTRIBUTE7',
5270: p_old_ATTRIBUTE7,
5271: p_new_ATTRIBUTE7,
5272: p_effective_date

Line 5276: 'PAY_ELEMENT_TYPES_F',

5272: p_effective_date
5273: );
5274: pay_continuous_calc.event_update(p_business_group_id,
5275: p_legislation_code,
5276: 'PAY_ELEMENT_TYPES_F',
5277: 'ATTRIBUTE8',
5278: p_old_ATTRIBUTE8,
5279: p_new_ATTRIBUTE8,
5280: p_effective_date

Line 5284: 'PAY_ELEMENT_TYPES_F',

5280: p_effective_date
5281: );
5282: pay_continuous_calc.event_update(p_business_group_id,
5283: p_legislation_code,
5284: 'PAY_ELEMENT_TYPES_F',
5285: 'ATTRIBUTE9',
5286: p_old_ATTRIBUTE9,
5287: p_new_ATTRIBUTE9,
5288: p_effective_date

Line 5292: 'PAY_ELEMENT_TYPES_F',

5288: p_effective_date
5289: );
5290: pay_continuous_calc.event_update(p_business_group_id,
5291: p_legislation_code,
5292: 'PAY_ELEMENT_TYPES_F',
5293: 'ATTRIBUTE_CATEGORY',
5294: p_old_ATTRIBUTE_CATEGORY,
5295: p_new_ATTRIBUTE_CATEGORY,
5296: p_effective_date

Line 5300: 'PAY_ELEMENT_TYPES_F',

5296: p_effective_date
5297: );
5298: pay_continuous_calc.event_update(p_business_group_id,
5299: p_legislation_code,
5300: 'PAY_ELEMENT_TYPES_F',
5301: 'ELEMENT_INFORMATION1',
5302: p_old_ELEMENT_INFORMATION1,
5303: p_new_ELEMENT_INFORMATION1,
5304: p_effective_date

Line 5308: 'PAY_ELEMENT_TYPES_F',

5304: p_effective_date
5305: );
5306: pay_continuous_calc.event_update(p_business_group_id,
5307: p_legislation_code,
5308: 'PAY_ELEMENT_TYPES_F',
5309: 'ELEMENT_INFORMATION10',
5310: p_old_ELEMENT_INFORMATION10,
5311: p_new_ELEMENT_INFORMATION10,
5312: p_effective_date

Line 5316: 'PAY_ELEMENT_TYPES_F',

5312: p_effective_date
5313: );
5314: pay_continuous_calc.event_update(p_business_group_id,
5315: p_legislation_code,
5316: 'PAY_ELEMENT_TYPES_F',
5317: 'ELEMENT_INFORMATION11',
5318: p_old_ELEMENT_INFORMATION11,
5319: p_new_ELEMENT_INFORMATION11,
5320: p_effective_date

Line 5324: 'PAY_ELEMENT_TYPES_F',

5320: p_effective_date
5321: );
5322: pay_continuous_calc.event_update(p_business_group_id,
5323: p_legislation_code,
5324: 'PAY_ELEMENT_TYPES_F',
5325: 'ELEMENT_INFORMATION12',
5326: p_old_ELEMENT_INFORMATION12,
5327: p_new_ELEMENT_INFORMATION12,
5328: p_effective_date

Line 5332: 'PAY_ELEMENT_TYPES_F',

5328: p_effective_date
5329: );
5330: pay_continuous_calc.event_update(p_business_group_id,
5331: p_legislation_code,
5332: 'PAY_ELEMENT_TYPES_F',
5333: 'ELEMENT_INFORMATION13',
5334: p_old_ELEMENT_INFORMATION13,
5335: p_new_ELEMENT_INFORMATION13,
5336: p_effective_date

Line 5340: 'PAY_ELEMENT_TYPES_F',

5336: p_effective_date
5337: );
5338: pay_continuous_calc.event_update(p_business_group_id,
5339: p_legislation_code,
5340: 'PAY_ELEMENT_TYPES_F',
5341: 'ELEMENT_INFORMATION14',
5342: p_old_ELEMENT_INFORMATION14,
5343: p_new_ELEMENT_INFORMATION14,
5344: p_effective_date

Line 5348: 'PAY_ELEMENT_TYPES_F',

5344: p_effective_date
5345: );
5346: pay_continuous_calc.event_update(p_business_group_id,
5347: p_legislation_code,
5348: 'PAY_ELEMENT_TYPES_F',
5349: 'ELEMENT_INFORMATION15',
5350: p_old_ELEMENT_INFORMATION15,
5351: p_new_ELEMENT_INFORMATION15,
5352: p_effective_date

Line 5356: 'PAY_ELEMENT_TYPES_F',

5352: p_effective_date
5353: );
5354: pay_continuous_calc.event_update(p_business_group_id,
5355: p_legislation_code,
5356: 'PAY_ELEMENT_TYPES_F',
5357: 'ELEMENT_INFORMATION16',
5358: p_old_ELEMENT_INFORMATION16,
5359: p_new_ELEMENT_INFORMATION16,
5360: p_effective_date

Line 5364: 'PAY_ELEMENT_TYPES_F',

5360: p_effective_date
5361: );
5362: pay_continuous_calc.event_update(p_business_group_id,
5363: p_legislation_code,
5364: 'PAY_ELEMENT_TYPES_F',
5365: 'ELEMENT_INFORMATION17',
5366: p_old_ELEMENT_INFORMATION17,
5367: p_new_ELEMENT_INFORMATION17,
5368: p_effective_date

Line 5372: 'PAY_ELEMENT_TYPES_F',

5368: p_effective_date
5369: );
5370: pay_continuous_calc.event_update(p_business_group_id,
5371: p_legislation_code,
5372: 'PAY_ELEMENT_TYPES_F',
5373: 'ELEMENT_INFORMATION18',
5374: p_old_ELEMENT_INFORMATION18,
5375: p_new_ELEMENT_INFORMATION18,
5376: p_effective_date

Line 5380: 'PAY_ELEMENT_TYPES_F',

5376: p_effective_date
5377: );
5378: pay_continuous_calc.event_update(p_business_group_id,
5379: p_legislation_code,
5380: 'PAY_ELEMENT_TYPES_F',
5381: 'ELEMENT_INFORMATION19',
5382: p_old_ELEMENT_INFORMATION19,
5383: p_new_ELEMENT_INFORMATION19,
5384: p_effective_date

Line 5388: 'PAY_ELEMENT_TYPES_F',

5384: p_effective_date
5385: );
5386: pay_continuous_calc.event_update(p_business_group_id,
5387: p_legislation_code,
5388: 'PAY_ELEMENT_TYPES_F',
5389: 'ELEMENT_INFORMATION2',
5390: p_old_ELEMENT_INFORMATION2,
5391: p_new_ELEMENT_INFORMATION2,
5392: p_effective_date

Line 5396: 'PAY_ELEMENT_TYPES_F',

5392: p_effective_date
5393: );
5394: pay_continuous_calc.event_update(p_business_group_id,
5395: p_legislation_code,
5396: 'PAY_ELEMENT_TYPES_F',
5397: 'ELEMENT_INFORMATION20',
5398: p_old_ELEMENT_INFORMATION20,
5399: p_new_ELEMENT_INFORMATION20,
5400: p_effective_date

Line 5404: 'PAY_ELEMENT_TYPES_F',

5400: p_effective_date
5401: );
5402: pay_continuous_calc.event_update(p_business_group_id,
5403: p_legislation_code,
5404: 'PAY_ELEMENT_TYPES_F',
5405: 'ELEMENT_INFORMATION3',
5406: p_old_ELEMENT_INFORMATION3,
5407: p_new_ELEMENT_INFORMATION3,
5408: p_effective_date

Line 5412: 'PAY_ELEMENT_TYPES_F',

5408: p_effective_date
5409: );
5410: pay_continuous_calc.event_update(p_business_group_id,
5411: p_legislation_code,
5412: 'PAY_ELEMENT_TYPES_F',
5413: 'ELEMENT_INFORMATION4',
5414: p_old_ELEMENT_INFORMATION4,
5415: p_new_ELEMENT_INFORMATION4,
5416: p_effective_date

Line 5420: 'PAY_ELEMENT_TYPES_F',

5416: p_effective_date
5417: );
5418: pay_continuous_calc.event_update(p_business_group_id,
5419: p_legislation_code,
5420: 'PAY_ELEMENT_TYPES_F',
5421: 'ELEMENT_INFORMATION5',
5422: p_old_ELEMENT_INFORMATION5,
5423: p_new_ELEMENT_INFORMATION5,
5424: p_effective_date

Line 5428: 'PAY_ELEMENT_TYPES_F',

5424: p_effective_date
5425: );
5426: pay_continuous_calc.event_update(p_business_group_id,
5427: p_legislation_code,
5428: 'PAY_ELEMENT_TYPES_F',
5429: 'ELEMENT_INFORMATION6',
5430: p_old_ELEMENT_INFORMATION6,
5431: p_new_ELEMENT_INFORMATION6,
5432: p_effective_date

Line 5436: 'PAY_ELEMENT_TYPES_F',

5432: p_effective_date
5433: );
5434: pay_continuous_calc.event_update(p_business_group_id,
5435: p_legislation_code,
5436: 'PAY_ELEMENT_TYPES_F',
5437: 'ELEMENT_INFORMATION7',
5438: p_old_ELEMENT_INFORMATION7,
5439: p_new_ELEMENT_INFORMATION7,
5440: p_effective_date

Line 5444: 'PAY_ELEMENT_TYPES_F',

5440: p_effective_date
5441: );
5442: pay_continuous_calc.event_update(p_business_group_id,
5443: p_legislation_code,
5444: 'PAY_ELEMENT_TYPES_F',
5445: 'ELEMENT_INFORMATION8',
5446: p_old_ELEMENT_INFORMATION8,
5447: p_new_ELEMENT_INFORMATION8,
5448: p_effective_date

Line 5452: 'PAY_ELEMENT_TYPES_F',

5448: p_effective_date
5449: );
5450: pay_continuous_calc.event_update(p_business_group_id,
5451: p_legislation_code,
5452: 'PAY_ELEMENT_TYPES_F',
5453: 'ELEMENT_INFORMATION9',
5454: p_old_ELEMENT_INFORMATION9,
5455: p_new_ELEMENT_INFORMATION9,
5456: p_effective_date

Line 5460: 'PAY_ELEMENT_TYPES_F',

5456: p_effective_date
5457: );
5458: pay_continuous_calc.event_update(p_business_group_id,
5459: p_legislation_code,
5460: 'PAY_ELEMENT_TYPES_F',
5461: 'ELEMENT_INFORMATION_CATEGORY',
5462: p_old_ELEMENT_INFORMATION_CATE,
5463: p_new_ELEMENT_INFORMATION_CATE,
5464: p_effective_date

Line 5468: 'PAY_ELEMENT_TYPES_F',

5464: p_effective_date
5465: );
5466: pay_continuous_calc.event_update(p_business_group_id,
5467: p_legislation_code,
5468: 'PAY_ELEMENT_TYPES_F',
5469: 'GROSSUP_FLAG',
5470: p_old_GROSSUP_FLAG,
5471: p_new_GROSSUP_FLAG,
5472: p_effective_date

Line 5476: 'PAY_ELEMENT_TYPES_F',

5472: p_effective_date
5473: );
5474: pay_continuous_calc.event_update(p_business_group_id,
5475: p_legislation_code,
5476: 'PAY_ELEMENT_TYPES_F',
5477: 'ITERATIVE_FLAG',
5478: p_old_ITERATIVE_FLAG,
5479: p_new_ITERATIVE_FLAG,
5480: p_effective_date

Line 5484: 'PAY_ELEMENT_TYPES_F',

5480: p_effective_date
5481: );
5482: pay_continuous_calc.event_update(p_business_group_id,
5483: p_legislation_code,
5484: 'PAY_ELEMENT_TYPES_F',
5485: 'ITERATIVE_FORMULA_ID',
5486: p_old_ITERATIVE_FORMULA_ID,
5487: p_new_ITERATIVE_FORMULA_ID,
5488: p_effective_date

Line 5492: 'PAY_ELEMENT_TYPES_F',

5488: p_effective_date
5489: );
5490: pay_continuous_calc.event_update(p_business_group_id,
5491: p_legislation_code,
5492: 'PAY_ELEMENT_TYPES_F',
5493: 'ITERATIVE_PRIORITY',
5494: p_old_ITERATIVE_PRIORITY,
5495: p_new_ITERATIVE_PRIORITY,
5496: p_effective_date

Line 5500: 'PAY_ELEMENT_TYPES_F',

5496: p_effective_date
5497: );
5498: pay_continuous_calc.event_update(p_business_group_id,
5499: p_legislation_code,
5500: 'PAY_ELEMENT_TYPES_F',
5501: 'POST_TERMINATION_RULE',
5502: p_old_POST_TERMINATION_RULE,
5503: p_new_POST_TERMINATION_RULE,
5504: p_effective_date

Line 5508: 'PAY_ELEMENT_TYPES_F',

5504: p_effective_date
5505: );
5506: pay_continuous_calc.event_update(p_business_group_id,
5507: p_legislation_code,
5508: 'PAY_ELEMENT_TYPES_F',
5509: 'PROCESSING_PRIORITY',
5510: p_old_PROCESSING_PRIORITY,
5511: p_new_PROCESSING_PRIORITY,
5512: p_effective_date

Line 5516: 'PAY_ELEMENT_TYPES_F',

5512: p_effective_date
5513: );
5514: pay_continuous_calc.event_update(p_business_group_id,
5515: p_legislation_code,
5516: 'PAY_ELEMENT_TYPES_F',
5517: 'PROCESS_MODE',
5518: p_old_PROCESS_MODE,
5519: p_new_PROCESS_MODE,
5520: p_effective_date

Line 5528: 'PAY_ELEMENT_TYPES_F',

5524: /* OK it must be a date track change */
5525: --
5526: pay_continuous_calc.event_update(p_business_group_id,
5527: p_legislation_code,
5528: 'PAY_ELEMENT_TYPES_F',
5529: 'EFFECTIVE_END_DATE',
5530: p_old_EFFECTIVE_END_DATE,
5531: p_new_EFFECTIVE_END_DATE,
5532: p_new_effective_end_date,

Line 5539: 'PAY_ELEMENT_TYPES_F',

5535: );
5536: --
5537: pay_continuous_calc.event_update(p_business_group_id,
5538: p_legislation_code,
5539: 'PAY_ELEMENT_TYPES_F',
5540: 'EFFECTIVE_START_DATE',
5541: p_old_EFFECTIVE_START_DATE,
5542: p_new_EFFECTIVE_START_DATE,
5543: p_new_effective_start_date,

Line 5575: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);

5571: end loop;
5572: end if;
5573: pay_continuous_calc.g_event_list.sz := 0;
5574: end;
5575: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5576: --
5577: end PAY_ELEMENT_TYPES_F_aru;
5578: --
5579: /* PAY_GRADE_RULES_F */

Line 5577: end PAY_ELEMENT_TYPES_F_aru;

5573: pay_continuous_calc.g_event_list.sz := 0;
5574: end;
5575: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5576: --
5577: end PAY_ELEMENT_TYPES_F_aru;
5578: --
5579: /* PAY_GRADE_RULES_F */
5580: /* name : PAY_GRADE_RULES_F_aru
5581: purpose : This is procedure that records any updates

Line 11358: pay_element_types_f pet,

11354: from pay_element_entries_f pee,
11355: pay_element_entry_values_f peev,
11356: pay_element_links_f pel,
11357: pay_link_input_values_f pliv,
11358: pay_element_types_f pet,
11359: pay_input_values_f piv
11360: where pee.element_entry_id = p_element_entry_id
11361: and pee.element_entry_id = peev.element_entry_id
11362: and peev.input_value_id = p_surrogate_key

Line 11428: pay_element_types_f pet,

11424: from pay_element_entries_f pee,
11425: pay_element_entry_values_f peev,
11426: pay_element_links_f pel,
11427: pay_link_input_values_f pliv,
11428: pay_element_types_f pet,
11429: pay_input_values_f piv
11430: where pee.element_entry_id = p_element_entry_id
11431: and pee.element_entry_id = peev.element_entry_id
11432: and peev.input_value_id = pliv.input_value_id