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

Line 47: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

43: p_segment_number IN NUMBER DEFAULT NULL
44: )
45: RETURN VARCHAR2
46: IS
47: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
48: l_start_pos NUMBER;
49: l_delimiter VARCHAR2 (1) := ' ';
50: l_proc VARCHAR2 (40) := g_package
51: || ' get parameter ';

Line 163: FROM pay_payroll_actions

159: )
160: RUN_payroll_action_id,
161: start_date, effective_date effective_date,
162: business_group_id bg_id
163: FROM pay_payroll_actions
164: WHERE payroll_action_id = p_payroll_action_id;
165:
166: lr_parameter_info csr_parameter_info%ROWTYPE;
167: l_proc VARCHAR2 (240)

Line 249: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

245: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
246: */
247:
248: CURSOR csr_time_period_details (
249: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
250: )
251: IS
252: select papf.payroll_name,ptp.end_date , ptp.period_name ,
253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf

Line 253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf

249: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
250: )
251: IS
252: select papf.payroll_name,ptp.end_date , ptp.period_name ,
253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf
254: where ptp.time_period_id=ppa.time_period_id
255: and ppa.PAYROLL_ID=papf.PAYROLL_ID
256: and ppa.payroll_action_id=csr_v_payroll_action_id;
257:

Line 270: ,pay_payroll_actions ppa

266: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');
267: p_sql :=
268: 'SELECT DISTINCT person_id
269: FROM per_people_f ppf
270: ,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = :payroll_action_id
272: AND ppa.business_group_id = ppf.business_group_id
273: ORDER BY ppf.person_id';
274: get_all_parameters (

Line 374: FROM pay_payroll_actions appa,

370: IS
371: SELECT act.assignment_id assignment_id,
372: act.assignment_action_id run_action_id,
373: act1.assignment_action_id prepaid_action_id
374: FROM pay_payroll_actions appa,
375: pay_payroll_actions appa2,
376: pay_assignment_actions act,
377: pay_assignment_actions act1,
378: pay_action_interlocks pai,

Line 375: pay_payroll_actions appa2,

371: SELECT act.assignment_id assignment_id,
372: act.assignment_action_id run_action_id,
373: act1.assignment_action_id prepaid_action_id
374: FROM pay_payroll_actions appa,
375: pay_payroll_actions appa2,
376: pay_assignment_actions act,
377: pay_assignment_actions act1,
378: pay_action_interlocks pai,
379: per_all_assignments_f paaf

Line 605: l_date_earned pay_payroll_actions.date_earned%TYPE;

601: l_end_date per_time_periods.end_date%TYPE;
602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;
608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
609: l_run_payact_id NUMBER;

Line 606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

602: l_pre_end_date per_time_periods.end_date%TYPE;
603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;
608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
609: l_run_payact_id NUMBER;
610: l_action_context_id NUMBER;

Line 607: l_effective_date pay_payroll_actions.effective_date%TYPE;

603: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;
608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
609: l_run_payact_id NUMBER;
610: l_action_context_id NUMBER;
611: g_archive_pact NUMBER;

Line 608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

604: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
605: l_date_earned pay_payroll_actions.date_earned%TYPE;
606: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
607: l_effective_date pay_payroll_actions.effective_date%TYPE;
608: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
609: l_run_payact_id NUMBER;
610: l_action_context_id NUMBER;
611: g_archive_pact NUMBER;
612: p_assactid NUMBER;