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.PYGBEXC SQL Statements

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

Line: 63


    *  Select the period of the owning and using action and if they are
    *  the same then the dimension has expired - either a prior period
    *  or a different payroll
    */

   select time_period_id
   into l_user_time_period_id
   from pay_payroll_actions
   where payroll_action_id = p_user_payroll_action_id;

Line: 73


   select time_period_id
   into l_owner_time_period_id
   from pay_payroll_actions
   where payroll_action_id = p_owner_payroll_action_id;

Line: 117


   /* select the start of the financial year - if the owning action is
    * before this or for a different payroll then its expired
   */
   Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
   into l_tax_year_start, l_user_payroll_id
   from per_time_periods    PTP,
        pay_payroll_actions BACT
   where BACT.payroll_action_id = p_user_payroll_action_id
   and   PTP.time_period_id = BACT.time_period_id;

Line: 133


        select  regular_payment_date
        into    l_owning_regular_payment_date
        from    pay_payroll_actions     PACT,
                per_time_periods        PTP
        where   PACT.payroll_action_id  = p_owner_payroll_action_id
        and     PTP.time_period_id      = PACT.time_period_id;

Line: 187


   /* select the start of the financial year - if the owning action is
    * before this or for a different payroll then its expired
   */
   Select to_date('01-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('01-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
   into l_tax_year_start, l_user_payroll_id
   from per_time_periods    PTP,
        pay_payroll_actions BACT
   where BACT.payroll_action_id = p_user_payroll_action_id
   and   PTP.time_period_id = BACT.time_period_id;

Line: 203


        select  regular_payment_date
        into    l_owning_regular_payment_date
        from    pay_payroll_actions     PACT,
                per_time_periods        PTP
        where   PACT.payroll_action_id  = p_owner_payroll_action_id
        and     PTP.time_period_id      = PACT.time_period_id;

Line: 247


   select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( p_user_effective_date,'YYYY'))
             +  decode(sign( p_user_effective_date - to_date('06-04-'
                 || to_char( p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY')
   into l_tax_year_start
   from pay_payroll_actions BACT
   where BACT.payroll_action_id = p_user_payroll_action_id;

Line: 297


	select 	regular_payment_date, BACT.business_group_id
	into 	l_user_regular_payment_date, l_business_group_id
        from 	pay_payroll_actions 	BACT,
		per_time_periods	PTP
	where 	BACT.payroll_action_id	= p_user_payroll_action_id
	and	PTP.time_period_id	= BACT.time_period_id;

Line: 305


	select 	regular_payment_date
	into 	l_owning_regular_payment_date
        from 	pay_payroll_actions 	PACT,
		per_time_periods	PTP
	where 	PACT.payroll_action_id	= p_owner_payroll_action_id
	and	PTP.time_period_id	= PACT.time_period_id;

Line: 373


      Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0) -
          mod(
           fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0),2)
            ),'DD-MM-YYYY') finyear, BACT.payroll_id
      into l_tax_year_start, l_user_payroll_id
      from per_time_periods    PTP,
           pay_payroll_actions BACT
      where BACT.payroll_action_id = p_user_payroll_action_id
      and   PTP.time_period_id = BACT.time_period_id;

Line: 393


      Select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0) -
          mod(
           fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,0,-1),2)
            ),'DD-MM-YYYY') finyear, BACT.payroll_id
       into l_tax_year_start, l_user_payroll_id
       from per_time_periods    PTP,
            pay_payroll_actions BACT
       where BACT.payroll_action_id = p_user_payroll_action_id
       and   PTP.time_period_id = BACT.time_period_id;

Line: 413


   Select min(TP.start_date)
   into l_pay_year_start
   from   per_time_periods TP
   where    TP.payroll_id = l_user_payroll_id
   and    TP.regular_payment_date  >= l_tax_year_start;

Line: 459


        select  regular_payment_date
        into    l_owning_regular_payment_date
        from    pay_payroll_actions     PACT,
                per_time_periods        PTP
        where   PACT.payroll_action_id  = p_owner_payroll_action_id
        and     PTP.time_period_id      = PACT.time_period_id;

Line: 500


   select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions ppa,
        pay_assignment_actions paa
   where ppa.payroll_action_id = paa.payroll_action_id
   and   paa.assignment_action_id = p_asg_action
   and   ppa.payroll_id = p_payroll_id
   and   PTP.time_period_id = ppa.time_period_id;

Line: 540


   select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions ppa,
        pay_assignment_actions paa
   where ppa.payroll_action_id = paa.payroll_action_id
   and   paa.assignment_action_id = p_asg_action
   and   ppa.payroll_id = p_payroll_id
   and   PTP.time_period_id = ppa.time_period_id;

Line: 591


   select to_date('06-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions ppa,
        pay_assignment_actions paa
   where ppa.payroll_action_id = paa.payroll_action_id
   and   paa.assignment_action_id = p_asg_action
   and   ppa.payroll_id = p_payroll_id
   and   PTP.time_period_id = ppa.time_period_id;

Line: 641


   select to_date('01-04-' || to_char( fnd_number.canonical_to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('01-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions ppa,
        pay_assignment_actions paa
   where ppa.payroll_action_id = paa.payroll_action_id
   and   paa.assignment_action_id = p_asg_action
   and   ppa.payroll_id = p_payroll_id
   and   PTP.time_period_id = ppa.time_period_id;