DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_UTIL dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 75: based on entry in pay_legislative_field_info table.

71: Purpose : This functtion is being called by PAY_EMPLOYEE_ACTION_INFO_V
72: view using argument mentioned below.
73:
74: This function returns Organization ID or Tax Unit ID (GRE ID)
75: based on entry in pay_legislative_field_info table.
76:
77: Arguments : IN
78: p_business_group_id number
79: p_tax_unit_id number

Line 91: from pay_legislative_field_info

87: RETURN NUMBER IS
88:
89: cursor get_legi_rule(cp_legislation_code varchar2) is
90: select rule_mode
91: from pay_legislative_field_info
92: where legislation_code = cp_legislation_code
93: and field_name = 'CHOOSE_PAYSLIP'
94: and validation_name = 'ITEM_PROPERTY'
95: and validation_type = 'DISPLAY'

Line 135: from pay_legislative_field_info

131: RETURN VARCHAR2 IS
132:
133: cursor get_legislative_rule(cp_legislation_code varchar2) is
134: select rule_mode
135: from pay_legislative_field_info
136: where legislation_code = gv_legislation_code
137: and field_name = 'ACTION_INFO_STATE'
138: and validation_name = 'ITEM_PROPERTY'
139: and validation_type = 'DISPLAY'