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_CN_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 101: token_val pay_payroll_actions.legislative_parameters%TYPE;

97: ) RETURN VARCHAR2 IS
98:
99: start_ptr NUMBER;
100: end_ptr NUMBER;
101: token_val pay_payroll_actions.legislative_parameters%TYPE;
102: par_value pay_payroll_actions.legislative_parameters%TYPE;
103:
104: BEGIN
105:

Line 102: par_value pay_payroll_actions.legislative_parameters%TYPE;

98:
99: start_ptr NUMBER;
100: end_ptr NUMBER;
101: token_val pay_payroll_actions.legislative_parameters%TYPE;
102: par_value pay_payroll_actions.legislative_parameters%TYPE;
103:
104: BEGIN
105:
106: token_val := p_name || '=';

Line 151: -- pay_payroll_actions table.

147: -- 115.0 30-JUN-2003 bramajey Initial Version --
148: -- 115.1 03-JUL-2003 bramajey Replaced %TYPE with actual data type --
149: -- in parameter list. --
150: -- 115.2 14-Nov-2008 mdubasi Added code to update payroll_id in --
151: -- pay_payroll_actions table.
152: --------------------------------------------------------------------------
153: --
154:
155:

Line 164: leg_param pay_payroll_actions.legislative_parameters%TYPE;

160: --
161: l_procedure VARCHAR2(100) ;
162: --
163: l_payroll_id NUMBER;
164: leg_param pay_payroll_actions.legislative_parameters%TYPE;
165: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
166: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
167: --
168: BEGIN

Line 165: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

161: l_procedure VARCHAR2(100) ;
162: --
163: l_payroll_id NUMBER;
164: leg_param pay_payroll_actions.legislative_parameters%TYPE;
165: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
166: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
167: --
168: BEGIN
169: --

Line 166: l_pactid pay_payroll_actions.payroll_action_id%TYPE;

162: --
163: l_payroll_id NUMBER;
164: leg_param pay_payroll_actions.legislative_parameters%TYPE;
165: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
166: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
167: --
168: BEGIN
169: --
170: l_procedure := g_package || '.initialization_code';

Line 175: -- Code to update the payroll_id in the pay_payroll_actions tabel.

171: hr_utility.set_location('Entering ' || l_procedure,10);
172:
173:
174: --------------------------------------------------------------------------
175: -- Code to update the payroll_id in the pay_payroll_actions tabel.
176: --------------------------------------------------------------------------
177:
178: SELECT legislative_parameters,payroll_id
179: INTO leg_param,l_ppa_payroll_id

Line 180: FROM pay_payroll_actions

176: --------------------------------------------------------------------------
177:
178: SELECT legislative_parameters,payroll_id
179: INTO leg_param,l_ppa_payroll_id
180: FROM pay_payroll_actions
181: WHERE payroll_action_id = p_payroll_action_id ;
182:
183: l_payroll_id := get_parameter('PAYROLL', leg_param);
184:

Line 189: UPDATE pay_payroll_actions

185: -- Update the Payroll Action with the Payroll ID
186:
187: IF l_ppa_payroll_id IS NULL THEN
188:
189: UPDATE pay_payroll_actions
190: SET payroll_id = l_payroll_id
191: WHERE payroll_action_id = p_payroll_action_id;
192:
193: END IF;

Line 356: ,pay_payroll_actions ppa

352: ,pay_element_types_f pet
353: ,pay_element_links_f pel
354: ,pay_element_entries_f pee
355: ,pay_assignment_actions paa
356: ,pay_payroll_actions ppa
357: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
358: AND pel.element_type_id = pet.element_type_id
359: AND pee.element_link_id = pel.element_link_id
360: AND paa.assignment_id = pee.assignment_id

Line 551: ,pay_payroll_actions ppa

547: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
548: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
549: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
550: FROM pay_assignment_actions paa
551: ,pay_payroll_actions ppa
552: ,pay_run_results prr
553: ,pay_run_result_values prrv
554: ,per_time_periods ptp
555: ,pay_element_types_f pet

Line 719: FROM pay_payroll_actions ppa

715: ,pet.output_currency_code
716: ,ppa.effective_date
717: ,ppa.business_group_id
718: ) exchange_rate
719: FROM pay_payroll_actions ppa
720: , pay_assignment_actions paa
721: , pay_run_results prr
722: , pay_run_result_values prrv
723: , pay_input_values_f piv

Line 1844: ,pay_payroll_actions ppa

1840: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1841: FROM hr_soft_coding_keyflex hsck
1842: ,per_all_assignments_f paaf
1843: ,pay_assignment_actions paa
1844: ,pay_payroll_actions ppa
1845: WHERE paa.assignment_action_id = p_assactid
1846: AND paa.payroll_action_id = ppa.payroll_action_id
1847: AND paa.assignment_id = paaf.assignment_id
1848: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 2167: ,pay_payroll_actions ppa_pre

2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre
2168: ,pay_payroll_actions ppa_run
2169: ,per_time_periods ptp
2170: ,per_business_groups pbg
2171: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id

Line 2168: ,pay_payroll_actions ppa_run

2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre
2168: ,pay_payroll_actions ppa_run
2169: ,per_time_periods ptp
2170: ,per_business_groups pbg
2171: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
2172: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 2205: FROM pay_payroll_actions ppa,

2201:
2202: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
2203: IS
2204: SELECT pps.actual_termination_date
2205: FROM pay_payroll_actions ppa,
2206: pay_assignment_actions paa,
2207: per_time_periods ptp,
2208: per_all_assignments_f paf,
2209: per_periods_of_service pps