APPS.PAY_PAYUSNAC_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 30: from pay_payroll_actions

26:
27:
28: end if;
29: select consolidation_set_id into cid
30: from pay_payroll_actions
31: where payroll_action_id = p_payroll_action_id;
32: c_consolidation_set_id := cid;
33:
34: begin

Line 122: from pay_payroll_actions

118: function get_cid return number is
119: cid number;
120: begin
121: select consolidation_set_id into cid
122: from pay_payroll_actions
123: where payroll_action_id = p_payroll_action_id;
124: c_consolidation_set_id := cid;
125: return cid;
126: end;

Line 140: from pay_payroll_actions a,

136: b.CONSOLIDATION_SET_NAME ||
137: decode(c.PAYROLL_NAME,null,null,'-') ||
138: c.PAYROLL_NAME
139: into ret
140: from pay_payroll_actions a,
141: pay_consolidation_sets b,
142: pay_payrolls_f c
143: where a.CONSOLIDATION_SET_ID = b.CONSOLIDATION_SET_ID
144: and a.PAYROLL_ID = c.PAYROLL_ID (+)

Line 160: pay_payroll_actions p2

156: begin
157: SELECT nvl(p1.pmeth_information6,'Y')
158: INTO v_flag
159: FROM pay_org_payment_methods_f p1,
160: pay_payroll_actions p2
161: WHERE p1.business_group_id = P_BUSINESS_GROUP_ID
162: AND p2.payroll_action_id = P_PAYROLL_ACTION_ID
163: AND p1.business_group_id = p2.business_group_id
164: AND p1.org_payment_method_id = p2.org_payment_method_id