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

Line 1178: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1174:
1175:
1176: function check_if_retro
1177: (
1178: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1179: p_date_earned in pay_payroll_actions.date_earned%TYPE
1180:
1181: )return varchar2 is
1182:

Line 1184: l_creator_type pay_element_entries_f.creator_type%TYPE;

1180:
1181: )return varchar2 is
1182:
1183:
1184: l_creator_type pay_element_entries_f.creator_type%TYPE;
1185: IS_retro_payment varchar2(10);
1186: l_procedure varchar2(80);
1187: begin
1188: g_debug := hr_utility.debug_enabled;

Line 1224: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1220:
1221:
1222: function get_retro_period
1223: (
1224: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1225: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1226: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,/*Bug 4418107*/
1227: p_retro_start_date out NOCOPY date,
1228: p_retro_end_date out NOCOPY date

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

1229: )return number is
1230:
1231:
1232: cursor get_retro_period_rr
1233: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1234: c_date_earned in pay_payroll_actions.date_earned%TYPE
1235: ) is
1236: SELECT ptp.start_date,ptp.end_date
1237: FROM per_time_periods ptp,

Line 1241: pay_element_entries_f pee

1237: FROM per_time_periods ptp,
1238: pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: pay_run_results prr,
1241: pay_element_entries_f pee
1242: WHERE pee.element_entry_id=c_element_entry_id
1243: and prr.run_result_id = pee.source_id
1244: and paa.assignment_action_id=prr.assignment_action_id
1245: AND paa.tax_unit_id = p_tax_unit_id /*Bug 4418107*/

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

1251:
1252:
1253:
1254: cursor get_retro_period_ee
1255: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1256: c_date_earned in pay_payroll_actions.date_earned%TYPE
1257: ) is
1258: SELECT ptp.start_date,ptp.end_date
1259: FROM per_time_periods ptp,

Line 1262: pay_element_entries_f pee

1258: SELECT ptp.start_date,ptp.end_date
1259: FROM per_time_periods ptp,
1260: pay_payroll_actions ppa,
1261: pay_assignment_actions paa,
1262: pay_element_entries_f pee
1263: WHERE pee.element_entry_id=c_element_entry_id
1264: and paa.assignment_action_id=pee.source_asg_action_id
1265: AND paa.tax_unit_id = p_tax_unit_id /*Bug 4418107*/
1266: and ppa.payroll_action_id=paa.payroll_action_id

Line 1272: l_creator_type pay_element_entries_f.creator_type%TYPE;

1268: and pee.creator_type='EE'
1269: and ppa.date_earned between ptp.start_date and ptp.end_date
1270: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1271:
1272: l_creator_type pay_element_entries_f.creator_type%TYPE;
1273: l_period_obtained_flag number;
1274: l_procedure varchar2(80);
1275:
1276:

Line 1347: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

1343: */
1344:
1345: FUNCTION get_enhanced_retro_period
1346: (
1347: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1348: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1349: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1350: p_retro_start_date OUT NOCOPY date,
1351: p_retro_end_date OUT NOCOPY date,

Line 1362: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)

1358: /* Bug 5586445 - Cursor get_retropay_run_details
1359: Get Effective Date of the Enhanced Retropay process
1360: */
1361: CURSOR get_retropay_run_details
1362: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE)
1363: IS
1364: SELECT pee.creator_type,
1365: ppa.effective_date
1366: FROM pay_payroll_actions ppa,

Line 1368: pay_element_entries_f pee

1364: SELECT pee.creator_type,
1365: ppa.effective_date
1366: FROM pay_payroll_actions ppa,
1367: pay_assignment_actions paa,
1368: pay_element_entries_f pee
1369: WHERE ppa.payroll_action_id = paa.payroll_action_id
1370: AND paa.assignment_action_id = pee.creator_id
1371: AND pee.element_entry_id = c_element_entry_id
1372: AND ppa.action_type ='L';

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

1371: AND pee.element_entry_id = c_element_entry_id
1372: AND ppa.action_type ='L';
1373:
1374: CURSOR get_retro_period_rr
1375: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1376: c_date_earned in pay_payroll_actions.date_earned%TYPE
1377: )
1378: IS
1379: SELECT ptp.start_date

Line 1386: pay_element_entries_f pee

1382: FROM per_time_periods ptp,
1383: pay_payroll_actions ppa,
1384: pay_assignment_actions paa,
1385: pay_run_results prr,
1386: pay_element_entries_f pee
1387: WHERE pee.element_entry_id=c_element_entry_id
1388: AND prr.run_result_id = pee.source_id
1389: AND paa.assignment_action_id=prr.assignment_action_id
1390: AND paa.tax_unit_id = p_tax_unit_id

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

1395: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
1396:
1397:
1398: CURSOR get_retro_period_ee
1399: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1400: c_date_earned in pay_payroll_actions.date_earned%TYPE
1401: )
1402: IS
1403: SELECT ptp.start_date

Line 1409: pay_element_entries_f pee

1405: ,ppa.effective_date
1406: FROM per_time_periods ptp,
1407: pay_payroll_actions ppa,
1408: pay_assignment_actions paa,
1409: pay_element_entries_f pee
1410: WHERE pee.element_entry_id=c_element_entry_id
1411: AND paa.assignment_action_id=pee.source_asg_action_id
1412: AND paa.tax_unit_id = p_tax_unit_id
1413: AND ppa.payroll_action_id=paa.payroll_action_id

Line 1422: l_creator_type pay_element_entries_f.creator_type%TYPE;

1418:
1419: l_period_obtained_flag number;
1420:
1421: l_procedure VARCHAR2(80);
1422: l_creator_type pay_element_entries_f.creator_type%TYPE;
1423: l_fin_year_start DATE;
1424: l_month_start DATE;
1425: l_orig_month_start DATE;
1426: l_time_span VARCHAR2(80);

Line 1577: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,

1573:
1574:
1575: FUNCTION get_retro_time_span
1576: (
1577: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
1578: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
1579: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1580: p_retro_start_date OUT NOCOPY date,
1581: p_retro_end_date OUT NOCOPY date,

Line 1590: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE

1586: )RETURN NUMBER
1587: IS
1588:
1589: CURSOR get_retro_entry_details
1590: (c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1591: ,c_date_earned pay_payroll_actions.date_earned%TYPE)
1592: IS
1593: SELECT pee.element_entry_id
1594: ,ppa.retro_definition_id

Line 1596: FROM pay_element_entries_f pee

1592: IS
1593: SELECT pee.element_entry_id
1594: ,ppa.retro_definition_id
1595: ,pepd.retro_component_id
1596: FROM pay_element_entries_f pee
1597: ,pay_assignment_actions paa
1598: ,pay_payroll_actions ppa
1599: ,pay_entry_process_details pepd
1600: WHERE pee.element_entry_id = c_element_entry_id

Line 1720: select pee.element_entry_id from pay_element_entries_f pee,

1716: -- Need to get the pay value amount so we can check totals in each period.
1717: /*
1718: cursor get_element_entries
1719: is
1720: select pee.element_entry_id from pay_element_entries_f pee,
1721: pay_assignment_actions paa
1722: where paa.assignment_action_id=p_assignment_action_id
1723: and pee.assignment_id=paa.assignment_id
1724: and pee.creator_type IN ('EE','RR')

Line 1732: from pay_element_entries_f pee,

1728: is
1729: select pee.element_entry_id,
1730: peev.screen_entry_value retro_amount,
1731: pec.classification_name
1732: from pay_element_entries_f pee,
1733: pay_element_entry_values_f peev,
1734: pay_element_links_f pelf,
1735: pay_element_types_f pet,
1736: pay_element_classifications pec,

Line 2107: pay_element_entries_f peef, /* Bug#2563515 */

2103: pay_element_types_f pet,
2104: pay_input_values_f piv,
2105: pay_input_values_f piv1,
2106: pay_element_links_f pel, /* Bug#2563515 */
2107: pay_element_entries_f peef, /* Bug#2563515 */
2108: pay_element_entry_values_f peev,
2109: pay_element_entry_values_f peev1
2110: where pet.element_name = 'Extra Withholding Payments'
2111: and pet.element_type_id= piv.element_type_id

Line 2306: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,

2302: */
2303: FUNCTION get_salary_basis_hours
2304: (
2305: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
2306: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
2307: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
2308: )
2309: RETURN NUMBER IS
2310:

Line 2311: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;

2307: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
2308: )
2309: RETURN NUMBER IS
2310:
2311: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;
2312: l_result number := NULL;
2313: l_procedure varchar2(80);
2314:
2315: CURSOR Cr_value IS (

Line 2505: pay_element_entries_f pee

2501: from pay_element_types_f pet,
2502: pay_input_values_f piv,
2503: pay_run_result_values prv,
2504: pay_run_results prr,
2505: pay_element_entries_f pee
2506: where prr.assignment_action_id=p_assignment_action_id
2507: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2508: and prv.input_value_id = piv.input_value_id
2509: and piv.name ='Periods Spread Over'

Line 2540: pay_element_entries_f pee

2536: from pay_element_types_f pet,
2537: pay_input_values_f piv,
2538: pay_run_result_values prv,
2539: pay_run_results prr,
2540: pay_element_entries_f pee
2541: where prr.assignment_action_id=p_assignment_action_id
2542: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2543: and prv.input_value_id = piv.input_value_id
2544: and piv.name ='Total Payment'

Line 2627: pay_element_entries_f pee

2623: from pay_element_types_f pet,
2624: pay_input_values_f piv,
2625: pay_run_result_values prv,
2626: pay_run_results prr,
2627: pay_element_entries_f pee
2628: where prr.assignment_action_id=p_assignment_action_id
2629: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2630: and prv.input_value_id = piv.input_value_id
2631: and piv.name ='Total Payment'

Line 2678: pay_element_entries_f pee,

2674: c_date_earned date) is
2675: select peev.screen_entry_value
2676: from pay_element_types_f pet,
2677: pay_input_values_f piv,
2678: pay_element_entries_f pee,
2679: pay_element_entry_values_f peev
2680: where pee.assignment_id = c_assignment_id
2681: and piv.name ='Pay ETP Components'
2682: and piv.legislation_code='AU'