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

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

Line: 40


   select TP.end_date + 1
   into   l_return_val
   from   per_time_periods TP,
          pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_pactid
   and    PACT.payroll_id = TP.payroll_id
   and    p_date between TP.start_date and TP.end_date;

Line: 67


   select TP.end_date + 1
   into   l_return_val
   from   per_time_periods TP,
          pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_pactid
   and    PACT.payroll_id = TP.payroll_id
   and    PACT.date_earned between TP.start_date and TP.end_date;

Line: 111


   select trunc(add_months(PACT.date_earned,1),'MM')
   into   l_return_val
   from   pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_pactid;

Line: 154


   select trunc(add_months(PACT.date_earned,3),'Q')
   into   l_return_val
   from   pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_pactid;

Line: 281


    SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
           to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
            - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
            ,-1,0,1)),'DD-MM-YYYY')
    INTO   l_expiry_date
    FROM   pay_payroll_actions PACT
    WHERE  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 297


    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 309


    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 327


    SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
           to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
            - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
            ,-1,0,1)),'DD-MM-YYYY')
    INTO   l_expiry_date
    FROM   pay_payroll_actions PACT
    WHERE  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 368


  SELECT dimension_name
  FROM   pay_defined_balances pdb
       , pay_balance_dimensions pbd
  WHERE  pdb.balance_dimension_id = pbd.balance_dimension_id
  AND    pdb.defined_balance_id = c_defined_balance_id;

Line: 375


  SELECT ppa.payroll_action_id, ppa.effective_date
  FROM   pay_payroll_actions ppa, pay_assignment_actions paa
  WHERE  ppa.payroll_action_id = paa.payroll_action_id
  AND    paa.assignment_action_id = c_assignment_action_id;

Line: 410


    SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
           to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
            - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
            ,-1,0,1)),'DD-MM-YYYY')
    INTO   l_beg_of_tax_year
    FROM   pay_payroll_actions PACT
    WHERE  PACT.payroll_action_id = l_payroll_action_id;

Line: 429


    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = l_payroll_action_id;

Line: 440


    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = l_payroll_action_id;

Line: 457


    SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
           to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
            - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
            ,-1,0,1)),'DD-MM-YYYY')
    INTO   l_beg_of_tax_year
    FROM   pay_payroll_actions PACT
    WHERE  PACT.payroll_action_id = l_payroll_action_id;

Line: 556


      SELECT  to_date('01-04-'||to_char(fnd_number.canonical_to_number(
              to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
              - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
              ,-1,0,1)),'DD-MM-YYYY') - 1
        INTO  p_expiry_date
        FROM  pay_payroll_actions PACT
       WHERE  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 574


      SELECT  fnd_date.canonical_to_date(org_information11)
        INTO  l_beg_of_fiscal_year
        FROM  pay_payroll_actions PACT,
              hr_organization_information HOI
       WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
         AND  HOI.organization_id = PACT.business_group_id
         AND  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 585


      SELECT  fnd_date.canonical_to_date(org_information11)
        INTO  l_beg_of_fiscal_year
        FROM  pay_payroll_actions PACT,
              hr_organization_information HOI
       WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
         AND  HOI.organization_id = PACT.business_group_id
         AND  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 605


      SELECT  to_date('01-04-'||to_char(fnd_number.canonical_to_number(
              to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
              - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
              ,-1,0,1)),'DD-MM-YYYY') - 1
        INTO  p_expiry_date
        FROM  pay_payroll_actions PACT
       WHERE  PACT.payroll_action_id = p_owner_payroll_action_id;

Line: 661


     SELECT ppa.date_earned,paa.assignment_id
     FROM
     pay_payroll_actions ppa,
     pay_assignment_actions paa
     WHERE paa.assignment_action_id = p_asg_action
     AND   ppa.payroll_action_id=paa.payroll_action_id;