53: p_parameter_string IN VARCHAR2
54: ,p_token IN VARCHAR2
55: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
56: IS
57: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
58: l_start_pos NUMBER;
59: l_delimiter VARCHAR2(1):=' ';
60: l_proc VARCHAR2(40):= g_package||' get parameter ';
61:
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
117: ,business_group_id BG_ID FROM pay_payroll_actions
118: WHERE payroll_action_id = p_payroll_action_id;
119:
120: lr_parameter_info csr_parameter_info%ROWTYPE;
121:
326: END IF;
327:
328: p_sql := 'SELECT DISTINCT person_id
329: FROM per_people_f ppf
330: ,pay_payroll_actions ppa
331: WHERE ppa.payroll_action_id = :payroll_action_id
332: AND ppa.business_group_id = ppf.business_group_id
333: ORDER BY ppf.person_id';
334:
642: IS
643: SELECT act.assignment_id assignment_id,
644: act.assignment_action_id run_action_id,
645: act1.assignment_action_id prepaid_action_id
646: FROM pay_payroll_actions ppa
647: ,pay_payroll_actions appa
648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
643: SELECT act.assignment_id assignment_id,
644: act.assignment_action_id run_action_id,
645: act1.assignment_action_id prepaid_action_id
646: FROM pay_payroll_actions ppa
647: ,pay_payroll_actions appa
648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
651: ,pay_action_interlocks pai
644: act.assignment_action_id run_action_id,
645: act1.assignment_action_id prepaid_action_id
646: FROM pay_payroll_actions ppa
647: ,pay_payroll_actions appa
648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
651: ,pay_action_interlocks pai
652: ,per_all_assignments_f as1
693: IS
694: SELECT act.assignment_id assignment_id,
695: act.assignment_action_id run_action_id,
696: act1.assignment_action_id prepaid_action_id
697: FROM pay_payroll_actions ppa,
698: pay_payroll_actions appa,
699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
694: SELECT act.assignment_id assignment_id,
695: act.assignment_action_id run_action_id,
696: act1.assignment_action_id prepaid_action_id
697: FROM pay_payroll_actions ppa,
698: pay_payroll_actions appa,
699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
702: pay_action_interlocks pai,
695: act.assignment_action_id run_action_id,
696: act1.assignment_action_id prepaid_action_id
697: FROM pay_payroll_actions ppa,
698: pay_payroll_actions appa,
699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
702: pay_action_interlocks pai,
703: per_all_assignments_f as1
1013: l_end_date per_time_periods.end_date%TYPE;
1014: l_pre_end_date per_time_periods.end_date%TYPE;
1015: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1016: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1017: l_date_earned pay_payroll_actions.date_earned%TYPE;
1018: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1019: l_effective_date pay_payroll_actions.effective_date%TYPE;
1020: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1021: l_run_payact_id NUMBER;
1014: l_pre_end_date per_time_periods.end_date%TYPE;
1015: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1016: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1017: l_date_earned pay_payroll_actions.date_earned%TYPE;
1018: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1019: l_effective_date pay_payroll_actions.effective_date%TYPE;
1020: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1021: l_run_payact_id NUMBER;
1022: l_action_context_id NUMBER;
1015: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1016: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1017: l_date_earned pay_payroll_actions.date_earned%TYPE;
1018: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1019: l_effective_date pay_payroll_actions.effective_date%TYPE;
1020: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1021: l_run_payact_id NUMBER;
1022: l_action_context_id NUMBER;
1023: g_archive_pact NUMBER;
1016: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1017: l_date_earned pay_payroll_actions.date_earned%TYPE;
1018: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1019: l_effective_date pay_payroll_actions.effective_date%TYPE;
1020: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1021: l_run_payact_id NUMBER;
1022: l_action_context_id NUMBER;
1023: g_archive_pact NUMBER;
1024: p_assactid NUMBER;