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_SOE_GLB dependencies on PAY_ELEMENT_ENTRIES_F

Line 250: ,pay_element_entries_f ee

246: ,ppb2.business_group_id
247: ,ee.assignment_id
248: ,eev.screen_entry_value salary
249: from per_pay_bases ppb2
250: ,pay_element_entries_f ee
251: ,pay_element_entry_values_f eev
252: where ppb2.input_value_id = eev.input_value_id
253: and ee.element_entry_id = eev.element_entry_id
254: and :effective_date between ee.effective_start_date

Line 1062: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1058: -- date_earned
1059: ---------------------------------------------------------------------------
1060:
1061: function get_retro_period
1062: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1063: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1064: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1065: ) return varchar2 is
1066:

Line 1067: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1063: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1064: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1065: ) return varchar2 is
1066:
1067: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1068: c_date_earned in pay_payroll_actions.date_earned%TYPE
1069: ) is
1070: SELECT creator_type
1071: FROM pay_element_entries_f pee

Line 1071: FROM pay_element_entries_f pee

1067: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1068: c_date_earned in pay_payroll_actions.date_earned%TYPE
1069: ) is
1070: SELECT creator_type
1071: FROM pay_element_entries_f pee
1072: WHERE pee.element_entry_id=c_element_entry_id
1073: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1074:
1075:

Line 1077: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1073: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1074:
1075:
1076: cursor get_retro_period_rr
1077: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1078: c_date_earned in pay_payroll_actions.date_earned%TYPE
1079: ) is
1080:
1081: SELECT ptp.start_date

Line 1088: pay_element_entries_f pee

1084: FROM per_time_periods ptp,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa,
1087: pay_run_results prr,
1088: pay_element_entries_f pee
1089: WHERE pee.element_entry_id=c_element_entry_id
1090: and prr.run_result_id = pee.source_id
1091: and paa.assignment_action_id=prr.assignment_action_id
1092: and ppa.payroll_action_id=paa.payroll_action_id

Line 1100: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1096: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1097:
1098:
1099: cursor get_retro_period_nr
1100: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1101: c_date_earned in pay_payroll_actions.date_earned%TYPE
1102: ) is
1103: SELECT ptp.start_date
1104: ,ptp.end_date

Line 1110: pay_element_entries_f pee

1106: FROM per_time_periods ptp,
1107: pay_payroll_actions ppa,
1108: pay_assignment_actions paa,
1109: pay_run_results prr,
1110: pay_element_entries_f pee
1111: WHERE pee.element_entry_id=c_element_entry_id
1112: and prr.run_result_id = pee.source_id
1113: and paa.assignment_action_id=prr.assignment_action_id
1114: and ppa.payroll_action_id=paa.payroll_action_id

Line 1122: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1118: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1119:
1120:
1121: cursor get_retro_period_pr
1122: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1123: c_date_earned in pay_payroll_actions.date_earned%TYPE
1124: ) is
1125: SELECT ptp.start_date
1126: ,ptp.end_date

Line 1132: pay_element_entries_f pee

1128: FROM per_time_periods ptp,
1129: pay_payroll_actions ppa,
1130: pay_assignment_actions paa,
1131: pay_run_results prr,
1132: pay_element_entries_f pee
1133: WHERE pee.element_entry_id=c_element_entry_id
1134: and prr.run_result_id = pee.source_id
1135: and paa.assignment_action_id=prr.assignment_action_id
1136: and ppa.payroll_action_id=paa.payroll_action_id

Line 1144: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1140: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1141:
1142:
1143: cursor get_retro_period_ee
1144: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1145: c_date_earned in pay_payroll_actions.date_earned%TYPE
1146: ) is
1147: SELECT ptp.start_date
1148: ,ptp.end_date

Line 1153: pay_element_entries_f pee

1149: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1150: FROM per_time_periods ptp,
1151: pay_payroll_actions ppa,
1152: pay_assignment_actions paa,
1153: pay_element_entries_f pee
1154: WHERE pee.element_entry_id=c_element_entry_id
1155: and paa.assignment_action_id=pee.source_asg_action_id
1156: and ppa.payroll_action_id=paa.payroll_action_id
1157: and ptp.payroll_id=ppa.payroll_id

Line 1162: l_creator_type pay_element_entries_f.creator_type%TYPE;

1158: and pee.creator_type='EE'
1159: and ppa.date_earned between ptp.start_date and ptp.end_date
1160: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1161:
1162: l_creator_type pay_element_entries_f.creator_type%TYPE;
1163: l_period_obtained_flag number;
1164: l_retro_start_date date;
1165: l_retro_end_date date;
1166: l_period_num_year varchar2(30) :=null;