APPS.PAY_DK_ABSR_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_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_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 325: ,pay_payroll_actions ppa

321:
322: -- The sql string to return
323: sqlstr := 'SELECT DISTINCT person_id
324: FROM per_people_f ppf
325: ,pay_payroll_actions ppa
326: WHERE ppa.payroll_action_id = :payroll_action_id
327: AND ppa.business_group_id = ppf.business_group_id
328: ORDER BY ppf.person_id';
329:

Line 556: --,pay_payroll_actions ppa

552: ,per_all_assignments_f paaf
553: ,pay_payrolls_f ppf
554: ,hr_soft_coding_keyflex scl
555: --,pay_assignment_actions paa
556: --,pay_payroll_actions ppa
557: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
558: AND papf.PERSON_ID = paaf.PERSON_ID
559: AND ppf.payroll_id = nvl(p_payroll_id,ppf.payroll_id)
560: AND paaf.payroll_id = ppf.payroll_id

Line 792: FROM pay_payroll_actions

788: END IF;
789:
790: SELECT PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
791: INTO l_year
792: FROM pay_payroll_actions
793: WHERE payroll_action_id = p_payroll_action_id;
794:
795:
796: hr_utility.trace(' Before for loop csr_get_hdr_info ');

Line 1226: pay_payroll_actions ppa,

1222: CURSOR csr_get_body_info(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER)
1223: IS
1224: SELECT pai.*
1225: FROM
1226: pay_payroll_actions ppa,
1227: Pay_assignment_actions paa,
1228: pay_action_information pai
1229: WHERE
1230: ppa.payroll_action_id = p_payroll_action_id

Line 1254: FROM pay_payroll_actions ppa,

1250: IF p_payroll_action_id IS NULL THEN
1251: BEGIN
1252: SELECT payroll_action_id
1253: INTO l_payroll_action_id
1254: FROM pay_payroll_actions ppa,
1255: fnd_conc_req_summary_v fcrs,
1256: fnd_conc_req_summary_v fcrs1
1257: WHERE fcrs.request_id = fnd_global.conc_request_id
1258: AND fcrs.priority_request_id = fcrs1.priority_request_id