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.HR_PERSON_RECORD dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1932: p_assg_action_id pay_assignment_actions.assignment_action_id%type;

1928:
1929: --Declaration for Payroll - Starts here
1930: p_leg_code varchar2(20);
1931: p_assignment_id per_all_assignments_f.assignment_id%type;
1932: p_assg_action_id pay_assignment_actions.assignment_action_id%type;
1933: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;
1934:
1935: cursor csr_leg_code(p_bus_grp_id number) is
1936: select to_char(org_information9) from

Line 1956: ,pay_assignment_actions paa

1952: ,paa.assignment_id
1953: ,paa.assignment_action_id
1954: , paf.location_id
1955: from pay_payroll_actions ppa
1956: ,pay_assignment_actions paa
1957: ,per_assignments_f paf
1958: ,per_people_f ppf
1959: ,hr_lookups hl
1960: where ppa.action_type = 'X'

Line 1971: ,pay_assignment_actions paa1

1967: and paf.person_id = ppf.person_id
1968: and ppf.person_id = p_person_id
1969: and ppa.effective_date = (select max(ppa1.effective_date)
1970: from pay_payroll_actions ppa1
1971: ,pay_assignment_actions paa1
1972: ,hr_lookups hl1
1973: where ppa1.effective_date <= p_eff_date
1974: and ppa1.action_type = 'X'
1975: and ppa1.action_status = 'C'

Line 2141: pay_assignment_actions paa,

2137: to_char(beginning_date,'YYYY-MM-DD') ,
2138: to_char(ending_date,'YYYY-MM-DD'),
2139: paa.assignment_id
2140: from pay_employee_action_info_v empv,
2141: pay_assignment_actions paa,
2142: per_business_groups pbg
2143: where empv.action_context_id = p_asg_action_id
2144: and empv.action_context_id = paa.assignment_action_id
2145: and paa.assignment_id = nvl(empv.assignment_id,paa.assignment_id)

Line 2152: pay_assignment_actions paa,

2148: -- cursor to fetch the run type
2149: cursor csr_run_type(p_assignment_id number,p_eff_date date) is
2150: select prtf.run_type_name
2151: from pay_payroll_actions ppa,
2152: pay_assignment_actions paa,
2153: pay_run_types_f prtf
2154: where paa.assignment_action_id in (SELECT /*+ USE_NL(paa, pact, ptp) */
2155: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2156: paa.assignment_action_id),16)) assignment_action_id

Line 2157: FROM pay_assignment_actions paa,

2153: pay_run_types_f prtf
2154: where paa.assignment_action_id in (SELECT /*+ USE_NL(paa, pact, ptp) */
2155: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2156: paa.assignment_action_id),16)) assignment_action_id
2157: FROM pay_assignment_actions paa,
2158: pay_payroll_actions pact
2159: WHERE paa.assignment_id = p_assignment_id
2160: AND paa.payroll_action_id = pact.payroll_action_id
2161: AND pact.action_type IN ('Q','R','B','I','V')

Line 2175: pay_assignment_actions paa1, -- prepayment action

2171: SELECT /*+ leading(lck,paa2) */
2172: --pai.action_information4 NARRATIVE,
2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2174: FROM pay_action_interlocks lck, -- archive action locking prepayment
2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 2176: pay_assignment_actions paa2, -- archive action

2172: --pai.action_information4 NARRATIVE,
2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2174: FROM pay_action_interlocks lck, -- archive action locking prepayment
2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2180: pay_assignment_actions paa, -- payroll run/quickpay action

Line 2180: pay_assignment_actions paa, -- payroll run/quickpay action

2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2180: pay_assignment_actions paa, -- payroll run/quickpay action
2181: pay_payroll_actions ppa1, -- payroll run/quickpay action
2182: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2183: pay_input_values_f piv, -- "Pay values" of type Money
2184: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 2219: pay_assignment_actions paa1, -- prepayment action

2215: cursor csr_uk_tx_cv(p_assignment_action_id number) is
2216: SELECT /*+ leading(lck,paa2) */
2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2218: FROM pay_action_interlocks lck, -- archive action locking prepayment
2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 2220: pay_assignment_actions paa2, -- archive action

2216: SELECT /*+ leading(lck,paa2) */
2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2218: FROM pay_action_interlocks lck, -- archive action locking prepayment
2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2224: pay_assignment_actions paa, -- payroll run/quickpay action

Line 2224: pay_assignment_actions paa, -- payroll run/quickpay action

2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2224: pay_assignment_actions paa, -- payroll run/quickpay action
2225: pay_payroll_actions ppa1, -- payroll run/quickpay action
2226: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2227: pay_input_values_f piv, -- "Pay values" of type Money
2228: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 2264: pay_assignment_actions paa1, -- prepayment action

2260: cursor csr_uk_ni_cv(p_assignment_action_id number) is
2261: SELECT /*+ leading(lck,paa2) */
2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2263: FROM pay_action_interlocks lck, -- archive action locking prepayment
2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 2265: pay_assignment_actions paa2, -- archive action

2261: SELECT /*+ leading(lck,paa2) */
2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2263: FROM pay_action_interlocks lck, -- archive action locking prepayment
2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2269: pay_assignment_actions paa, -- payroll run/quickpay action

Line 2269: pay_assignment_actions paa, -- payroll run/quickpay action

2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2269: pay_assignment_actions paa, -- payroll run/quickpay action
2270: pay_payroll_actions ppa1, -- payroll run/quickpay action
2271: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2272: pay_input_values_f piv, -- "Pay values" of type Money
2273: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 2352: FROM pay_assignment_actions paa,

2348:
2349: SELECT /*+ USE_NL(paa, pact, ptp) */
2350: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2351: paa.assignment_action_id),16)) assignment_action_id
2352: FROM pay_assignment_actions paa,
2353: pay_payroll_actions pact
2354: WHERE paa.assignment_id = p_assignment_id --16986
2355: AND paa.payroll_action_id = pact.payroll_action_id
2356: AND pact.action_type IN ('Q','R','B','I','V')