DBA Data[Home] [Help]

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:

Line 62: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

58: )
59: RETURN DATE;
60:
61: TYPE override_date_record IS RECORD (
62: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
63: override_date pay_payroll_actions.overriding_dd_date%TYPE
64: );
65:
66: TYPE override_date_table IS TABLE OF override_date_record

Line 63: override_date pay_payroll_actions.overriding_dd_date%TYPE

59: RETURN DATE;
60:
61: TYPE override_date_record IS RECORD (
62: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
63: override_date pay_payroll_actions.overriding_dd_date%TYPE
64: );
65:
66: TYPE override_date_table IS TABLE OF override_date_record
67: INDEX BY BINARY_INTEGER;