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_PAYROLL_ARCH dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 739: pay_element_classifications pec,

735: petf.processing_priority,
736: pec.classification_name
737: FROM pay_element_types_f petf,
738: pay_element_types_f_tl petfl,
739: pay_element_classifications pec,
740: pay_run_results prr,
741: pay_action_interlocks pai,
742: pay_assignment_actions paa_pre,
743: pay_payroll_actions ppa_pre

Line 770: lv_element_classification_name pay_element_classifications.classification_name%TYPE;

766:
767: ln_primary_balance_id NUMBER;
768: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
769: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
770: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
771: lv_jurisdiction_code pay_run_results.jurisdiction_code%TYPE;
772: ln_hours_balance_id NUMBER;
773: ln_days_balance_id NUMBER;
774:

Line 1086: pay_element_classifications pec

1082: petf.element_type_id,
1083: petf.processing_priority,
1084: pec.classification_name
1085: FROM pay_element_types_f petf,
1086: pay_element_classifications pec
1087: WHERE pec.classification_name IN ('Earnings',
1088: 'Supplemental Earnings',
1089: 'Taxable Benefits',
1090: 'Direct Payment',

Line 1113: lv_element_classification_name pay_element_classifications.classification_name%TYPE;

1109:
1110: ln_t_primary_balance_id NUMBER;
1111: lv_t_reporting_name pay_element_types_f.reporting_name%TYPE;
1112: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
1113: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
1114:
1115: ln_ele_primary_balance_id NUMBER;
1116: ln_ele_hours_balance_id NUMBER;
1117: ln_ele_days_balance_id NUMBER;

Line 1432: pay_element_classifications pec,

1428: petf.processing_priority,
1429: pec.classification_name
1430: FROM pay_element_types_f petf,
1431: pay_element_types_f_tl petl,
1432: pay_element_classifications pec,
1433: pay_run_results prr,
1434: pay_assignment_actions paa,
1435: pay_payroll_actions ppa
1436: WHERE

Line 1467: pay_element_classifications pec,

1463: petf.processing_priority,
1464: pec.classification_name
1465: FROM pay_element_types_f petf,
1466: pay_element_types_f_tl petl,
1467: pay_element_classifications pec,
1468: pay_run_results prr,
1469: pay_assignment_actions paa,
1470: pay_action_interlocks pai,
1471: pay_payroll_actions ppa

Line 1504: lv_element_classification_name pay_element_classifications.classification_name%TYPE;

1500:
1501: ln_element_type_id NUMBER;
1502: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1503: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
1504: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
1505: ln_primary_balance_id NUMBER;
1506: ln_hours_balance_id NUMBER;
1507: ln_days_balance_id NUMBER;
1508: ln_processing_priority NUMBER;

Line 1702: lv_classification_name pay_element_classifications.classification_name%TYPE;

1698: )
1699: IS
1700:
1701: ln_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1702: lv_classification_name pay_element_classifications.classification_name%TYPE;
1703: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1704: ln_element_type_id pay_element_types_f.element_type_id%TYPE;
1705: lv_element_category pay_element_classifications.classification_name%TYPE;
1706:

Line 1705: lv_element_category pay_element_classifications.classification_name%TYPE;

1701: ln_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1702: lv_classification_name pay_element_classifications.classification_name%TYPE;
1703: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1704: ln_element_type_id pay_element_types_f.element_type_id%TYPE;
1705: lv_element_category pay_element_classifications.classification_name%TYPE;
1706:
1707: ln_amount NUMBER;
1708: ln_hours NUMBER;
1709: lv_procedure_name VARCHAR2(100);

Line 1764: ,pay_element_classifications pec

1760: ,pay_run_result_values prrv
1761: ,pay_input_values_f piv
1762: ,pay_element_types_f pet
1763: ,pay_element_types_f_tl petl
1764: ,pay_element_classifications pec
1765: ,per_assignments_f paf
1766: WHERE ppa.action_type IN ('R','Q','B','V')
1767: AND ppa.action_status = 'C'
1768: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1850: ,pay_element_classifications pec

1846: ,pay_run_result_values prrv
1847: ,pay_input_values_f piv
1848: ,pay_element_types_f pet
1849: ,pay_element_types_f_tl petl
1850: ,pay_element_classifications pec
1851: ,pay_action_interlocks pai
1852: ,per_assignments_f paf
1853: WHERE ppa.action_type IN ('R','Q','B','V')
1854: AND ppa.action_status = 'C'

Line 2033: lv_element_classification_name pay_element_classifications.classification_name%TYPE;

2029:
2030: ln_processing_priority NUMBER;
2031: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
2032: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
2033: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
2034: ln_element_type_id NUMBER;
2035: lv_jurisdiction_code pay_run_results.jurisdiction_code%TYPE;
2036: ln_primary_balance_id NUMBER;
2037: ln_hours_balance_id NUMBER;

Line 2070: pay_element_classifications pec,

2066: petf.processing_priority,
2067: pec.classification_name
2068: FROM pay_element_types_f petf,
2069: pay_element_types_f_tl petl,
2070: pay_element_classifications pec,
2071: pay_assignment_actions paa,
2072: pay_payroll_actions ppa,
2073: pay_run_results prr
2074: WHERE petf.element_type_id = prr.element_type_id