APPS.PAY_FR_DADS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

4: -- Globals
5: --
6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_dads_pkg.';
7: --
8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;
10: g_param_company_id hr_organization_information.organization_id%TYPE;
11: g_param_estab_id hr_organization_information.organization_id%TYPE;
12: g_param_business_group_id per_business_Groups.business_group_id%TYPE;

Line 47: ,pay_payroll_actions ppa

43: -- Return the select string
44: --
45: sqlstr := 'SELECT DISTINCT person_id
46: FROM per_people_f ppf
47: ,pay_payroll_actions ppa
48: WHERE ppa.payroll_action_id = :payroll_action_id
49: AND ppa.business_group_id = ppf.business_group_id
50: ORDER BY ppf.person_id';
51: --

Line 79: ,pay_payroll_actions ppa_run

75: ppa_run.payroll_id, asg_run.assignment_id,
76: max(nvl(paa_run.source_action_id
77: ,paa_run.assignment_action_id)) mst_action_id
78: from pay_assignment_Actions paa_run
79: ,pay_payroll_actions ppa_run
80: ,per_all_assignments_f asg_run
81: ,hr_organization_information org_est
82: ,hr_organization_information org_coy
83: where ppa_run.business_group_id = asg_run.business_group_id

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

250: p_parameter_string in varchar2
251: ,p_token in varchar2
252: ,p_segment_number in number default null ) RETURN varchar2
253: IS
254: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
255: l_start_pos NUMBER;
256: l_delimiter varchar2(1):=' ';
257: l_proc VARCHAR2(40):= g_package||' get parameter ';
258: BEGIN

Line 304: FROM pay_payroll_actions

300: ,business_group_id
301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')
302: ,start_date
303: ,effective_date
304: FROM pay_payroll_actions
305: WHERE payroll_action_id = p_payroll_action_id;
306: --
307: l_proc VARCHAR2(40):= g_package||' get_all_parameters ';
308: