APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_PAYROLL_ACTIONS

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

8: p_parameter_string IN VARCHAR2
9: ,p_token IN VARCHAR2
10: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
11: IS
12: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
13: l_start_pos NUMBER;
14: l_delimiter VARCHAR2(1):=' ';
15:
16: BEGIN

Line 72: FROM pay_payroll_actions

68: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
69: ,PAY_NO_SUPPORT_ORDER.GET_PARAMETER(legislative_parameters,'ARCHIVE')
70: ,effective_date
71: ,business_group_id
72: FROM pay_payroll_actions
73: WHERE payroll_action_id = p_payroll_action_id;
74:
75: BEGIN
76:

Line 286: ,pay_payroll_actions ppa

282:
283: -- the sql string to return
284: sqlstr := 'SELECT DISTINCT person_id
285: FROM per_people_f ppf
286: ,pay_payroll_actions ppa
287: WHERE ppa.payroll_action_id = :payroll_action_id
288: AND ppa.business_group_id = ppf.business_group_id
289: ORDER BY ppf.person_id';
290:

Line 510: ,pay_payroll_actions ppa

506:
507: FROM
508: pay_assignment_actions assact
509: ,pay_assignment_actions assact1
510: ,pay_payroll_actions ppa
511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg
514: ,pay_run_results prr

Line 511: ,pay_payroll_actions ppa2

507: FROM
508: pay_assignment_actions assact
509: ,pay_assignment_actions assact1
510: ,pay_payroll_actions ppa
511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg
514: ,pay_run_results prr
515: ,pay_run_result_values prrv

Line 512: ,pay_payroll_actions ppa3

508: pay_assignment_actions assact
509: ,pay_assignment_actions assact1
510: ,pay_payroll_actions ppa
511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg
514: ,pay_run_results prr
515: ,pay_run_result_values prrv
516: ,pay_input_values_f inpv

Line 756: ,pay_payroll_actions ppa

752: ,prr.source_id original_entry_id --source_id to set the context
753:
754: FROM
755: pay_assignment_actions assact
756: ,pay_payroll_actions ppa
757: ,per_all_assignments_f asg
758: ,per_all_people_f per
759: ,pay_run_results prr
760: ,pay_run_result_values prrv1

Line 1110: FROM pay_payroll_actions ppa,

1106:
1107: --fnd_file.put_line(fnd_file.log,'SUGARG: p_payroll_action_id IS NULL ');
1108: SELECT payroll_action_id
1109: INTO l_payroll_action_id
1110: FROM pay_payroll_actions ppa,
1111: fnd_conc_req_summary_v fcrs,
1112: fnd_conc_req_summary_v fcrs1
1113: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
1114: AND fcrs.priority_request_id = fcrs1.priority_request_id