[Home] [Help]
1849: pay_payroll_actions appa,
1850: pay_payroll_actions appa2,
1851: pay_assignment_actions act,
1852: pay_assignment_actions act1,
1853: pay_action_interlocks pai,
1854: per_all_assignments_f as1
1855: WHERE ppa.payroll_action_id = p_pact_id
1856: AND appa.consolidation_set_id = p_consolidation_id
1857: AND appa.effective_date BETWEEN
1873: AND act1.payroll_action_id = appa2.payroll_action_id
1874: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1875: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1876: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1877: FROM pay_action_interlocks pai1,
1878: pay_assignment_actions act2,
1879: pay_payroll_actions appa3
1880: WHERE pai1.locked_action_id = act.assignment_action_id
1881: AND act2.assignment_action_id = pai1.locking_action_id
1899: pay_payroll_actions appa,
1900: pay_payroll_actions appa2,
1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,
1903: pay_action_interlocks pai,
1904: per_all_assignments_f as1,
1905: pay_population_ranges ppr
1906: WHERE ppa.payroll_action_id = p_pact_id
1907: AND appa.consolidation_set_id = p_consolidation_id
1925: AND act1.payroll_action_id = appa2.payroll_action_id
1926: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1927: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1928: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1929: FROM pay_action_interlocks pai1,
1930: pay_assignment_actions act2,
1931: pay_payroll_actions appa3
1932: WHERE pai1.locked_action_id = act.assignment_action_id
1933: AND act2.assignment_action_id = pai1.locking_action_id
2070: ppaa.effective_date pre_effective_date,
2071: paa.date_earned date_earned,
2072: paa.time_period_id time_period_id,
2073: paa.action_type action_type /*Added for the bug 7502055*/
2074: FROM pay_action_interlocks pre,
2075: pay_action_interlocks pay,
2076: pay_payroll_actions paa,
2077: pay_payroll_actions ppaa,
2078: pay_assignment_actions assact,
2071: paa.date_earned date_earned,
2072: paa.time_period_id time_period_id,
2073: paa.action_type action_type /*Added for the bug 7502055*/
2074: FROM pay_action_interlocks pre,
2075: pay_action_interlocks pay,
2076: pay_payroll_actions paa,
2077: pay_payroll_actions ppaa,
2078: pay_assignment_actions assact,
2079: pay_assignment_actions passact
2671: p_element_type_3 IN VARCHAR) IS
2672:
2673: SELECT /*+ leading(lck,paa2) */ lck.locking_action_id ACTION_CONTEXT_ID, pet.element_type_id, piv.input_value_id, pai.action_information4 NARRATIVE, pai.action_information5 PAYMENT_TYPE,
2674: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value
2675: FROM pay_action_interlocks lck, -- archive action locking prepayment
2676: pay_assignment_actions paa1, -- prepayment action
2677: pay_assignment_actions paa2, -- archive action
2678: pay_payroll_actions ppa, -- prepayment
2679: pay_action_information pai, -- archived element/input value definition
2676: pay_assignment_actions paa1, -- prepayment action
2677: pay_assignment_actions paa2, -- archive action
2678: pay_payroll_actions ppa, -- prepayment
2679: pay_action_information pai, -- archived element/input value definition
2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2681: pay_assignment_actions paa, -- payroll run/quickpay action
2682: pay_payroll_actions ppa1, -- payroll run/quickpay action
2683: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2684: pay_input_values_f piv, -- "Pay values" of type Money