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_TYPES_F

Line 122: l_element_type_id pay_element_types_f.element_type_id%TYPE;

118: )
119: RETURN NUMBER
120: IS
121:
122: l_element_type_id pay_element_types_f.element_type_id%TYPE;
123: l_input_value_id pay_input_values_f.input_value_id%TYPE;
124: lv_procedure_name VARCHAR2(50);
125: lv_error_message VARCHAR2(200);
126:

Line 132: (c_element_type_id pay_element_types_f.element_type_id%TYPE

128: l_temp NUMBER := NULL;
129: ln_step NUMBER;
130:
131: CURSOR get_hours_input_value
132: (c_element_type_id pay_element_types_f.element_type_id%TYPE
133: ,c_effective_date date)
134: IS
135: SELECT pivf.input_value_id
136: ,pivf.name

Line 737: FROM pay_element_types_f petf,

733: petf.element_information12, -- Hours Balance
734: petf.element_type_id,
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,

Line 738: pay_element_types_f_tl petfl,

734: petf.element_type_id,
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,

Line 768: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

764: WHERE assignment_id = p_assignment_id;
765:
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;

Line 1085: FROM pay_element_types_f petf,

1081: petf.element_information12, -- Hours Balance
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',

Line 1105: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

1101: ORDER BY 1;
1102:
1103: lv_jurisdiction_code pay_run_results.jurisdiction_code%TYPE;
1104: ln_primary_balance_id NUMBER;
1105: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1106: ld_effective_date DATE;
1107: ln_hours_balance_id NUMBER;
1108: ln_days_balance_id NUMBER;
1109:

Line 1111: lv_t_reporting_name pay_element_types_f.reporting_name%TYPE;

1107: ln_hours_balance_id NUMBER;
1108: ln_days_balance_id NUMBER;
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;

Line 1430: FROM pay_element_types_f petf,

1426: petf.element_information12, -- Hours Balance
1427: petf.element_type_id,
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,

Line 1431: pay_element_types_f_tl petl,

1427: petf.element_type_id,
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

Line 1465: FROM pay_element_types_f petf,

1461: petf.element_information12, -- Hours Balance
1462: petf.element_type_id,
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,

Line 1466: pay_element_types_f_tl petl,

1462: petf.element_type_id,
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,

Line 1502: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

1498: FROM per_assignments_f
1499: WHERE assignment_id = p_assignment_id;
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;

Line 1703: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

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:
1707: ln_amount NUMBER;

Line 1704: ln_element_type_id pay_element_types_f.element_type_id%TYPE;

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:
1707: ln_amount NUMBER;
1708: ln_hours NUMBER;

Line 1762: ,pay_element_types_f pet

1758: ,pay_assignment_actions paa
1759: ,pay_run_results prr
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')

Line 1763: ,pay_element_types_f_tl petl

1759: ,pay_run_results prr
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'

Line 1848: ,pay_element_types_f pet

1844: ,pay_assignment_actions paa
1845: ,pay_run_results prr
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

Line 1849: ,pay_element_types_f_tl petl

1845: ,pay_run_results prr
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')

Line 2031: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

2027:
2028: IS
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;

Line 2068: FROM pay_element_types_f petf,

2064: petf.element_information12, -- Hours Balance
2065: petf.element_type_id,
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,

Line 2069: pay_element_types_f_tl petl,

2065: petf.element_type_id,
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

Line 2915: lv_reporting_name pay_element_types_f.reporting_name%TYPE;

2911: )
2912: IS
2913:
2914: ln_amount NUMBER;
2915: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
2916:
2917: ln_gross_earnings NUMBER := 0;
2918: ln_tax_deductions NUMBER := 0;
2919: ln_deductions NUMBER := 0;

Line 3374: ,pay_element_types_f pet

3370: ,pay_payroll_actions ppa
3371: ,pay_run_results prr
3372: ,pay_run_result_values prrv
3373: ,per_time_periods ptp
3374: ,pay_element_types_f pet
3375: ,pay_input_values_f piv
3376: ,pay_element_entries_f pee
3377: ,per_absence_attendance_types pat
3378: ,per_absence_attendances pab