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_GB_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1851: pay_assignment_actions act,

1847: act1.assignment_action_id prepaid_action_id
1848: FROM pay_payroll_actions ppa,
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

Line 1852: pay_assignment_actions act1,

1848: FROM pay_payroll_actions ppa,
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

Line 1878: pay_assignment_actions act2,

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
1882: AND act2.payroll_action_id = appa3.payroll_action_id

Line 1901: pay_assignment_actions act,

1897: act1.assignment_action_id prepaid_action_id
1898: FROM pay_payroll_actions ppa,
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

Line 1902: pay_assignment_actions act1,

1898: FROM pay_payroll_actions ppa,
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

Line 1930: pay_assignment_actions act2,

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
1934: AND act2.payroll_action_id = appa3.payroll_action_id

Line 1994: SELECT pay_assignment_actions_s.NEXTVAL

1990: FOR csr_rec IN csr_range_pre_assignments(pactid, l_payroll_id, l_consolidation_set)
1991: LOOP
1992: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1993: --
1994: SELECT pay_assignment_actions_s.NEXTVAL
1995: INTO l_actid
1996: FROM dual;
1997: --
1998: -- Create the archive assignment action for master action

Line 2031: SELECT pay_assignment_actions_s.NEXTVAL

2027: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2028:
2029: THEN
2030:
2031: SELECT pay_assignment_actions_s.NEXTVAL
2032: INTO l_actid
2033: FROM dual;
2034:
2035: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2078: pay_assignment_actions assact,

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
2080: WHERE pre.locked_action_id = pay.locking_action_id
2081: AND pre.locking_action_id = p_locking_action_id
2082: AND pre.locked_action_id = passact.assignment_action_id

Line 2079: pay_assignment_actions passact

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
2080: WHERE pre.locked_action_id = pay.locking_action_id
2081: AND pre.locking_action_id = p_locking_action_id
2082: AND pre.locked_action_id = passact.assignment_action_id
2083: AND passact.payroll_action_id = ppaa.payroll_action_id

Line 2096: FROM pay_assignment_actions paa,

2092: p_assignment_id NUMBER,
2093: p_effective_date DATE ) IS
2094: SELECT paa.assignment_action_id child_assignment_action_id,
2095: 'S' run_type
2096: FROM pay_assignment_actions paa,
2097: pay_run_types_f prt
2098: WHERE paa.source_action_id = p_master_assignment_action
2099: AND paa.payroll_action_id = p_payroll_action_id
2100: AND paa.assignment_id = p_assignment_id

Line 2108: FROM pay_assignment_actions paa

2104: prt.effective_start_date AND prt.effective_end_date
2105: UNION
2106: SELECT paa.assignment_action_id child_assignment_action_id,
2107: 'NP' run_type
2108: FROM pay_assignment_actions paa
2109: WHERE paa.payroll_action_id = p_payroll_action_id
2110: AND paa.assignment_id = p_assignment_id
2111: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2112: FROM pay_assignment_actions paa1,

Line 2112: FROM pay_assignment_actions paa1,

2108: FROM pay_assignment_actions paa
2109: WHERE paa.payroll_action_id = p_payroll_action_id
2110: AND paa.assignment_id = p_assignment_id
2111: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2112: FROM pay_assignment_actions paa1,
2113: pay_run_types_f prt1
2114: WHERE prt1.run_type_id = paa1.run_type_id
2115: AND prt1.run_method IN ('N','P')
2116: AND paa1.payroll_action_id = p_payroll_action_id

Line 2128: FROM pay_assignment_actions paa,

2124: p_assignment_id NUMBER,
2125: p_effective_date DATE) IS
2126: SELECT paa.assignment_action_id np_assignment_action_id,
2127: prt.run_method
2128: FROM pay_assignment_actions paa,
2129: pay_run_types_f prt
2130: WHERE paa.source_action_id = p_assignment_action_id
2131: AND paa.payroll_action_id = p_payroll_action_id
2132: AND paa.assignment_id = p_assignment_id

Line 2167: FROM pay_assignment_actions paa

2163:
2164: -- retrieve the chunk number for the current assignment action
2165: SELECT paa.chunk_number
2166: INTO l_chunk_number
2167: FROM pay_assignment_actions paa
2168: WHERE paa.assignment_action_id = p_assactid;
2169:
2170: l_action_context_id := p_assactid;
2171:

Line 2238: SELECT pay_assignment_actions_s.NEXTVAL

2234: csr_rec.effective_date)
2235:
2236: LOOP
2237: -- create additional archive assignment actions and interlocks
2238: SELECT pay_assignment_actions_s.NEXTVAL
2239: INTO l_actid
2240: FROM dual;
2241:
2242: hr_utility.set_location('csr_child_rec.run_type = ' ||

Line 2676: pay_assignment_actions paa1, -- prepayment action

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
2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 2677: pay_assignment_actions paa2, -- archive action

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
2680: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2681: pay_assignment_actions paa, -- payroll run/quickpay action

Line 2681: pay_assignment_actions paa, -- payroll run/quickpay 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
2685: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 2730: pay_assignment_actions paa

2726: then
2727: select paa.assignment_id, ppa.effective_date
2728: into l_assignment_id, l_effective_date
2729: from pay_payroll_actions ppa,
2730: pay_assignment_actions paa
2731: where paa.assignment_action_id = p_assignment_action_id
2732: and paa.payroll_action_id = ppa.payroll_action_id;
2733:
2734: else