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

Line 11: l_start_date pay_payroll_actions.start_date%TYPE ;

7:
8: --
9: */
10: ------------------------------------- Global Varaibles ---------------------------
11: l_start_date pay_payroll_actions.start_date%TYPE ;
12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;

Line 12: l_end_date pay_payroll_actions.effective_date%TYPE ;

8: --
9: */
10: ------------------------------------- Global Varaibles ---------------------------
11: l_start_date pay_payroll_actions.start_date%TYPE ;
12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;

Line 13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;

9: */
10: ------------------------------------- Global Varaibles ---------------------------
11: l_start_date pay_payroll_actions.start_date%TYPE ;
12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;

Line 14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

10: ------------------------------------- Global Varaibles ---------------------------
11: l_start_date pay_payroll_actions.start_date%TYPE ;
12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;

Line 15: l_effective_date pay_payroll_actions.effective_date%TYPE ;

11: l_start_date pay_payroll_actions.start_date%TYPE ;
12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;

Line 16: l_action_type pay_payroll_actions.action_type%TYPE ;

12: l_end_date pay_payroll_actions.effective_date%TYPE ;
13: l_business_group_id pay_payroll_actions.business_group_id%TYPE ;
14: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;

Line 26: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;

22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;
24: l_location_code hr_locations.location_code%TYPE ;
25: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
26: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
27: l_leg_start_date DATE ;
28: l_leg_end_date DATE ;
29: t_payroll_id NUMBER(15) ;
30: t_consolidation_set_id NUMBER(15) ;

Line 34: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

30: t_consolidation_set_id NUMBER(15) ;
31: g_gre_id NUMBER(15) ;
32: g_jd_code VARCHAR2(16) ;
33: g_component_code NUMBER(15) ;
34: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;
35: l_row_count NUMBER :=0 ;
36: l_national_id per_people_v.national_identifier%TYPE ;
37: l_last_name per_all_people_f.last_name%TYPE ;
38: l_first_name per_all_people_f.first_name%TYPE ;

Line 45: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;

41: l_assignment_number per_assignments_f.assignment_number%TYPE ;
42: l_dob per_all_people_f.date_of_birth%TYPE ;
43: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
44: l_legislation_code per_business_groups.legislation_code%TYPE ;
45: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
46: l_param_count NUMBER(2):=0 ;
47: l_ppa_finder VARCHAR2(20) ;
48: l_date VARCHAR2(15) ;
49: l_report_id NUMBER ;

Line 1066: FROM pay_payroll_actions ppa

1062: MIN(pay_st_date) mindate
1063: FROM (SELECT MAX(ptp.start_date) pay_st_date,MAX(ptp.end_date) pay_date
1064: FROM per_time_periods ptp
1065: WHERE ptp.payroll_id IN (SELECT payroll_id
1066: FROM pay_payroll_actions ppa
1067: WHERE ppa.consolidation_set_id=p_consolidation_set_id
1068: AND (payroll_id =p_payroll_id
1069: OR p_payroll_id IS NULL)
1070: AND ppa.date_earned <= p_effective_date)

Line 1089: UPDATE pay_payroll_actions

1085: EXIT WHEN c_set_paydate%NOTFOUND;
1086: END LOOP;
1087: CLOSE c_set_paydate;
1088:
1089: UPDATE pay_payroll_actions
1090: SET Start_date= NVL(l_mindate,p_effective_date)
1091: , effective_date=NVL(l_maxdate,p_effective_date)
1092: WHERE payroll_action_id=pactid;
1093:

Line 1198: pay_payroll_actions ppa,

1194: paa.payroll_action_id pactid
1195: FROM
1196: hr_organization_units hou1,
1197: per_assignments_f paf,
1198: pay_payroll_actions ppa,
1199: pay_assignment_actions paa1,
1200: pay_action_interlocks pai,
1201: pay_assignment_actions paa,
1202: pay_payroll_actions ppa_arch

Line 1202: pay_payroll_actions ppa_arch

1198: pay_payroll_actions ppa,
1199: pay_assignment_actions paa1,
1200: pay_action_interlocks pai,
1201: pay_assignment_actions paa,
1202: pay_payroll_actions ppa_arch
1203: WHERE paa.assignment_action_id = l_pactid
1204: AND paa.payroll_action_id = ppa_arch.payroll_action_id
1205: AND pai.locking_action_id = paa.assignment_action_id
1206: AND paa1.assignment_action_id = pai.locked_action_id

Line 1285: FROM pay_payroll_actions ppa

1281: g_gre_id,
1282: g_jd_code,
1283: t_payroll_action_id,
1284: g_component_code
1285: FROM pay_payroll_actions ppa
1286: WHERE ppa.payroll_action_id = pactid;
1287:
1288: EXCEPTION
1289: ---------