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_FR_DADS_F_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 99


  l_s30_select         varchar2(1000);

Line: 145


    Select action_context_id
      from pay_action_information
     where action_context_type = 'PA'
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_information1 = 'S10.G01.00.004'
       and action_information4 = p_dads_reference;

Line: 154


  Select action_information1 rubric_code,
         hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
         action_information4 file_value,
         action_information5 user_value,
         action_information9 usage
    from pay_action_information
   where action_context_id = c_payroll_action_id
     and action_context_type = 'PA'
     and action_information_category = 'FR_DADS_FILE_DATA'
     and action_information1 like 'S10%'
     and action_information3 = p_issuing_establishment
   order by action_information1;

Line: 170


    Select distinct action_information3 company_id,
           action_information4          comp_name
      from pay_action_information
     where action_information1 = 'S20.G01.00.002'
       and action_context_id = c_payroll_action_id
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_context_type = 'PA'
       order by action_information4;

Line: 182


  Select action_information1 rubric_code,
         hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
         action_information4 file_value,
         action_information5 user_value,
         action_information7 extra_info,
         action_information9 usage
  from pay_action_information
  where action_context_id = c_payroll_action_id
  and action_context_type = 'PA'
  and action_information_category = 'FR_DADS_FILE_DATA'
  and action_information1 like 'S20%'
  and action_information3 = c_company_id
  order by action_information1;

Line: 199


    Select action_information1 rubric_code,
           hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
           action_information4 file_value,
           action_information5 user_value,
           action_information9 usage
      from pay_action_information
     where action_context_id = c_asg_action_id
       and action_context_type = 'AAP'
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_information1 like 'S30%'
       and action_information3 = c_company_id
    order by action_information1;

Line: 216


    Select distinct action_information8 ID2
      from pay_action_information
     where action_context_id = c_asg_action_id
       and action_context_type = 'AAP'
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_information1 like 'S41%'
       and action_information3 = c_company_id
       order by action_information8;

Line: 229


    Select action_information1 rubric_code,
           hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
           action_information4 file_value,
           action_information5 user_value,
           action_information9 usage
      from pay_action_information
     where action_context_id = c_asg_action_id
       and action_context_type = 'AAP'
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_information1 like 'S41%'
       and action_information3 = c_company_id
       and action_information8 = c_s41_id2
    order by action_information1;

Line: 245


  select distinct action_information3 estab_id
    from pay_action_information
   where action_context_id = c_payroll_action_id
     and action_context_type = 'PA'
     and action_information_category = 'FR_DADS_FILE_DATA'
     and action_information1 like 'S80%';

Line: 255


    Select action_information1 rubric_code,
           hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
           action_information4 file_value,
           action_information5 user_value,
           action_information9 usage
      from pay_action_information
     where action_context_id = c_payroll_action_id
       and action_context_type = 'PA'
       and action_information_category = 'FR_DADS_FILE_DATA'
       and action_information1 like 'S80%'
       and action_information3 = c_estab_id
    order by action_information1;

Line: 270


      Select action_information1 rubric_code,
             hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
             action_information4 file_value,
             action_information5 user_value,
             action_information9 usage
        from pay_action_information
       where action_context_id = c_payroll_action_id
         and action_context_type = 'PA'
         and action_information_category = 'FR_DADS_FILE_DATA'
         and action_information1 like 'S90%'
       order by action_information1;

Line: 284


    Select issue.action_information4 issue_estab,
           cre.action_information5   cre_estab_name
      from pay_action_information issue,
           pay_action_information cre
     where issue.action_context_id = c_payroll_action_id
       and issue.action_context_type = 'PA'
       and issue.action_information_category = 'FR_DADS_FILE_DATA'
       and issue.action_information1 = 'S10.G01.00.002'
       --
       and cre.action_context_id(+) = issue.action_context_id
       and cre.action_context_type(+) = 'PA'
       and cre.action_information_category(+) = 'FR_DADS_REPORT_DATA'
       and cre.action_information1(+) = 'S10'
       and cre.action_information3(+) = P_ISSUING_ESTABLISHMENT;

Line: 302


  Select comp.action_information4 comp_name,
         nvl(cre_s20.action_information5,null) cre_name,
         nvl(hq.action_information7,null)   hq_name,
         nvl(fisc.action_information4,null) fisc_name
  from pay_action_information comp,
       pay_action_information cre_s20,
       pay_action_information hq,
       pay_action_information fisc
  where comp.action_context_id = c_payroll_action_id
    and comp.action_context_type = 'PA'
    and comp.action_information_category = 'FR_DADS_FILE_DATA'
    and comp.action_information1 = 'S20.G01.00.002'
    and comp.action_information3 = c_company_id
    --
    and cre_s20.action_context_id(+) = comp.action_context_id
    and cre_s20.action_context_type(+) = 'PA'
    and cre_s20.action_information_category(+) = 'FR_DADS_REPORT_DATA'
    and cre_s20.action_information1 (+)= 'S20'
    and cre_s20.action_information3(+) = comp.action_information3
    --
    and hq.action_context_id(+) = comp.action_context_id
    and hq.action_context_type(+) = 'PA'
    and hq.action_information_category(+) = 'FR_DADS_FILE_DATA'
    and hq.action_information1 (+)= 'S20.G01.00.008'
    and hq.action_information3(+) = comp.action_information3
    --
    and fisc.action_context_id(+) = comp.action_context_id
    and fisc.action_context_type(+) = 'PA'
    and fisc.action_information_category(+) = 'FR_DADS_FILE_DATA'
    and fisc.action_information1(+)='S20.G01.00.011'
    and fisc.action_information3(+) = comp.action_information3;

Line: 337


  Select nvl(title.action_information5,null)      emp_title,
         nvl(title.action_information8 ,null)     emp_number,
         nvl(first_name.action_information4,null) emp_first,
         nvl(last_name.action_information4,null)  emp_last
  from pay_action_information title,
       pay_action_information first_name,
       pay_action_information last_name
  where title.action_context_id = c_asg_action_id
    and title.action_context_type = 'AAP'
    and title.action_information_category = 'FR_DADS_FILE_DATA'
    and title.action_information1 = 'S30.G01.00.007'
    and title.action_information3 = c_company_id
    --
    and first_name.action_context_id = c_asg_action_id
    and first_name.action_context_type = 'AAP'
    and first_name.action_information_category = 'FR_DADS_FILE_DATA'
    and first_name.action_information1 = 'S30.G01.00.003'
    and first_name.action_information3 = c_company_id
    --
    and last_name.action_context_id = c_asg_action_id
    and last_name.action_context_type = 'AAP'
    and last_name.action_information_category = 'FR_DADS_FILE_DATA'
    and last_name.action_information1 = 'S30.G01.00.004'
    and last_name.action_information3 = c_company_id;

Line: 366


  Select hou_tl_estab.name         emp_estab,
         start_period.action_information4 period_start,
         end_period.action_information4   period_end
  from pay_action_information estab,
       pay_action_information start_period,
       pay_action_information end_period,
       hr_all_organization_units_tl hou_tl_estab
  where estab.action_context_id = c_asg_action_id
    and estab.action_context_type = 'AAP'
    and estab.action_information_category = 'FR_DADS_FILE_DATA'
    and estab.action_information1 = 'S41.G01.00.005'
    and estab.action_information3 = c_company_id
    and estab.action_information8 = c_s41_id2
    and hou_tl_estab.organization_id(+) = estab.action_information7
    and hou_tl_estab.language(+) = userenv('LANG')
    --
    and start_period.action_context_id = c_asg_action_id
    and start_period.action_context_type = 'AAP'
    and start_period.action_information_category = 'FR_DADS_FILE_DATA'
    and start_period.action_information1 = 'S41.G01.00.001'
    and start_period.action_information3 = c_company_id
    and start_period.action_information8 = c_s41_id2
    --
    and end_period.action_context_id = c_asg_action_id
    and end_period.action_context_type = 'AAP'
    and end_period.action_information_category = 'FR_DADS_FILE_DATA'
    and end_period.action_information1 = 'S41.G01.00.003'
    and end_period.action_information3 = c_company_id
    and end_period.action_information8 = c_s41_id2;

Line: 399


  Select action_information4 estab_name
  from pay_action_information
  where action_context_id = c_payroll_action_id
    and action_context_type = 'PA'
    and action_information_category = 'FR_DADS_FILE_DATA'
    and action_information1 = 'S80.G01.00.002'
    and action_information3 = c_estab_id;

Line: 614


         l_s30_select := 'Select pasac.assignment_action_id
	                 from pay_assignment_actions pasac,
	                      pay_action_information pacinfo_1';

Line: 645


         OPEN ref_csr_asg_action FOR l_s30_select||l_s30_cond_from||l_s30_where||l_s30_cond_where||l_s30_order_by||l_s30_cond_order_by;

Line: 853


l_s30_select            varchar2(1000);

Line: 905


  Select action_context_id
    from pay_action_information
   where action_context_type = 'PA'
     and action_information_category = 'FR_DADS_FILE_DATA'
     and action_information1 = 'S10.G01.00.004'
     and action_information4 = p_dads_reference;

Line: 914


   Select action_information1 rubric_code,
	  action_information2 error_warning,
	  action_information6 error_warning_message
    from pay_action_information
    where action_context_id = c_payroll_action_id
      and action_context_type = 'PA'
      and action_information_category = 'FR_DADS_FILE_DATA'
      and action_information1 like 'S10%'
      and action_information3 = p_issuing_establishment
      and action_information6 is not null
   order by action_information1;

Line: 929


    Select distinct action_information3 company_id,
           action_information4          comp_name
   from  pay_action_information
   where action_information1 = 'S20.G01.00.002'
     and action_context_id = c_payroll_action_id
     and action_information_category = 'FR_DADS_FILE_DATA'
     and action_context_type = 'PA'
     order by action_information4;

Line: 941


                                   Select action_information1 rubric_code,
		        		  action_information2 error_warning,
			        	  action_information6 error_warning_message
			           from pay_action_information
                	           where action_context_id = c_payroll_action_id
	                           and action_context_type = 'PA'
	                           and action_information_category = 'FR_DADS_FILE_DATA'
	                           and action_information1 like 'S20%'
                                   and action_information3 = c_company_id
		 	           and action_information6 is not null
                                 order by action_information1;

Line: 956


                                         Select action_information1 rubric_code,
	                  		        action_information2 error_warning,
			        	        action_information6 error_warning_message
              			         from pay_action_information
                	                 where action_context_id = c_asg_action_id
	                                 and action_context_type = 'AAP'
	                                 and action_information_category = 'FR_DADS_FILE_DATA'
	                                 and action_information1 like 'S30%'
	                                 and action_information3 = c_company_id
		 	                 and action_information6 is not null
                                       order by action_information1;

Line: 972


  Select distinct action_information8 ID2
    from pay_action_information
   where action_context_id = c_asg_action_id
     and action_context_type = 'AAP'
     and action_information_category = 'FR_DADS_FILE_DATA'
     and action_information1 like 'S41%'
     and action_information3 = c_company_id
     order by action_information8;

Line: 985


                                            Select action_information1 rubric_code,
	                       		           action_information2 error_warning,
			        	           action_information6 error_warning_message
              			            from pay_action_information
                	                    where action_context_id = c_asg_action_id
	                                    and action_context_type = 'AAP'
	                                    and action_information_category = 'FR_DADS_FILE_DATA'
	                                    and action_information1 like 'S41%'
	                                    and action_information3 = c_company_id
					    and action_information8 = c_s41_id2
		 	                    and action_information6 is not null
                                           order by action_information1;

Line: 999


select distinct action_information3 estab_id
  from pay_action_information
 where action_context_id = c_payroll_action_id
   and action_context_type = 'PA'
   and action_information_category = 'FR_DADS_FILE_DATA'
   and action_information1 like 'S80%';

Line: 1009


                                  Select action_information1 rubric_code,
                    		         action_information2 error_warning,
		        	         action_information6 error_warning_message
      			          from pay_action_information
        	                  where action_context_id = c_payroll_action_id
                                  and action_context_type = 'PA'
                                  and action_information_category = 'FR_DADS_FILE_DATA'
                                  and action_information1 like 'S80%'
                                  and action_information3 = c_estab_id
	 	                  and action_information6 is not null
                                 order by action_information1;

Line: 1023


                            Select action_information1 rubric_code,
             		           action_information2 error_warning,
		        	   action_information6 error_warning_message
      			    from pay_action_information
        	            where action_context_id = c_payroll_action_id
                            and action_context_type = 'PA'
                            and action_information_category = 'FR_DADS_FILE_DATA'
                            and action_information1 like 'S90%'
	 	            and action_information6 is not null
                         order by action_information1;

Line: 1036


  Select issue.action_information4 issue_estab,
         cre.action_information5   cre_estab_name
    from pay_action_information issue,
         pay_action_information cre
   where issue.action_context_id = c_payroll_action_id
     and issue.action_context_type = 'PA'
     and issue.action_information_category = 'FR_DADS_FILE_DATA'
     and issue.action_information1 = 'S10.G01.00.002'
     --
     and cre.action_context_id(+) = issue.action_context_id
     and cre.action_context_type(+) = 'PA'
     and cre.action_information_category(+) = 'FR_DADS_REPORT_DATA'
     and cre.action_information1(+) = 'S10'
     and cre.action_information3(+) = P_ISSUING_ESTABLISHMENT;

Line: 1054


  Select comp.action_information4 comp_name,
         nvl(cre_s20.action_information5,null) cre_name,
         nvl(hq.action_information7,null)   hq_name,
         nvl(fisc.action_information4,null) fisc_name
  from pay_action_information comp,
       pay_action_information cre_s20,
       pay_action_information hq,
       pay_action_information fisc
  where comp.action_context_id = c_payroll_action_id
    and comp.action_context_type = 'PA'
    and comp.action_information_category = 'FR_DADS_FILE_DATA'
    and comp.action_information1 = 'S20.G01.00.002'
    and comp.action_information3 = c_company_id
    --
    and cre_s20.action_context_id(+) = comp.action_context_id
    and cre_s20.action_context_type(+) = 'PA'
    and cre_s20.action_information_category(+) = 'FR_DADS_REPORT_DATA'
    and cre_s20.action_information1 (+)= 'S20'
    and cre_s20.action_information3(+) = comp.action_information3
    --
    and hq.action_context_id(+) = comp.action_context_id
    and hq.action_context_type(+) = 'PA'
    and hq.action_information_category(+) = 'FR_DADS_FILE_DATA'
    and hq.action_information1 (+)= 'S20.G01.00.008'
    and hq.action_information3(+) = comp.action_information3
    --
    and fisc.action_context_id(+) = comp.action_context_id
    and fisc.action_context_type(+) = 'PA'
    and fisc.action_information_category(+) = 'FR_DADS_FILE_DATA'
    and fisc.action_information1(+)='S20.G01.00.011'
    and fisc.action_information3(+) = comp.action_information3;

Line: 1089


  Select nvl(title.action_information5,null)      emp_title,
         nvl(title.action_information8 ,null)     emp_number,
         nvl(first_name.action_information4,null) emp_first,
         nvl(last_name.action_information4,null)  emp_last
  from pay_action_information title,
       pay_action_information first_name,
       pay_action_information last_name
  where title.action_context_id = c_asg_action_id
    and title.action_context_type = 'AAP'
    and title.action_information_category = 'FR_DADS_FILE_DATA'
    and title.action_information1 = 'S30.G01.00.007'
    and title.action_information3 = c_company_id
    --
    and first_name.action_context_id = c_asg_action_id
    and first_name.action_context_type = 'AAP'
    and first_name.action_information_category = 'FR_DADS_FILE_DATA'
    and first_name.action_information1 = 'S30.G01.00.003'
    and first_name.action_information3 = c_company_id
    --
    and last_name.action_context_id = c_asg_action_id
    and last_name.action_context_type = 'AAP'
    and last_name.action_information_category = 'FR_DADS_FILE_DATA'
    and last_name.action_information1 = 'S30.G01.00.004'
    and last_name.action_information3 = c_company_id;

Line: 1118


Select hou_tl_estab.name         emp_estab,
       start_period.action_information4 period_start,
       end_period.action_information4   period_end
from pay_action_information estab,
     pay_action_information start_period,
     pay_action_information end_period,
     hr_all_organization_units_tl hou_tl_estab
where estab.action_context_id = c_asg_action_id
  and estab.action_context_type = 'AAP'
  and estab.action_information_category = 'FR_DADS_FILE_DATA'
  and estab.action_information1 = 'S41.G01.00.005'
  and estab.action_information3 = c_company_id
  and estab.action_information8 = c_s41_id2
  and hou_tl_estab.organization_id(+) = estab.action_information7
  and hou_tl_estab.language(+) = userenv('LANG')
  --
  and start_period.action_context_id = c_asg_action_id
  and start_period.action_context_type = 'AAP'
  and start_period.action_information_category = 'FR_DADS_FILE_DATA'
  and start_period.action_information1 = 'S41.G01.00.001'
  and start_period.action_information3 = c_company_id
  and start_period.action_information8 = c_s41_id2
  --
  and end_period.action_context_id = c_asg_action_id
  and end_period.action_context_type = 'AAP'
  and end_period.action_information_category = 'FR_DADS_FILE_DATA'
  and end_period.action_information1 = 'S41.G01.00.003'
  and end_period.action_information3 = c_company_id
  and end_period.action_information8 = c_s41_id2;

Line: 1151


Select action_information4 estab_name
from pay_action_information
where action_context_id = c_payroll_action_id
  and action_context_type = 'PA'
  and action_information_category = 'FR_DADS_FILE_DATA'
  and action_information1 = 'S80.G01.00.002'
  and action_information3 = c_estab_id;

Line: 1328


      l_s30_select := 'Select pasac.assignment_action_id
      	               from pay_assignment_actions pasac,
      	                    pay_action_information pacinfo_1';

Line: 1359


      OPEN ref_csr_asg_action FOR l_s30_select||l_s30_cond_from||l_s30_where||l_s30_cond_where||l_s30_order_by||l_s30_cond_order_by;