APPS.PAY_DK_STATSR_PKG dependencies on PAY_PAYROLL_ACTIONS

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

37: p_parameter_string IN VARCHAR2
38: ,p_token IN VARCHAR2
39: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
40: IS
41: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
42: l_start_pos NUMBER;
43: l_delimiter VARCHAR2(1):=' ';
44:
45: BEGIN

Line 101: FROM pay_payroll_actions

97: ,PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions
102: WHERE payroll_action_id = p_payroll_action_id;
103:
104: l_proc VARCHAR2(240):= g_package||'.GET_ALL_PARAMETERS ';
105: --

Line 421: ,pay_payroll_actions ppa

417:
418: -- The sql string to return
419: sqlstr := 'SELECT DISTINCT person_id
420: FROM per_people_f ppf
421: ,pay_payroll_actions ppa
422: WHERE ppa.payroll_action_id = :payroll_action_id
423: AND ppa.business_group_id = ppf.business_group_id
424: ORDER BY ppf.person_id';
425:

Line 745: ,pay_payroll_actions ppa

741: ,per_all_assignments_f paaf
742: ,pay_payrolls_f ppf
743: ,hr_soft_coding_keyflex scl
744: ,pay_assignment_actions paa
745: ,pay_payroll_actions ppa
746: ,per_time_periods ptp --8848543
747: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
748: AND papf.PERSON_ID = paaf.PERSON_ID
749: AND ppf.payroll_id = nvl(p_payroll_id,ppf.payroll_id)

Line 1145: FROM pay_payroll_actions

1141:
1142: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
1143: ,fnd_date.canonical_to_date(PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE')) --8848543
1144: INTO l_span, l_pd_date_to --8848543
1145: FROM pay_payroll_actions
1146: WHERE payroll_action_id = p_payroll_action_id;
1147: --8848543
1148: IF l_span <> 'P' THEN
1149: l_pd_date_to := NULL;

Line 2398: FROM pay_payroll_actions ppa,

2394: IF p_payroll_action_id IS NULL THEN
2395: BEGIN
2396: SELECT payroll_action_id
2397: INTO l_payroll_action_id
2398: FROM pay_payroll_actions ppa,
2399: fnd_conc_req_summary_v fcrs,
2400: fnd_conc_req_summary_v fcrs1
2401: WHERE fcrs.request_id = fnd_global.conc_request_id
2402: AND fcrs.priority_request_id = fcrs1.priority_request_id