eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_TEL dependencies on PAY_PAYROLL_ACTIONS

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

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:

Line 117: ,business_group_id BG_ID FROM pay_payroll_actions

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:

Line 330: ,pay_payroll_actions ppa

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:

Line 646: FROM pay_payroll_actions ppa

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

Line 647: ,pay_payroll_actions appa

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

Line 648: ,pay_payroll_actions appa2

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

Line 697: FROM pay_payroll_actions ppa,

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,

Line 698: pay_payroll_actions appa,

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,

Line 699: pay_payroll_actions appa2,

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

Line 1017: l_date_earned pay_payroll_actions.date_earned%TYPE;

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;

Line 1018: l_pre_date_earned pay_payroll_actions.date_earned%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;
1022: l_action_context_id NUMBER;

Line 1019: l_effective_date pay_payroll_actions.effective_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;
1023: g_archive_pact NUMBER;

Line 1020: l_pre_effective_date pay_payroll_actions.effective_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;
1024: p_assactid NUMBER;