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

Line 33: pay_assignment_actions paa,

29: DISTINCT
30: paa.assignment_action_id
31: FROM
32: pay_payroll_actions ppa,
33: pay_assignment_actions paa,
34: per_assignments_f paf,
35: per_people_f ppf
36: WHERE ppa.action_type = 'X'
37: AND ppa.action_status = 'C'

Line 48: pay_assignment_actions paa1

44: SELECT
45: max(ppa1.effective_date)
46: FROM
47: pay_payroll_actions ppa1,
48: pay_assignment_actions paa1
49: WHERE ppa1.effective_date <= p_eff_date
50: AND ppa1.action_type = 'X'
51: AND ppa1.action_status = 'C'
52: AND ppa1.report_type = 'UKPS'

Line 73: pay_assignment_actions paa,

69: to_char(beginning_date,'YYYY-MM-DD') ,
70: to_char(ending_date,'YYYY-MM-DD'),
71: paa.assignment_id
72: from pay_employee_action_info_v empv,
73: pay_assignment_actions paa,
74: per_business_groups pbg,
75: per_all_assignments_f paaf
76: where empv.action_context_id = p_asg_action_id
77: and empv.action_context_id = paa.assignment_action_id

Line 87: pay_assignment_actions paa1,

83: -- cursor to fetch the run type
84: cursor csr_run_type(p_assignment_action_id number) is
85: select prtf.run_type_name
86: from pay_action_interlocks lck,
87: pay_assignment_actions paa1,
88: pay_action_interlocks pac,
89: pay_assignment_actions paa,
90: pay_run_types_f prtf
91: where lck.locked_action_id = paa1.assignment_action_id

Line 89: pay_assignment_actions paa,

85: select prtf.run_type_name
86: from pay_action_interlocks lck,
87: pay_assignment_actions paa1,
88: pay_action_interlocks pac,
89: pay_assignment_actions paa,
90: pay_run_types_f prtf
91: where lck.locked_action_id = paa1.assignment_action_id
92: and paa1.assignment_action_id = pac.locking_action_id
93: and pac.locked_action_id = paa.assignment_action_id

Line 102: pay_assignment_actions paa,

98:
99: /*cursor csr_run_type(p_assignment_id number,p_eff_date date) is
100: select prtf.run_type_name
101: from pay_payroll_actions ppa,
102: pay_assignment_actions paa,
103: pay_run_types_f prtf
104: where paa.assignment_action_id in (SELECT + USE_NL(paa, pact, ptp)
105: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
106: paa.assignment_action_id),16)) assignment_action_id

Line 107: FROM pay_assignment_actions paa,

103: pay_run_types_f prtf
104: where paa.assignment_action_id in (SELECT + USE_NL(paa, pact, ptp)
105: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
106: paa.assignment_action_id),16)) assignment_action_id
107: FROM pay_assignment_actions paa,
108: pay_payroll_actions pact
109: WHERE paa.assignment_id = p_assignment_id
110: AND paa.payroll_action_id = pact.payroll_action_id
111: AND pact.action_type IN ('Q','R','B','I','V')

Line 125: pay_assignment_actions paa1, -- prepayment action

121: SELECT /*+ leading(lck,paa2) */
122: --pai.action_information4 NARRATIVE,
123: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
124: FROM pay_action_interlocks lck, -- archive action locking prepayment
125: pay_assignment_actions paa1, -- prepayment action
126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment
128: pay_action_information pai, -- archived element/input value definition
129: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 126: pay_assignment_actions paa2, -- archive action

122: --pai.action_information4 NARRATIVE,
123: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
124: FROM pay_action_interlocks lck, -- archive action locking prepayment
125: pay_assignment_actions paa1, -- prepayment action
126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment
128: pay_action_information pai, -- archived element/input value definition
129: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
130: pay_assignment_actions paa, -- payroll run/quickpay action

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

126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment
128: pay_action_information pai, -- archived element/input value definition
129: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
130: pay_assignment_actions paa, -- payroll run/quickpay action
131: pay_payroll_actions ppa1, -- payroll run/quickpay action
132: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
133: pay_input_values_f piv, -- "Pay values" of type Money
134: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 169: pay_assignment_actions paa1, -- prepayment action

165: cursor csr_uk_tx_cv(p_assignment_action_id number) is
166: SELECT /*+ leading(lck,paa2) */
167: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
168: FROM pay_action_interlocks lck, -- archive action locking prepayment
169: pay_assignment_actions paa1, -- prepayment action
170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment
172: pay_action_information pai, -- archived element/input value definition
173: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 170: pay_assignment_actions paa2, -- archive action

166: SELECT /*+ leading(lck,paa2) */
167: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
168: FROM pay_action_interlocks lck, -- archive action locking prepayment
169: pay_assignment_actions paa1, -- prepayment action
170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment
172: pay_action_information pai, -- archived element/input value definition
173: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
174: pay_assignment_actions paa, -- payroll run/quickpay action

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

170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment
172: pay_action_information pai, -- archived element/input value definition
173: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
174: pay_assignment_actions paa, -- payroll run/quickpay action
175: pay_payroll_actions ppa1, -- payroll run/quickpay action
176: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
177: pay_input_values_f piv, -- "Pay values" of type Money
178: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 214: pay_assignment_actions paa1, -- prepayment action

210: cursor csr_uk_ni_cv(p_assignment_action_id number) is
211: SELECT /*+ leading(lck,paa2) */
212: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
213: FROM pay_action_interlocks lck, -- archive action locking prepayment
214: pay_assignment_actions paa1, -- prepayment action
215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment
217: pay_action_information pai, -- archived element/input value definition
218: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 215: pay_assignment_actions paa2, -- archive action

211: SELECT /*+ leading(lck,paa2) */
212: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
213: FROM pay_action_interlocks lck, -- archive action locking prepayment
214: pay_assignment_actions paa1, -- prepayment action
215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment
217: pay_action_information pai, -- archived element/input value definition
218: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
219: pay_assignment_actions paa, -- payroll run/quickpay action

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

215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment
217: pay_action_information pai, -- archived element/input value definition
218: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
219: pay_assignment_actions paa, -- payroll run/quickpay action
220: pay_payroll_actions ppa1, -- payroll run/quickpay action
221: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
222: pay_input_values_f piv, -- "Pay values" of type Money
223: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 302: FROM pay_assignment_actions paa,

298:
299: SELECT /*+ USE_NL(paa, pact, ptp) */
300: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
301: paa.assignment_action_id),16)) assignment_action_id
302: FROM pay_assignment_actions paa,
303: pay_payroll_actions pact
304: WHERE paa.assignment_id = p_assignment_id --16986
305: AND paa.payroll_action_id = pact.payroll_action_id
306: AND pact.action_type IN ('Q','R','B','I','V')

Line 363: p_assg_action_id pay_assignment_actions.assignment_action_id%type;

359: p_latest_action_id number;
360: p_netpay_bal_id number;
361: p_def_bal_id number;
362: p_assignment_id per_all_assignments_f.assignment_id%type;
363: p_assg_action_id pay_assignment_actions.assignment_action_id%type;
364: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;
365:
366: p_cnt number;
367: -- Declaration for uk payroll ends here