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_RECON_SUMMARY dependencies on PER_ASSIGNMENTS_F

Line 671: /* Bug: 3603495 - Performance Fix - Introduced per_assignments_f and its joins in the following cursor */

667: j_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
668: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
669: /* Changes for 9147438 end */
670:
671: /* Bug: 3603495 - Performance Fix - Introduced per_assignments_f and its joins in the following cursor */
672: /* Bug: 4015571 - Modified cursor c_max_asg_action_id - Modified action_type join in sub query
673: to restrict the max action_sequence fetch to types 'Q','R','B','I'
674: Bug: 4256506 - Changed cursor c_max_asg_action_id. Merged sub query to fetch max action sequemce in main query. Done for
675: better performance.

Line 687: , per_assignments_f paf

683: c_year_end date ) is
684: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
685: from pay_assignment_actions paa
686: , pay_payroll_actions ppa
687: , per_assignments_f paf
688: where paa.assignment_id = paf.assignment_id
689: and paf.assignment_id = c_assignment_id
690: and paa.assignment_id = c_assignment_id
691: and ppa.payroll_action_id = paa.payroll_action_id

Line 2927: l_asgid per_assignments_f.assignment_id%type;

2923: p_end_person_id in per_all_people_f.person_id%type,
2924: p_chunk in number) is
2925:
2926:
2927: l_asgid per_assignments_f.assignment_id%type;
2928: l_next_action_id pay_assignment_actions.assignment_action_id%type;
2929:
2930:
2931: l_lst_yr_start date;

Line 2984: INDEX(paa per_assignments_f_N12)

2980: )
2981: is
2982: SELECT /*+ INDEX(pap per_people_f_pk)
2983: INDEX(rppa pay_payroll_actions_pk)
2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa

Line 2988: ,per_assignments_f paa

2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa
2989: ,pay_payroll_actions rppa
2990: ,per_periods_of_service pps
2991: where rppa.payroll_action_id = p_payroll_action_id
2992: and pap.person_id between p_start_person_id and p_end_person_id

Line 3002: FROM per_assignments_f iipaf

2998: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
2999: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
3000: /* Start of Bug: 3872211 */
3001: and paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
3002: FROM per_assignments_f iipaf
3003: WHERE iipaf.assignment_id = paa.assignment_id
3004: AND iipaf.effective_end_date >= p_fbt_year_start
3005: AND iipaf.effective_start_date <= p_fin_year_end
3006: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */

Line 3011: per_assignments_f paaf

3007: and paa.payroll_id like p_payroll_id
3008: /* End of Bug: 3872211 */
3009: AND EXISTS (SELECT /*+ ORDERED */''
3010: FROM
3011: per_assignments_f paaf
3012: ,pay_assignment_actions rpac
3013: ,pay_payroll_actions rppa
3014: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3015: and rppa.action_type in ('R','Q','B','I')

Line 3026: per_assignments_f paaf

3022: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
3023: UNION
3024: SELECT /*+ ORDERED */''
3025: FROM
3026: per_assignments_f paaf
3027: ,pay_assignment_actions rpac
3028: ,pay_payroll_actions rppa
3029: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3030: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end

Line 3071: ,per_assignments_f paa

3067: )
3068: IS
3069: SELECT paa.assignment_id
3070: from per_people_f pap
3071: ,per_assignments_f paa
3072: ,pay_payroll_actions rppa
3073: ,per_periods_of_service pps
3074: ,pay_population_ranges ppr
3075: where rppa.payroll_action_id = p_payroll_action_id

Line 3090: FROM per_assignments_f iipaf

3086: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
3087: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
3088: /* Start of Bug: 3872211 */
3089: and paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
3090: FROM per_assignments_f iipaf
3091: WHERE iipaf.assignment_id = paa.assignment_id
3092: AND IIPAF.PERSON_ID = PAA.PERSON_ID
3093: AND iipaf.effective_end_date >= p_fbt_year_start
3094: AND iipaf.effective_start_date <= p_fin_year_end

Line 3100: per_assignments_f paaf

3096: and paa.payroll_id like p_payroll_id
3097: /* End of Bug: 3872211 */
3098: AND EXISTS (SELECT /*+ ORDERED */''
3099: FROM
3100: per_assignments_f paaf
3101: ,pay_assignment_actions rpac
3102: ,pay_payroll_actions rppa
3103: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3104: and rppa.action_type in ('R','Q','B','I')

Line 3115: per_assignments_f paaf

3111: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
3112: UNION
3113: SELECT /*+ ORDERED */''
3114: FROM
3115: per_assignments_f paaf
3116: ,pay_assignment_actions rpac
3117: ,pay_payroll_actions rppa
3118: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3119: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end

Line 3147: INDEX(paa per_assignments_f_fk1)

3143: p_lst_year_start date
3144: )
3145: is
3146: SELECT /*+ INDEX(pap per_people_f_pk)
3147: INDEX(paa per_assignments_f_fk1)
3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id

Line 3148: INDEX(paa per_assignments_f_N12)

3144: )
3145: is
3146: SELECT /*+ INDEX(pap per_people_f_pk)
3147: INDEX(paa per_assignments_f_fk1)
3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap

Line 3153: ,per_assignments_f paa

3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa
3154: ,pay_payroll_actions rppa
3155: ,per_periods_of_service pps
3156: where rppa.payroll_action_id = p_payroll_action_id
3157: and pap.person_id between p_start_person_id and p_end_person_id

Line 3168: From per_assignments_f iipaf

3164: and nvl(pps.actual_termination_date, p_lst_year_start) >= p_lst_year_start
3165: and p_fin_year_end between pap.effective_start_date and pap.effective_end_date
3166: -- and least(nvl(pps.actual_termination_date,p_fin_year_end),p_fin_year_end) between paa.effective_start_date and paa.effective_end_date
3167: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
3168: From per_assignments_f iipaf
3169: WHERE iipaf.assignment_id = paa.assignment_id
3170: and iipaf.effective_end_date >= p_fbt_year_start
3171: and iipaf.effective_start_date <= p_fin_year_end
3172: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */

Line 3176: per_assignments_f paaf

3172: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
3173: and paa.payroll_id like p_payroll_id
3174: AND EXISTS (SELECT /*+ ORDERED */''
3175: FROM
3176: per_assignments_f paaf
3177: ,pay_assignment_actions rpac
3178: ,pay_payroll_actions rppa
3179: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3180: and rppa.action_type in ('R','Q','B','I')

Line 3191: per_assignments_f paaf

3187: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
3188: UNION
3189: SELECT /*+ ORDERED */''
3190: FROM
3191: per_assignments_f paaf
3192: ,pay_assignment_actions rpac
3193: ,pay_payroll_actions rppa
3194: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3195: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end