364: , per_time_periods ptp_all
365: , pay_assignment_actions paa_all
366: , pay_payroll_actions ppa_all
367: , pay_run_results prr_ls
368: , pay_run_result_values target
369: , pay_balance_feeds_f feed
370: , pay_run_result_values process
371: , pay_input_values_f process_iv
372: , pay_input_values_f piv
366: , pay_payroll_actions ppa_all
367: , pay_run_results prr_ls
368: , pay_run_result_values target
369: , pay_balance_feeds_f feed
370: , pay_run_result_values process
371: , pay_input_values_f process_iv
372: , pay_input_values_f piv
373: WHERE paa.assignment_action_id = p_assignment_id
374: AND ppa.payroll_action_id = paa.payroll_action_id
7222: , per_time_periods ptp_all
7223: , pay_assignment_actions paa_all
7224: , pay_payroll_actions ppa_all
7225: , pay_run_results prr_ls
7226: , pay_run_result_values target
7227: , pay_balance_feeds_f feed
7228: , pay_run_result_values process
7229: , pay_input_values_f process_iv
7230: , pay_balance_types pbt
7224: , pay_payroll_actions ppa_all
7225: , pay_run_results prr_ls
7226: , pay_run_result_values target
7227: , pay_balance_feeds_f feed
7228: , pay_run_result_values process
7229: , pay_input_values_f process_iv
7230: , pay_balance_types pbt
7231: , pay_element_types_f pet
7232: , pay_input_values_f piv
8286: Select count(*)
8287: into l_lmsm_proc_cnt
8288: from
8289: pay_balance_feeds_f FEED,
8290: pay_run_result_values TARGET,
8291: pay_run_results RR,
8292: pay_payroll_actions PACT,
8293: pay_assignment_actions ASSACT,
8294: pay_payroll_actions BACT,
8354: Select count(*)
8355: into l_ret_lmsm_proc_cnt
8356: from
8357: pay_balance_feeds_f FEED,
8358: pay_run_result_values TARGET,
8359: pay_run_results RR,
8360: pay_payroll_actions PACT,
8361: pay_assignment_actions ASSACT,
8362: pay_payroll_actions BACT,