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_PAYMENT_SUMMARY_AMEND dependencies on PAY_ASSIGNMENT_ACTIONS

Line 228: v_next_action_id pay_assignment_actions.assignment_action_id%type;

224: p_end_person_id IN per_all_people_f.person_id%TYPE,
225: p_chunk IN NUMBER)
226: IS
227:
228: v_next_action_id pay_assignment_actions.assignment_action_id%type;
229:
230: v_lst_year_start date ;
231: v_fbt_year_start date ;
232: v_lst_fbt_year_start date ;

Line 273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

269: ,c_start_person_id IN per_all_people_f.person_id%TYPE
270: ,c_end_person_id IN per_all_people_f.person_id%TYPE
271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,c_financial_year IN VARCHAR2
273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
274: IS
275: SELECT DISTINCT paf.assignment_id
276: FROM per_assignments_f paf
277: ,per_people_f ppf

Line 288: ,pay_assignment_actions paa1

284: AND EXISTS
285: ( /* Check if a Datafile is run for this year */
286: SELECT '1'
287: FROM pay_payroll_actions ppa1
288: ,pay_assignment_actions paa1
289: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
290: AND ppa1.report_type = 'AU_PS_DATA_FILE'
291: AND ppa1.report_qualifier = 'AU'
292: AND ppa1.report_category = 'REPORT'

Line 301: ,pay_assignment_actions paa2

297: AND NOT EXISTS
298: ( /* Check if a locked Amended Payment Summary does not exist for this year */
299: SELECT '1'
300: FROM pay_payroll_actions ppa2
301: ,pay_assignment_actions paa2
302: ,pay_action_interlocks pai
303: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
304: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
305: AND ppa2.report_qualifier = 'AU'

Line 319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

315: ,c_start_person_id IN per_all_people_f.person_id%TYPE
316: ,c_end_person_id IN per_all_people_f.person_id%TYPE
317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,c_financial_year IN VARCHAR2
319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
320: IS
321: SELECT DISTINCT paf.assignment_id
322: FROM per_assignments_f paf
323: ,per_people_f ppf

Line 334: ,pay_assignment_actions paa1

330: AND EXISTS
331: ( /* Check if a Datafile is run for this year */
332: SELECT '1'
333: FROM pay_payroll_actions ppa1
334: ,pay_assignment_actions paa1
335: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
336: AND ppa1.report_type = 'AU_PS_DATA_FILE'
337: AND ppa1.report_qualifier = 'AU'
338: AND ppa1.report_category = 'REPORT'

Line 350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

346: ,c_start_person_id IN per_all_people_f.person_id%TYPE
347: ,c_end_person_id IN per_all_people_f.person_id%TYPE
348: ,c_assignment_set_id IN NUMBER
349: ,c_financial_year IN VARCHAR2
350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
351: IS
352: SELECT DISTINCT paf.assignment_id
353: FROM per_assignments_f paf
354: ,per_people_f ppf

Line 368: ,pay_assignment_actions paa1

364: AND EXISTS
365: ( /* Check if a Datafile is run for this year */
366: SELECT '1'
367: FROM pay_payroll_actions ppa1
368: ,pay_assignment_actions paa1
369: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
370: AND ppa1.report_type = 'AU_PS_DATA_FILE'
371: AND ppa1.report_qualifier = 'AU'
372: AND ppa1.report_category = 'REPORT'

Line 381: ,pay_assignment_actions paa2

377: AND NOT EXISTS
378: ( /* Check if a locked Amended Payment Summary does not exist for this year */
379: SELECT '1'
380: FROM pay_payroll_actions ppa2
381: ,pay_assignment_actions paa2
382: ,pay_action_interlocks pai
383: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
384: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
385: AND ppa2.report_qualifier = 'AU'

Line 399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

395: ,c_start_person_id IN per_all_people_f.person_id%TYPE
396: ,c_end_person_id IN per_all_people_f.person_id%TYPE
397: ,c_assignment_set_id IN NUMBER
398: ,c_financial_year IN VARCHAR2
399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
400: IS
401: SELECT DISTINCT paf.assignment_id
402: FROM per_assignments_f paf
403: ,per_people_f ppf

Line 417: ,pay_assignment_actions paa1

413: AND EXISTS
414: ( /* Check if a Datafile is run for this year */
415: SELECT '1'
416: FROM pay_payroll_actions ppa1
417: ,pay_assignment_actions paa1
418: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
419: AND ppa1.report_type = 'AU_PS_DATA_FILE'
420: AND ppa1.report_qualifier = 'AU'
421: AND ppa1.report_category = 'REPORT'

Line 434: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

430: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
431: , c_chunk IN NUMBER
432: ,c_assignment_set_id IN NUMBER
433: ,c_financial_year IN VARCHAR2
434: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
435: IS
436: SELECT /*+ ORDERED
437: USE_NL(PPA, PPR, PAF, HAS)
438: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

Line 465: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */

461: /* Check if a Datafile is run for this year */
462: SELECT /*+ ORDERED
463: USE_NL(PPA1, PAA1)
464: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
465: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
466: '1'
467: FROM pay_payroll_actions ppa1,
468: pay_assignment_actions paa1
469: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'

Line 468: pay_assignment_actions paa1

464: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
465: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
466: '1'
467: FROM pay_payroll_actions ppa1,
468: pay_assignment_actions paa1
469: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
470: AND ppa1.report_qualifier = 'AU'
471: AND ppa1.report_category = 'REPORT'
472: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year

Line 481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)

477: /* Check if a locked Amended Payment Summary does not exist for this year */
478: SELECT /*+ ORDERED
479: USE_NL(PPA2, PAA2, PAI)
480: INDEX(PPA2 PAY_PAYROLL_ACTIONS_N52)
481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)
482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,
485: pay_assignment_actions paa2,

Line 485: pay_assignment_actions paa2,

481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)
482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,
485: pay_assignment_actions paa2,
486: pay_action_interlocks pai
487: WHERE ppa2.report_type = 'AU_PAY_SUMM_AMEND'
488: AND ppa2.report_qualifier = 'AU'
489: AND ppa2.report_category = 'REPORT'

Line 501: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)

497: CURSOR multi_range_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
498: , c_chunk IN NUMBER
499: ,c_assignment_set_id IN NUMBER
500: ,c_financial_year IN VARCHAR2
501: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
502: IS
503: SELECT /*+ ORDERED
504: USE_NL(PPA, PPR, PAF, HAS)
505: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

Line 532: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */

528: /* Check if a Datafile is run for this year */
529: SELECT /*+ ORDERED
530: USE_NL(PPA1, PAA1)
531: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
532: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
533: '1'
534: FROM pay_payroll_actions ppa1,
535: pay_assignment_actions paa1
536: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'

Line 535: pay_assignment_actions paa1

531: INDEX(PPA1 PAY_PAYROLL_ACTIONS_N52)
532: INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_N51) */
533: '1'
534: FROM pay_payroll_actions ppa1,
535: pay_assignment_actions paa1
536: WHERE ppa1.report_type = 'AU_PS_DATA_FILE'
537: AND ppa1.report_qualifier = 'AU'
538: AND ppa1.report_category = 'REPORT'
539: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa1.legislative_parameters) = c_financial_year

Line 547: SELECT pay_assignment_actions_s.nextval

543: ;
544:
545: CURSOR next_action_id
546: IS
547: SELECT pay_assignment_actions_s.nextval
548: FROM dual;
549:
550: BEGIN
551:

Line 1166: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1162: --------------------------------------------------------------------
1163: */
1164:
1165: PROCEDURE find_new_missing_items
1166: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1167: ,p_old_count IN NUMBER
1168: ,p_all_tab_new IN archive_db_tab
1169: ,p_new_count IN NUMBER)
1170: IS

Line 1174: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)

1170: IS
1171:
1172: /* Bug 8315198 - Modified cursor to include X_ETP_DEATH_BENEFIT_TFN and X_LUMP_SUM_A_PAYMENT_TYPE DB items */
1173: CURSOR get_archived_user_entities
1174: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
1175: IS
1176: SELECT fue.user_entity_name
1177: FROM ff_archive_items fae,
1178: ff_user_entities fue

Line 1318: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1314: --------------------------------------------------------------------
1315: */
1316:
1317: PROCEDURE slot_items_build_archive_list
1318: (p_archive_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1319: ,p_all_tab_new IN archive_db_tab)
1320: IS
1321:
1322: CURSOR csr_get_value(c_user_entity_name VARCHAR2,

Line 1323: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1319: ,p_all_tab_new IN archive_db_tab)
1320: IS
1321:
1322: CURSOR csr_get_value(c_user_entity_name VARCHAR2,
1323: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1324: IS
1325: SELECT fai.value
1326: ,fdi.data_type
1327: FROM ff_archive_items fai,

Line 2069: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

2065: --------------------------------------------------------------------
2066: */
2067:
2068: PROCEDURE archive_db_items_tab(
2069: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2070: ,p_db_item_tab IN archive_db_tab
2071: )
2072: IS
2073:

Line 2160: (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

2156: flags.
2157: --------------------------------------------------------------------
2158: */
2159: PROCEDURE modify_and_archive_code
2160: (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2161: ,p_effective_date IN DATE
2162: ,p_all_tab_new IN archive_db_tab)
2163: IS
2164:

Line 2168: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE

2164:
2165: l_procedure VARCHAR2(80);
2166:
2167: CURSOR get_orig_archive_id
2168: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE
2169: ,c_fin_year VARCHAR2
2170: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
2171: )
2172: IS

Line 2170: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE

2166:
2167: CURSOR get_orig_archive_id
2168: (c_assignmenr_id pay_assignment_actions.assignment_id%TYPE
2169: ,c_fin_year VARCHAR2
2170: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
2171: )
2172: IS
2173: SELECT selfplock.locked_action_id
2174: FROM pay_assignment_actions mpaa

Line 2174: FROM pay_assignment_actions mpaa

2170: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
2171: )
2172: IS
2173: SELECT selfplock.locked_action_id
2174: FROM pay_assignment_actions mpaa
2175: ,pay_payroll_actions mppa
2176: ,pay_action_interlocks mplock
2177: ,pay_action_interlocks selfplock
2178: WHERE mpaa.assignment_id = c_assignmenr_id

Line 2200: FROM pay_assignment_actions paa

2196: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
2197: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
2198: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters)
2199: , pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters)
2200: FROM pay_assignment_actions paa
2201: , pay_payroll_actions ppa
2202: WHERE paa.assignment_action_id = c_assignment_action_id
2203: AND ppa.payroll_action_id = paa.payroll_action_id ;
2204:

Line 2211: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE

2207: SELECT fc.context_id
2208: FROM ff_contexts fc
2209: WHERE fc.context_name = c_context_name;
2210:
2211: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
2212: ,c_context_id ff_contexts.context_id%TYPE)
2213: IS
2214: SELECT COUNT(*)
2215: FROM ff_archive_items fai,

Line 2231: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

2227: ,'X_ETP4_PAYMENT_SUMMARY_TYPE'
2228: ,'X_FW1_PAYMENT_SUMMARY_TYPE' /*bug9147430*/
2229: ,'X_FW2_PAYMENT_SUMMARY_TYPE'); /*bug9147430*/
2230:
2231: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
2232: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
2233: l_registered_employer hr_organization_units.organization_id%TYPE;
2234: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
2235: l_year_start pay_payroll_Actions.effective_date%TYPE;

Line 2240: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;

2236: l_year_end pay_payroll_actions.effective_date%TYPE;
2237: l_employee_type per_all_people_f.current_Employee_Flag%TYPE;
2238: l_lst_yr_term varchar2(10);
2239: l_fin_year VARCHAR2(20);
2240: l_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
2241:
2242: l_eit_value VARCHAR2(10);
2243:
2244: l_new_count NUMBER;