APPS.PAY_DK_PR_ASG dependencies on PAY_PAYROLL_ACTIONS

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

46: p_parameter_string IN VARCHAR2
47: ,p_token IN VARCHAR2
48: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
49: IS
50: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
51: l_start_pos NUMBER;
52: l_delimiter VARCHAR2(1):=' ';
53:
54: BEGIN

Line 109: FROM pay_payroll_actions

105: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
106: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
107: ,effective_date
108: ,business_group_id
109: FROM pay_payroll_actions
110: WHERE payroll_action_id = p_payroll_action_id;
111:
112: BEGIN
113:

Line 198: ,pay_payroll_actions ppa

194:
195: -- the sql string to return
196: sqlstr := 'SELECT DISTINCT person_id
197: FROM per_people_f ppf
198: ,pay_payroll_actions ppa
199: WHERE ppa.payroll_action_id = :payroll_action_id
200: AND ppa.business_group_id = ppf.business_group_id
201: ORDER BY ppf.person_id';
202:

Line 364: ,pay_payroll_actions ppa1

360: ,per_all_assignments_f paaf
361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1
365: ,pay_payroll_actions ppa2
366: ,pay_action_interlocks pai
367: ,pay_run_results prr
368: ,pay_input_values_f pivf

Line 365: ,pay_payroll_actions ppa2

361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1
365: ,pay_payroll_actions ppa2
366: ,pay_action_interlocks pai
367: ,pay_run_results prr
368: ,pay_input_values_f pivf
369: ,pay_element_types_f petf

Line 477: ,pay_payroll_actions ppa1

473: per_all_assignments_f paaf
474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1
478: ,pay_payroll_actions ppa2
479: ,pay_action_interlocks pai
480: ,pay_run_results prr
481: ,pay_input_values_f pivf

Line 478: ,pay_payroll_actions ppa2

474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1
478: ,pay_payroll_actions ppa2
479: ,pay_action_interlocks pai
480: ,pay_run_results prr
481: ,pay_input_values_f pivf
482: ,pay_element_types_f petf

Line 863: pay_payroll_actions ppa,

859: payroll_action_id
860: INTO
861: l_payroll_action_id
862: FROM
863: pay_payroll_actions ppa,
864: fnd_conc_req_summary_v fcrs,
865: fnd_conc_req_summary_v fcrs1
866: WHERE
867: fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID