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_US_PAYMENT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 38: p_business_group_id pay_payroll_actions.business_group_id%TYPE,

34: Function Name: get_trx_date
35: Description: Returns the Payment Date for a Check Payroll Action
36: ***************************************************************************/
37: FUNCTION get_trx_date (
38: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
39: p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41: DEFAULT NULL,
42: p_payroll_id pay_payroll_actions.payroll_id%TYPE

Line 39: p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

35: Description: Returns the Payment Date for a Check Payroll Action
36: ***************************************************************************/
37: FUNCTION get_trx_date (
38: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
39: p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41: DEFAULT NULL,
42: p_payroll_id pay_payroll_actions.payroll_id%TYPE
43: DEFAULT NULL,

Line 42: p_payroll_id pay_payroll_actions.payroll_id%TYPE

38: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
39: p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41: DEFAULT NULL,
42: p_payroll_id pay_payroll_actions.payroll_id%TYPE
43: DEFAULT NULL,
44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE
45: DEFAULT NULL,
46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE

Line 44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE

40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41: DEFAULT NULL,
42: p_payroll_id pay_payroll_actions.payroll_id%TYPE
43: DEFAULT NULL,
44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE
45: DEFAULT NULL,
46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE
47: DEFAULT NULL,
48: p_effective_date pay_payroll_actions.effective_date%TYPE

Line 46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE

42: p_payroll_id pay_payroll_actions.payroll_id%TYPE
43: DEFAULT NULL,
44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE
45: DEFAULT NULL,
46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE
47: DEFAULT NULL,
48: p_effective_date pay_payroll_actions.effective_date%TYPE
49: DEFAULT NULL,
50: p_date_earned pay_payroll_actions.date_earned%TYPE

Line 48: p_effective_date pay_payroll_actions.effective_date%TYPE

44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE
45: DEFAULT NULL,
46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE
47: DEFAULT NULL,
48: p_effective_date pay_payroll_actions.effective_date%TYPE
49: DEFAULT NULL,
50: p_date_earned pay_payroll_actions.date_earned%TYPE
51: DEFAULT NULL,
52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE

Line 50: p_date_earned pay_payroll_actions.date_earned%TYPE

46: p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE
47: DEFAULT NULL,
48: p_effective_date pay_payroll_actions.effective_date%TYPE
49: DEFAULT NULL,
50: p_date_earned pay_payroll_actions.date_earned%TYPE
51: DEFAULT NULL,
52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE
53: DEFAULT NULL,
54: p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE

Line 52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE

48: p_effective_date pay_payroll_actions.effective_date%TYPE
49: DEFAULT NULL,
50: p_date_earned pay_payroll_actions.date_earned%TYPE
51: DEFAULT NULL,
52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE
53: DEFAULT NULL,
54: p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE
55: DEFAULT NULL,
56: p_payment_date pay_payroll_actions.effective_date%TYPE

Line 56: p_payment_date pay_payroll_actions.effective_date%TYPE

52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE
53: DEFAULT NULL,
54: p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE
55: DEFAULT NULL,
56: p_payment_date pay_payroll_actions.effective_date%TYPE
57: DEFAULT NULL
58: )
59: RETURN DATE
60: IS

Line 78: FROM pay_payroll_actions

74: cp_date_earned IN DATE
75: )
76: IS
77: SELECT overriding_dd_date
78: FROM pay_payroll_actions
79: WHERE business_group_id = cp_business_group_id
80: AND payroll_action_id = cp_payroll_action_id
81: AND payroll_id = NVL (cp_payroll_id, payroll_id)
82: AND consolidation_set_id =

Line 109: FROM pay_payroll_actions ppa_chk,

105: cp_pre_payment_id IN NUMBER
106: )
107: IS
108: SELECT NVL (ppa_chk.overriding_dd_date, ppa_pre.effective_date)
109: FROM pay_payroll_actions ppa_chk,
110: pay_assignment_actions paa_chk,
111: pay_payroll_actions ppa_pre,
112: pay_assignment_actions paa_pre,
113: pay_action_interlocks pai,

Line 111: pay_payroll_actions ppa_pre,

107: IS
108: SELECT NVL (ppa_chk.overriding_dd_date, ppa_pre.effective_date)
109: FROM pay_payroll_actions ppa_chk,
110: pay_assignment_actions paa_chk,
111: pay_payroll_actions ppa_pre,
112: pay_assignment_actions paa_pre,
113: pay_action_interlocks pai,
114: pay_pre_payments ppp
115: WHERE ppa_chk.payroll_action_id = cp_payroll_action_id

Line 150: pay_payroll_actions ppa

146: IS
147: SELECT ppa.effective_date
148: FROM pay_pre_payments ppp,
149: pay_assignment_actions paa,
150: pay_payroll_actions ppa
151: WHERE ppp.pre_payment_id = cp_pre_payment_id
152: AND ppp.assignment_action_id = paa.assignment_action_id
153: AND paa.payroll_action_id = ppa.payroll_action_id
154: AND ppa.action_type IN ('P', 'U');

Line 156: l_override_date pay_payroll_actions.overriding_dd_date%TYPE;

152: AND ppp.assignment_action_id = paa.assignment_action_id
153: AND paa.payroll_action_id = ppa.payroll_action_id
154: AND ppa.action_type IN ('P', 'U');
155:
156: l_override_date pay_payroll_actions.overriding_dd_date%TYPE;
157: l_table_count NUMBER;
158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);