DBA Data[Home] [Help]

APPS.PAY_US_CONTR_DBI dependencies on PER_BUSINESS_GROUPS

Line 39: derived from from per_business_groups if the

35: standards.
36: mwcallag 09-DEC-1993 G334 : Benefit DB item names changed to be
37: _BEN_EE_CONTR_VALUE and
38: _BEN_ER_CONTR_VALUE. Legislation code
39: derived from from per_business_groups if the
40: Legislation code is null on the input value table.
41: mwcallag 30-NOV-1993 G259 : Routine modified to use externalised database
42: item creation procedures in package hrdyndbi.
43: JRhodes 05-Nov-1993 Added "and nvl(BC.contributions_used,'Y') = 'Y'"

Line 50: irgonzal 24-SEP-2001 Bug fix 2004226. Enabled index on per_business_groups

46: mwcallag 02-NOV-1993 exception of no_data_found added to procedure
47: create_contr_items.
48: JRhodes 20-OCT-1993 Created.
49: SDoshi 22-MAR-1999 Flexible Dates Conversion
50: irgonzal 24-SEP-2001 Bug fix 2004226. Enabled index on per_business_groups
51: table by removing "+ 0" from the WHERE clause.
52: Modified create_contr_items procedure.
53: emunisek 17-NOV-2011 For Bug#13375560,replaced LONG datatype by ff_routes.text%TYPE
54:

Line 336: per_business_groups BUSGP,

332: l_created_by,
333: l_last_login
334: from pay_input_values_f IV,
335: pay_element_types_f ET,
336: per_business_groups BUSGP,
337: ben_benefit_classifications BC
338: where IV.input_value_id = p_input_value_id
339: and p_effective_date between IV.effective_start_date
340: and IV.effective_end_date