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

Line 334: p_session_date in pay_element_types_f.effective_start_date%TYPE,

330: ******************************************************************************/
331: PROCEDURE populate_element_info( p_assignment_id in number,
332: p_assignment_action_id in number,
333: p_classification_name in pay_element_classifications.classification_name%TYPE,
334: p_session_date in pay_element_types_f.effective_start_date%TYPE,
335: p_tax_unit_id in number,
336: p_per_month in number,
337: p_per_qtd in number,
338: p_per_ytd in number,

Line 345: p_business_group_id in pay_element_types_f.business_group_id%TYPE,

341: p_asg_qtd in number,
342: p_asg_ytd in number,
343: p_asg_arr_itd in number,
344: p_asg_acc_itd in number,
345: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
346: p_balance_level in varchar2
347: )
348: IS PRAGMA AUTONOMOUS_TRANSACTION;
349:

Line 449: pay_element_types_f pet

445: pbd.database_item_suffix
446: FROM pay_defined_balances pdb_call,
447: pay_balance_dimensions pbd,
448: pay_balance_types pbt,
449: pay_element_types_f pet
450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
451: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
452: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
453: AND pet.classification_id = l_classification_id

Line 477: pay_element_types_f pet

473: pbd.database_item_suffix
474: FROM pay_defined_balances pdb_call,
475: pay_balance_dimensions pbd,
476: pay_balance_types pbt,
477: pay_element_types_f pet
478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
479: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
480: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
481: AND pet.classification_id = l_classification_id

Line 504: pay_element_types_f pet

500: pbd.balance_dimension_id
501: FROM pay_defined_balances pdb_call,
502: pay_balance_dimensions pbd,
503: pay_balance_types pbt,
504: pay_element_types_f pet
505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
506: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
507: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
508: AND pet.classification_id = l_classification_id

Line 530: pay_element_types_f pet

526: pbd.balance_dimension_id
527: FROM pay_defined_balances pdb_call,
528: pay_balance_dimensions pbd,
529: pay_balance_types pbt,
530: pay_element_types_f pet
531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
532: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
533: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
534: AND pet.classification_id = l_classification_id

Line 555: FROM pay_element_types_f pet

551: SELECT DISTINCT pet.element_name
552: ,pet.element_type_id
553: ,pet.classification_id
554: ,pet.element_information10
555: FROM pay_element_types_f pet
556: ,pay_element_types_f pet2
557: ,pay_element_entries_f ee
558: WHERE pet2.classification_id = l_classification_id
559: AND pet2.element_information10 IS NOT NULL

Line 556: ,pay_element_types_f pet2

552: ,pet.element_type_id
553: ,pet.classification_id
554: ,pet.element_information10
555: FROM pay_element_types_f pet
556: ,pay_element_types_f pet2
557: ,pay_element_entries_f ee
558: WHERE pet2.classification_id = l_classification_id
559: AND pet2.element_information10 IS NOT NULL
560: AND ee.effective_end_date >= l_pay_start_date

Line 566: FROM pay_element_types_f pet1

562: AND ee.effective_start_date BETWEEN pet2.effective_start_date AND pet2.effective_end_date
563: AND pet2.element_type_id = pet.element_type_id
564: AND PET.effective_start_date =
565: (SELECT max(pet1.effective_start_date)
566: FROM pay_element_types_f pet1
567: WHERE pet1.element_type_id = pet.element_type_id
568: AND pet1.effective_start_date <= p_session_date )
569: AND ee.assignment_id = p_assignment_id
570: AND EXISTS

Line 593: FROM pay_element_types_f pet

589: ,pet.classification_id
590: ,pet.element_information10
591: ,pet.element_information11
592: ,pet.element_information13
593: FROM pay_element_types_f pet
594: ,pay_element_types_f pet2
595: ,pay_element_entries_f ee
596: WHERE pet2.classification_id = l_classification_id
597: AND pet2.element_information10 IS NOT NULL

Line 594: ,pay_element_types_f pet2

590: ,pet.element_information10
591: ,pet.element_information11
592: ,pet.element_information13
593: FROM pay_element_types_f pet
594: ,pay_element_types_f pet2
595: ,pay_element_entries_f ee
596: WHERE pet2.classification_id = l_classification_id
597: AND pet2.element_information10 IS NOT NULL
598: AND ee.effective_end_date >= l_pay_start_date

Line 604: FROM pay_element_types_f pet1

600: AND ee.effective_start_date BETWEEN pet2.effective_start_date AND pet2.effective_end_date
601: AND pet2.element_type_id = pet.element_type_id
602: AND PET.effective_start_date =
603: (SELECT max(pet1.effective_start_date)
604: FROM pay_element_types_f pet1
605: WHERE pet1.element_type_id = pet.element_type_id
606: AND pet1.effective_start_date <= p_session_date )
607: AND ee.assignment_id = p_assignment_id
608: AND EXISTS

Line 630: FROM pay_element_types_f pet

626: SELECT DISTINCT pet.element_name
627: ,pet.element_type_id
628: ,pet.classification_id
629: ,pet.element_information10
630: FROM pay_element_types_f pet
631: ,pay_run_results prr
632: WHERE prr.assignment_action_id = p_assignment_action_id
633: AND pet.element_type_id = prr.element_type_id
634: AND pet.business_group_id = p_business_group_id

Line 651: FROM pay_element_types_f pet

647: ,pet.classification_id
648: ,pet.element_information10
649: ,pet.element_information11
650: ,pet.element_information13
651: FROM pay_element_types_f pet
652: ,pay_run_results prr
653: WHERE prr.assignment_action_id = p_assignment_action_id
654: AND pet.element_type_id = prr.element_type_id
655: AND pet.business_group_id = p_business_group_id

Line 670: ,pay_element_types_f et

666: ,pet2.element_type_id
667: ,pet2.classification_id
668: ,pet2.element_information10
669: FROM pay_element_classifications ec
670: ,pay_element_types_f et
671: ,pay_element_links_f el
672: ,pay_element_entries_f ee
673: ,pay_element_entry_values_f eev
674: ,pay_balance_feeds_f pbf

Line 675: ,pay_element_types_f pet2

671: ,pay_element_links_f el
672: ,pay_element_entries_f ee
673: ,pay_element_entry_values_f eev
674: ,pay_balance_feeds_f pbf
675: ,pay_element_types_f pet2
676: ,pay_element_classifications pec
677: ,pay_input_values_f piv
678: ,pay_balance_types pbt
679: WHERE ec.classification_name = 'Balance Initialization'

Line 714: ,pay_element_types_f et

710: ,pet2.element_information10
711: ,pet2.element_information11
712: ,pet2.element_information13
713: FROM pay_element_classifications ec
714: ,pay_element_types_f et
715: ,pay_element_links_f el
716: ,pay_element_entries_f ee
717: ,pay_element_entry_values_f eev
718: ,pay_balance_feeds_f pbf

Line 719: ,pay_element_types_f pet2

715: ,pay_element_links_f el
716: ,pay_element_entries_f ee
717: ,pay_element_entry_values_f eev
718: ,pay_balance_feeds_f pbf
719: ,pay_element_types_f pet2
720: ,pay_element_classifications pec
721: ,pay_input_values_f piv
722: ,pay_balance_types pbt
723: WHERE ec.classification_name = 'Balance Initialization'