[Home] [Help]
28: SELECT
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'
43: AND ppa.effective_date = (
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'
97: and prtf.legislation_code = 'GB';
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')||
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')
112: AND paa.action_status = 'C'
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
131: pay_payroll_actions ppa1, -- payroll run/quickpay 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
135: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
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
175: pay_payroll_actions ppa1, -- payroll run/quickpay 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
179: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
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
220: pay_payroll_actions ppa1, -- payroll run/quickpay 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
224: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
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')
307: --AND paa.action_status = 'C'
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
368: