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.PQP_TIAALOD_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 4: l_start_date pay_payroll_actions.start_date%TYPE;

1: Package Body PQP_Tiaalod_Pkg As
2: /* $Header: pqtiaald.pkb 120.0.12000000.1 2007/01/16 04:34:33 appldev noship $ */
3: ------------------------------------- Global Varaibles ---------------------------
4: l_start_date pay_payroll_actions.start_date%TYPE;
5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 5: l_end_date pay_payroll_actions.effective_date%TYPE;

1: Package Body PQP_Tiaalod_Pkg As
2: /* $Header: pqtiaald.pkb 120.0.12000000.1 2007/01/16 04:34:33 appldev noship $ */
3: ------------------------------------- Global Varaibles ---------------------------
4: l_start_date pay_payroll_actions.start_date%TYPE;
5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;

Line 6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

2: /* $Header: pqtiaald.pkb 120.0.12000000.1 2007/01/16 04:34:33 appldev noship $ */
3: ------------------------------------- Global Varaibles ---------------------------
4: l_start_date pay_payroll_actions.start_date%TYPE;
5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

3: ------------------------------------- Global Varaibles ---------------------------
4: l_start_date pay_payroll_actions.start_date%TYPE;
5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

Line 8: l_effective_date pay_payroll_actions.effective_date%TYPE;

4: l_start_date pay_payroll_actions.start_date%TYPE;
5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;

Line 9: l_action_type pay_payroll_actions.action_type%TYPE;

5: l_end_date pay_payroll_actions.effective_date%TYPE;
6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;

Line 26: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

22: l_leg_end_date DATE;
23: t_payroll_id NUMBER(15);
24: t_consolidation_set_id NUMBER(15);
25: t_gre_id NUMBER(15);
26: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
27: l_defined_balance_id NUMBER;
28: l_row_count NUMBER :=0;
29: l_national_id per_people_v.national_identifier%TYPE;
30: l_last_name per_all_people_f.last_name%TYPE;

Line 42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;

38: l_org_ppg hr_organization_information.org_information1%TYPE;
39: l_err_msg VARCHAR2(800);
40: l_err_num VARCHAR2(800);
41: l_chunk_no number;
42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;
43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;
44:
45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,
46: payment_mode pay_payrolls_f.prl_information4%TYPE,

Line 43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;

39: l_err_msg VARCHAR2(800);
40: l_err_num VARCHAR2(800);
41: l_chunk_no number;
42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;
43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;
44:
45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,
46: payment_mode pay_payrolls_f.prl_information4%TYPE,
47: ppg_billing_code pay_payrolls_f.prl_information7%TYPE,

Line 782: pay_payroll_actions ppa,

778: FROM hr_locations_all hrl,
779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,
785: pay_assignment_actions paa_gen,
786: pay_payroll_actions ppa_gen

Line 786: pay_payroll_actions ppa_gen

782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,
785: pay_assignment_actions paa_gen,
786: pay_payroll_actions ppa_gen
787: WHERE
788: ppa_gen.payroll_action_id = l_pactid
789: AND paa_gen.payroll_action_id = ppa_gen.payroll_action_id
790: AND paa_gen.chunk_number = l_chnkno

Line 840: FROM pay_payroll_actions ppa

836: t_consolidation_set_id,
837: t_payroll_id,
838: t_gre_id,
839: t_payroll_action_id
840: FROM pay_payroll_actions ppa
841: WHERE ppa.payroll_action_id = pactid;
842:
843: EXCEPTION
844: WHEN NO_DATA_FOUND THEN