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

Line 470: -- pay_element_entries_f and pay_element_types_f

466: -- Cursor to get elements processed from the element entries.
467: -- rmonge Added a order by clause to make sure the earnings are retrieved in
468: -- order by Processing priority and type of EArnings.
469: -- Bug 4004796.Modified the Date effective joins with
470: -- pay_element_entries_f and pay_element_types_f
471:
472: -- Bug 4966938
473: CURSOR c_get_earn_elements(cp_date_paid date,
474: cp_assignment_action_id number) IS

Line 486: pay_element_types_f pet ,

482: from pay_assignment_actions paa ,
483: pay_assignment_actions paa1 ,
484: pay_payroll_actions ppa ,
485: pay_run_results prr ,
486: pay_element_types_f pet ,
487: pay_element_classifications pec
488: where paa.assignment_action_id = cp_assignment_action_id
489: and paa1.assignment_id = paa.assignment_id
490: -- and paa1.source_action_id is not null --for bug 5332346

Line 532: pay_element_types_f pet,

528: pec.classification_name,
529: pet.processing_priority
530: from pay_element_entries_f pee,
531: pay_run_results prr,
532: pay_element_types_f pet,
533: pay_element_classifications pec
534: where pee.assignment_id = cp_assignment_id
535: --and pee.effective_end_date >= trunc(cp_date_earned, 'Y')
536: and pee.effective_start_date <= cp_date_earned

Line 548: from pay_element_types_f pet1

544: and pet.classification_id = pec.classification_id
545: and pet.element_information10 is not null
546: and pet.effective_start_date =
547: (select max(pet1.effective_start_date)
548: from pay_element_types_f pet1
549: where pet1.element_type_id = pet.element_type_id
550: and pet1.effective_start_date <= cp_date_earned)
551: and prr.element_type_id + 0 = pet.element_type_id
552: order by decode(nvl(pet.reporting_name, pet.element_name),

Line 578: l_element_type_id pay_element_types_f.element_type_id%type;

574: l_found boolean;
575: l_pos number;
576: l_procedure varchar2(21);
577:
578: l_element_type_id pay_element_types_f.element_type_id%type;
579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;

Line 579: l_element_reporting_name pay_element_types_f.reporting_name%type;

575: l_pos number;
576: l_procedure varchar2(21);
577:
578: l_element_type_id pay_element_types_f.element_type_id%type;
579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 580: l_element_information10 pay_element_types_f.element_information10%type;

576: l_procedure varchar2(21);
577:
578: l_element_type_id pay_element_types_f.element_type_id%type;
579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 581: l_element_information12 pay_element_types_f.element_information12%type;

577:
578: l_element_type_id pay_element_types_f.element_type_id%type;
579: l_element_reporting_name pay_element_types_f.reporting_name%type;
580: l_element_information10 pay_element_types_f.element_information10%type;
581: l_element_information12 pay_element_types_f.element_information12%type;
582: l_assignment_id pay_assignment_actions.assignment_id%type;
583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;

Line 587: l_business_group_id pay_element_types_f.business_group_id%type;

583: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;
587: l_business_group_id pay_element_types_f.business_group_id%type;
588: l_classification_name pay_element_classifications.classification_name%type;
589: l_processing_priority pay_element_types_f.processing_priority%type;
590:
591:

Line 589: l_processing_priority pay_element_types_f.processing_priority%type;

585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;
587: l_business_group_id pay_element_types_f.business_group_id%type;
588: l_classification_name pay_element_classifications.classification_name%type;
589: l_processing_priority pay_element_types_f.processing_priority%type;
590:
591:
592: -- Procedure to get the position of the reporting name in the plsql table
593: -- If the element exists it will return the position otherwise will return

Line 2675: pay_element_types_f pet ,

2671: from pay_assignment_actions paa ,
2672: pay_assignment_actions paa1 ,
2673: pay_payroll_actions ppa ,
2674: pay_run_results prr ,
2675: pay_element_types_f pet ,
2676: pay_element_classifications pec
2677: where paa.assignment_action_id = cp_assignment_action_id
2678: and paa1.assignment_id = paa.assignment_id
2679: -- and paa1.source_action_id is not null --for bug 5332346

Line 2705: pay_element_types_f pet,

2701: pet.business_group_id,
2702: pet.processing_priority
2703: from pay_element_entries_f pee,
2704: pay_run_results prr,
2705: pay_element_types_f pet,
2706: pay_element_classifications pec
2707: where pee.assignment_id = cp_assignment_id
2708: and pee.effective_end_date >= trunc(cp_date_earned, 'Y')
2709: and pee.effective_start_date <= cp_date_earned

Line 2719: from pay_element_types_f pet1

2715: and pet.classification_id = pec.classification_id
2716: and pet.element_information10 is not null
2717: and pet.effective_start_date =
2718: (select max(pet1.effective_start_date)
2719: from pay_element_types_f pet1
2720: where pet1.element_type_id = pet.element_type_id
2721: and pet1.effective_start_date <= cp_date_earned)
2722: and prr.element_type_id + 0 = pet.element_type_id
2723: order by pet.processing_priority;

Line 2735: l_element_type_id pay_element_types_f.element_type_id%type;

2731: l_pos number;
2732: l_procedure varchar2(21) ;
2733:
2734:
2735: l_element_type_id pay_element_types_f.element_type_id%type;
2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 2736: l_element_reporting_name pay_element_types_f.reporting_name%type;

2732: l_procedure varchar2(21) ;
2733:
2734:
2735: l_element_type_id pay_element_types_f.element_type_id%type;
2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 2737: l_element_information10 pay_element_types_f.element_information10%type;

2733:
2734:
2735: l_element_type_id pay_element_types_f.element_type_id%type;
2736: l_element_reporting_name pay_element_types_f.reporting_name%type;
2737: l_element_information10 pay_element_types_f.element_information10%type;
2738: l_assignment_id pay_assignment_actions.assignment_id%type;
2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;

Line 2743: l_business_group_id pay_element_types_f.business_group_id%type;

2739: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;
2742: l_date_paid pay_payroll_actions.effective_date%type;
2743: l_business_group_id pay_element_types_f.business_group_id%type;
2744: l_processing_priority pay_element_types_f.processing_priority%type;
2745:
2746:
2747: -- Procedure to get the position of the deductions in the plsql

Line 2744: l_processing_priority pay_element_types_f.processing_priority%type;

2740: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2741: l_date_earned pay_payroll_actions.date_earned%type;
2742: l_date_paid pay_payroll_actions.effective_date%type;
2743: l_business_group_id pay_element_types_f.business_group_id%type;
2744: l_processing_priority pay_element_types_f.processing_priority%type;
2745:
2746:
2747: -- Procedure to get the position of the deductions in the plsql
2748: -- table. If the element exists it will return the position otherwise will return