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 33: t_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE ;

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

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

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

Line 888: FROM pay_payroll_actions ppa

884: MIN(pay_st_date) mindate
885: FROM (SELECT MAX(ptp.start_date) pay_st_date,MAX(ptp.end_date) pay_date
886: FROM per_time_periods ptp
887: WHERE ptp.payroll_id IN (SELECT payroll_id
888: FROM pay_payroll_actions ppa
889: WHERE ppa.consolidation_set_id=p_consolidation_set_id
890: AND (payroll_id =p_payroll_id
891: OR p_payroll_id IS NULL)
892: AND ppa.date_earned <= p_effective_date)

Line 911: UPDATE pay_payroll_actions

907: EXIT WHEN c_set_paydate%NOTFOUND;
908: END LOOP;
909: CLOSE c_set_paydate;
910:
911: UPDATE pay_payroll_actions
912: SET Start_date= NVL(l_mindate,p_effective_date)
913: , effective_date=NVL(l_maxdate,p_effective_date)
914: WHERE payroll_action_id=pactid;
915:

Line 1020: pay_payroll_actions ppa,

1016: paa.payroll_action_id pactid
1017: FROM
1018: hr_organization_units hou1,
1019: per_assignments_f paf,
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,
1023: pay_assignment_actions paa,
1024: pay_payroll_actions ppa_arch

Line 1024: pay_payroll_actions ppa_arch

1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,
1023: pay_assignment_actions paa,
1024: pay_payroll_actions ppa_arch
1025: WHERE paa.assignment_action_id = l_pactid
1026: AND paa.payroll_action_id = ppa_arch.payroll_action_id
1027: AND pai.locking_action_id = paa.assignment_action_id
1028: AND paa1.assignment_action_id = pai.locked_action_id

Line 1105: FROM pay_payroll_actions ppa

1101: l_varvalue,
1102: g_gre_id,
1103: g_jd_code,
1104: t_payroll_action_id
1105: FROM pay_payroll_actions ppa
1106: WHERE ppa.payroll_action_id = pactid;
1107:
1108: EXCEPTION
1109: ---------