APPS.PAY_DK_STATSR_PKG dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 102: FROM pay_payroll_actions

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

Line 406: ,pay_payroll_actions ppa

402:
403: -- The sql string to return
404: sqlstr := 'SELECT DISTINCT person_id
405: FROM per_people_f ppf
406: ,pay_payroll_actions ppa
407: WHERE ppa.payroll_action_id = :payroll_action_id
408: AND ppa.business_group_id = ppf.business_group_id
409: ORDER BY ppf.person_id';
410:

Line 688: ,pay_payroll_actions ppa

684: ,per_all_assignments_f paaf
685: ,pay_payrolls_f ppf
686: ,hr_soft_coding_keyflex scl
687: ,pay_assignment_actions paa
688: ,pay_payroll_actions ppa
689: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
690: AND papf.PERSON_ID = paaf.PERSON_ID
691: AND ppf.payroll_id = nvl(p_payroll_id,ppf.payroll_id)
692: AND paaf.payroll_id = ppf.payroll_id

Line 868: FROM pay_payroll_actions

864: END IF;
865:
866: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
867: INTO l_span
868: FROM pay_payroll_actions
869: WHERE payroll_action_id = p_payroll_action_id;
870:
871: -- Fetch Header and Sub-header details
872: FOR rec_sub_hdr_info IN csr_get_sub_hdr_info(p_payroll_action_id)

Line 1663: FROM pay_payroll_actions ppa,

1659: BEGIN
1660:
1661: SELECT payroll_action_id
1662: INTO l_payroll_action_id
1663: FROM pay_payroll_actions ppa,
1664: fnd_conc_req_summary_v fcrs,
1665: fnd_conc_req_summary_v fcrs1
1666: WHERE fcrs.request_id = fnd_global.conc_request_id
1667: AND fcrs.priority_request_id = fcrs1.priority_request_id