DBA Data[Home] [Help]

APPS.HRSTRDBI dependencies on FF_FORMULA_TYPES_S

Line 413: values (ff_formula_types_s.nextval,

409: last_updated_by,
410: last_update_login,
411: created_by,
412: creation_date)
413: values (ff_formula_types_s.nextval,
414: p_formula_type_name,
415: sysdate,
416: 0,
417: 0,

Line 425: select ff_formula_types_s.currval, CON.context_id

421: begin
422: do_insert ('Oracle Payroll');
423: hr_utility.set_location('hrstrdbi.insert_context', 1);
424: insert into ff_ftype_context_usages (formula_type_id, context_id)
425: select ff_formula_types_s.currval, CON.context_id
426: from ff_contexts CON
427: where context_name in ('BUSINESS_GROUP_ID',
428: 'PAYROLL_ID',
429: 'PAYROLL_ACTION_ID',

Line 446: select ff_formula_types_s.currval, CON.context_id

442: --
443: do_insert ('Payment');
444: hr_utility.set_location('hrstrdbi.insert_context', 2);
445: insert into ff_ftype_context_usages (formula_type_id, context_id)
446: select ff_formula_types_s.currval, CON.context_id
447: from ff_contexts CON
448: where context_name in ('BUSINESS_GROUP_ID',
449: 'PAYROLL_ID',
450: 'PAYROLL_ACTION_ID',

Line 463: select ff_formula_types_s.currval, CON.context_id

459: --
460: do_insert ('Assignment Set');
461: hr_utility.set_location('hrstrdbi.insert_context', 3);
462: insert into ff_ftype_context_usages (formula_type_id, context_id)
463: select ff_formula_types_s.currval, CON.context_id
464: from ff_contexts CON
465: where context_name in ('DATE_EARNED', 'ASSIGNMENT_ID');
466: --
467: do_insert ('QuickPaint');

Line 470: select ff_formula_types_s.currval, CON.context_id

466: --
467: do_insert ('QuickPaint');
468: hr_utility.set_location('hrstrdbi.insert_context', 4);
469: insert into ff_ftype_context_usages (formula_type_id, context_id)
470: select ff_formula_types_s.currval, CON.context_id
471: from ff_contexts CON
472: where context_name in ('DATE_EARNED', 'ASSIGNMENT_ID');
473: --
474: do_insert ('Element Input Validation');

Line 477: select ff_formula_types_s.currval, CON.context_id

473: --
474: do_insert ('Element Input Validation');
475: hr_utility.set_location('hrstrdbi.insert_context', 5);
476: insert into ff_ftype_context_usages (formula_type_id, context_id)
477: select ff_formula_types_s.currval, CON.context_id
478: from ff_contexts CON
479: where context_name in ('DATE_EARNED',
480: 'ASSIGNMENT_ID', 'BUSINESS_GROUP_ID');
481: --

Line 485: select ff_formula_types_s.currval, CON.context_id

481: --
482: do_insert ('Element Skip');
483: hr_utility.set_location('hrstrdbi.insert_context', 6);
484: insert into ff_ftype_context_usages (formula_type_id, context_id)
485: select ff_formula_types_s.currval, CON.context_id
486: from ff_contexts CON
487: where context_name in ('BUSINESS_GROUP_ID',
488: 'PAYROLL_ID',
489: 'PAYROLL_ACTION_ID',

Line 504: select ff_formula_types_s.currval, CON.context_id

500: --
501: do_insert ('Legislative Check');
502: hr_utility.set_location('hrstrdbi.insert_context', 7);
503: insert into ff_ftype_context_usages (formula_type_id, context_id)
504: select ff_formula_types_s.currval, CON.context_id
505: from ff_contexts CON
506: where context_name in ('ASSIGNMENT_ID',
507: 'ASSIGNMENT_ACTION_ID',
508: 'DATE_EARNED');

Line 513: select ff_formula_types_s.currval, CON.context_id

509: --
510: do_insert ('Accrual');
511: hr_utility.set_location('hrstrdbi.insert_context', 8);
512: insert into ff_ftype_context_usages (formula_type_id, context_id)
513: select ff_formula_types_s.currval, CON.context_id
514: from ff_contexts CON
515: where context_name in ('ASSIGNMENT_ID',
516: 'ASSIGNMENT_ACTION_ID',
517: 'DATE_EARNED',

Line 526: select ff_formula_types_s.currval, CON.context_id

522: --
523: do_insert ('Accrual Subformula');
524: hr_utility.set_location('hrstrdbi.insert_context', 9);
525: insert into ff_ftype_context_usages (formula_type_id, context_id)
526: select ff_formula_types_s.currval, CON.context_id
527: from ff_contexts CON
528: where context_name in ('ASSIGNMENT_ID',
529: 'DATE_EARNED',
530: 'ACCRUAL_PLAN_ID',

Line 537: select ff_formula_types_s.currval, CON.context_id

533: --
534: do_insert ('Accrual Carryover');
535: hr_utility.set_location('hrstrdbi.insert_context', 10);
536: insert into ff_ftype_context_usages (formula_type_id, context_id)
537: select ff_formula_types_s.currval, CON.context_id
538: from ff_contexts CON
539: where context_name in ('ASSIGNMENT_ID',
540: 'DATE_EARNED',
541: 'ACCRUAL_PLAN_ID',

Line 548: select ff_formula_types_s.currval, CON.context_id

544: --
545: do_insert ('Accrual Ineligibility');
546: hr_utility.set_location('hrstrdbi.insert_context', 11);
547: insert into ff_ftype_context_usages (formula_type_id, context_id)
548: select ff_formula_types_s.currval, CON.context_id
549: from ff_contexts CON
550: where context_name in ('ASSIGNMENT_ID',
551: 'DATE_EARNED',
552: 'ACCRUAL_PLAN_ID',

Line 559: select ff_formula_types_s.currval, CON.context_id

555: --
556: do_insert ('Net to Gross');
557: hr_utility.set_location('hrstrdbi.insert_context', 12);
558: insert into ff_ftype_context_usages (formula_type_id, context_id)
559: select ff_formula_types_s.currval, CON.context_id
560: from ff_contexts CON
561: where context_name in ('BUSINESS_GROUP_ID',
562: 'PAYROLL_ID',
563: 'PAYROLL_ACTION_ID',

Line 573: select ff_formula_types_s.currval, CON.context_id

569: --
570: do_insert('CAGR');
571: hr_utility.set_location('hrstrdbi.insert_context', 13);
572: insert into ff_ftype_context_usages (formula_type_id, context_id)
573: select ff_formula_types_s.currval, CON.context_id
574: from ff_contexts CON
575: where context_name in ('BUSINESS_GROUP_ID',
576: 'PAYROLL_ID',
577: 'ASSIGNMENT_ID',

Line 586: select ff_formula_types_s.currval, CON.context_id

582: --
583: do_insert('Promotion');
584: hr_utility.set_location('hrstrdbi.insert_context', 14);
585: insert into ff_ftype_context_usages (formula_type_id, context_id)
586: select ff_formula_types_s.currval, CON.context_id
587: from ff_contexts CON
588: where context_name in ('ASSIGNMENT_ID',
589: 'DATE_EARNED');
590: --

Line 594: select ff_formula_types_s.currval, CON.context_id

590: --
591: do_insert('Payroll Run Proration');
592: hr_utility.set_location('hrstrdbi.insert_context', 15);
593: insert into ff_ftype_context_usages (formula_type_id, context_id)
594: select ff_formula_types_s.currval, CON.context_id
595: from ff_contexts CON
596: where context_name in ('BUSINESS_GROUP_ID',
597: 'PAYROLL_ID',
598: 'PAYROLL_ACTION_ID',